Zero Impact Performance Divergence Monitor
Pinpoint performance counters and SQL statements whose performance diverged from a historical baseline
Performance Divergence Monitor
Top Features
  • Performance Divergence Analysis for database server farms
  • Immediately know the database servers in the server farm that had performance counters and SQL statements with poorer performance than their weekly, monthly, quarterly or annual baseline.
  • Reports for every server in the database server farm the servers that had SQL statements with performance that exceeded a prior time period’s baseline by a threshold percentage or value.
The Performance Divergence Monitor reports daily the performance metrics and SQL statements whose performance diverged from a weekly, monthly, quarterly or annual performance baseline.

View in a 100% web enabled interface server farm performance divergences. A PDF report of performance divergences may also be emailed to management and the DBA team. Sql Power Tools unique usage of 3D visualization from a web browser allows the server farm performance divergences to be viewed in a single 3D picture.

Performance counter divergence:

For the Windows operating system performance counters and SQL Server performance counters, the product reports for every database server in the server farm the servers that had performance counters that exceeded a prior time period’s baseline by a threshold percentage or value.

SQL statement performance divergence:

For the application SQL that 80% of all database performance issues are caused by, the product reports for every server in the database server farm the servers that had SQL statements with performance that exceeded a prior time period’s baseline by a threshold percentage or value. Most database server applications contain 2,000+ unique SQL statements that client applications invoke 50 million+ time a day, the performance divergence of every unique SQL statement for every database server is tracked and reported.

How database server farm performance divergence analysis may be used in production environments:

Open a web browser and view any of the following with 3D visualization:
  1. Servers prod1 and prod50’s total CPU usage was 6% higher than last week’s CPU usage.
  2. Servers prod19 and prod250’s disk usage was 15% higher than last month’s disk utilization.
  3. Servers prod30 and prod8’s average end-user response time was 13% higher than the prior month.
  4. Servers prod3 and prod7’s average network time for SQL statements was 17% higher than the prior month.
  5. Servers prod35 and prod80’s database blocking incidents were 12% higher than the prior quarter.
  6. Servers prod25 and prod70’s deadlock incidents were 14% higher than the prior quarter.
  7. Servers prod51 and prod100’s SQL table scans yesterday were 25% higher than the prior year.
  8. Servers prod41 and prod150’s SQL re-compilations yesterday were 20% higher than the prior week.
  9. Servers prod41 and prod120’s average wait-time for locks were 30% higher than the prior week.
  10. Server prod71’s SQL Server CPU usage between 2pm and 4 pm was 25% higher than 10 am and 12 pm.
  11. Compare the capacity and performance of server prod7 to the servers prod44, prod51 and prod88.
  12. Server prod5 had 8 of its 4,000 unique SQL statements run 18% longer than yesterday. 12 of its SQL statements ran 15% longer than their baseline over the past week.
How divergence analysis may be used in migrating to SQL Server 2008:

To pinpoint the performance divergences between applications previously running on SQL Server 2000 and 2005; and that have been migrated to SQL Server 2008.

How divergence analysis may be used in QA environments:

To pinpoint the performance divergences between this application turnover and last quarter’s turnover.

This product is currently available for Microsoft SQL Server.
Free Trial
Free Trial
Download your free evaluation for full access to all Sql Power Tools features.
Take a Tour
Take a Tour
Join an interactive product simulation on database server farm monitoring by clicking here.
Looking to Upgrade
Looking to Upgrade
Already licensed a competing product? We're convinced you will want to make the switch to Sql Power Tools. Click here for more information.
Sql Power Tools awarded Community Choice Best Database Monitoring and Performance Product by SQL Server Magazine Sql Power Tools awarded Best Database Monitoring and Performance Product Community Choice Gold by SQL Server Magazine 2009.
Customers
The Zero Impact Performance Divergence Monitor is released. Offers early warning of deteriorating performance in SQL Server database server farms. Analyzes performance trends and deviations from historical baselines to identify which performance metrics and SQL statements are deteriorating from a prior rolling time period or historical baseline. Read more.
" After years as a DBA, I can tell you there is absolutely nothing on the market that compares to the Zero Impact Sql Monitor product line...it is the best performance investment you will ever make. "
Frank LaDue
Advanced Technology Company

Live Support