Monitor database performance with query analysis and optimization recommendations
Database Performance Monitoring
advanced low risk Monitoring
Description
Prerequisites
- Database access permissions
- Performance monitoring tools
- Baseline metrics established
Parameters
monitoringDuration
Number*Duration of monitoring in minutes
Default: 60
includeSlowQueries
BooleanInclude slow query analysis
Default: true
includeIndexAnalysis
BooleanInclude database index analysis
Default: true
generateRecommendations
BooleanGenerate optimization recommendations
Default: true
alertThreshold
NumberQuery execution time threshold for alerts (ms)
Default: 5000
Script Code
database-performance-monitoring.groovyScript Information
Author:SAP Commerce Expert
Execution Time:60-180 minutes
Rating:4.8/5
Downloads:920
Last Updated:2024-01-15
Version:2.0.0
Tags
tools.groovyScriptLibrary.ui.title
tools.groovyScriptLibrary.ui.subtitle