SQL Performance Analyzer

Changes that affect SQL execution plans can severely impact system performance and availability. As a result, DBAs spend an enormous time in identifying and fixing SQL statements that have regressed due to the system change. SPA provides fine-grain assessment of environment change on SQL execution plan and statistics by running the SQL statements in isolation and serial manner in before-change and after-change environments. SPA functionality is well integrated with existing SQL Tuning Set (STS), SQL Tuning Advisor, and SQL Plan Management functionality. As a result, SPA completely automates and simplifies the manual and time consuming process of assessing the impact of change on even extremely large SQL workloads (thousands of SQL statements) and automating the remediation of any SQL regressions as a result of the system change.