BMC AMI SQL Performance for Db2^®

BMC AMI SQL Performance for Db2^® is a complete solution that manages SQL performance throughout the application lifecycle and audits privileged access to reduce risk.

• Perform SQL tuning with lower overhead and a focus on where resources are spent
• Validate SQL during development to ensure valid access paths and uphold SQL best practices
• Gather, manage, and understand historical performance data for trends and forecasting
• Analyze index usage, including identifying unused indexes and modeling index changes, to improve your indexing strategy

Incident and problem management in the database is easy with BMC AMI SQL Performance for Db2^®.

• Rapidly diagnose and track performance problems to their source
• Increase availability by pinpointing resource-consuming SQL statements without running expensive SQL traces
• Anticipate and resolve slowdowns to avoid bad SQL, bad access paths, and costly CPU upgrades
• Evaluate space and performance metrics to determine when reorganization is necessary
• Avoid change and migration problems by comparing workload access paths