80% of database server performance issues are due to SQL, knowing the current and historical performance of every production SQL statement is a requirement to providing consistent end-user response time to all
end-users.

Key Features:

• Database server farm monitoring with 3D visualization from a 100% web enabled interface. One 3D picture of your entire server farm’s performance pinpoints performance bottlenecks. One picture tells it all!
• 3D Dashboard views of performance by database server with drill down.
• Non-intrusive ZERO impact SQL capture allows every production SQL statement to be captured with it's performance metrics. Requires no intrusive server profiles or traces that degrade performance up to 60%.
• Blocked process, lock, contention and table scan monitoring.
• Top N SQL performance analysis of the 4,000+ unique SQL statements running on each of your database servers.
• Competing products do not sniff the wire or capture 100% of the SQL which does not provide an accurate Top N SQL analysis.
• Windows and database server performance counter monitoring with a big picture roll-up.
• Performance monitoring with historical reconstruction of server performance for any prior point in time.
• Monitors end-user service levels 24x7.
• Alerting and filtering of SQL and performance counters.
• Historical baseline comparisons.
• Free product training.

When server performance is poor or when end-users experience poor end-user response time, reconstruct the exact SQL statements that were running with the critical performance counter values over that period of time.

Learn 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.

Key Features:

• Identifies servers in the server farm experiencing a percentage increase in CPU usage, disk I/O, table scans, blocking, lock waits and much more.
• 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 over yesterday; or a prior time period such as the last week or month.
• Windows performance counters and SQL statements that had a poorer performance percentage than any baseline, prior business day, week, month, quarter or year.

One 3D visualization in a 100% web enabled user interface of the degrading performance of your server farm tells it all!

Make migration to SQL Server 2008 a snap! Immediately know the performance counters and SQL statements that are performing poorer on SQL Server 2008.

Non-intrusive ZERO Impact SQL capture allows every production server SQL statement with it's performance to be captured 24x7. Requires no intrusive server profiles or traces that degrade the server performance by 25% to 60% (SQL Server Magazine, August 2008). Since 80% of database server performance problems are due to SQL, knowing the current and historical performance of every production SQL statement is a requirement to providing consistent end-user response time to all end-users.

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 the prior day, week, month, quarter or year.