icon_CloudMgmt icon_DollarSign icon_Globe icon_ITAuto icon_ITOps icon_ITSMgmt icon_Mainframe icon_MyIT icon_Ribbon icon_Star icon_User icon_Users icon_VideoPlay icon_Workload icon_caution icon_close s-chevronLeft s-chevronRight s-chevronThinRight s-chevronThinRight s-chevronThinLeft s-chevronThinLeft s-trophy s-chevronDown
BMC

Maximize SQL visibility, eliminate wasteful SQL statements, and optimize your workload access paths and indexing strategy with BMC AMI SQL Performance for Db2® (previously Performance for Db2® SQL).

Manage SQL performance throughout the application lifecycle

  • Identify and tune resource-intense SQL statements to reduce CPU consumption
  • Improve performance and availability
  • Diagnose and track performance problems to their source
  • Anticipate SQL-related slowdowns so you can resolve them early
  • Ensure your SQL runs efficiently and cost effectively
BMC AMI SQL Performance Db2

Connect with a database management expert

Contact BMC Sales

Optimize SQL performance and diagnose problems

Optimize SQL performance and tuning with low overhead

Manage Performance

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

Quickly diagnose and track problems

Diagnose Problems

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
“We realized that if we didn’t do something to reduce consumption, we would need an additional CPU upgrade. So we began an IT-wide tuning initiative and used our BMC tools to find ways to improve performance and reduce MIPS.” — Terry Glover, Director, Technical Architecture and Support, Dillard’s
View all customer stories

Get started with BMC AMI SQL Performance for Db2®