Non-intrusive ZERO impact SQL capture allows every SQL statement to be captured with its performance metrics. Requires no intrusive server profiles or traces that degrade server performance by 25% to 60% (SQL Server Magazine, August 2008). 80% of database server performance issues are due to SQL, tracking the performance of every SQL statement is a requirement to providing consistent end-user response time to all end-users.

Know when the next server slowdown is about to occur? You will now.

Be informed of server farm performance slowdowns and degrading SQL statement performance before your end-users contact you about poor performance! Allows trending performance issues to be identified and corrected before the database operations are impacted. Identifies servers in the server farm experiencing a percentage increase in CPU usage, disk I/O, table scans, blocking, lock waits and much more.

Identifies the N SQL statements out of the 4,000 unique SQL statements running on a database server that had a percentage increase in end-user response time from a baseline, over yesterday; or a prior time period such as the last week or month.

One 3D visualization of degrading server farm performance tells it all!

Emails a daily report of the performance counters and SQL statements that had degrading performance from a prior baseline period or prior rolling period (prior day, rolling week, month, quarter, etc.).

A single 3D real-time visualization of the server farm performance identifies the performance bottlenecks in the server farm.

View in 3D the database server performance counters that have diverged (degraded) from a baseline period or alert thresholds. In one picture view the diverging (degrading) performance counters and end-user service levels for a database server.

Double click any end-user service level or performance counter graph for any database server and the exact SQL that was running will be displayed in your web browser. View the SQL that is running now, ran an hour ago, last week or last month.

Our ZERO impact architecture captures 100% of the SQL activity. Most database servers have their 4,000 unique application SQL statements run at least 10+ million times during the business day. Sql Power Tools will track for each unique SQL statement it's deviation in performance from a baseline or the prior day, rolling week, rolling month, rolling quarter or year.

Database blocking analysis shows the complete blocked process tree. Includes a ranking of the SQL most often causing blocking.

Requires no intrusive server profiles or traces that degrade server performance by 25% to 60% (SQL Server Magazine, August 2008). 80% of database server performance issues are due to SQL, tracking the performance of every SQL statement is a requirement to providing consistent end-user response time to all end-users.

Easy to use user interface that is 100% web enabled.

All customers receive free product training.