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!
• End-user experience monitoring monitors the response time end-users actually received by end-user login id.
• Non-intrusive ZERO impact SQL capture allows every production SQL statement to be captured with it's performance. Requires no intrusive server profiles or traces that degrade performance up to 60%.
• Competing products do not sniff the network to capture 100% of the SQL activity. This results in a poor Top N SQL analysis.
• Top N SQL analysis of the 4,000+ unique SQL statements running on each of your database servers.
• Blocked process detection with a blocked process tree showing all locks and SQL text.
• Windows and database server performance counter monitoring with a big picture roll-up.
• Historical reconstruction of server performance over any prior point in time.
• Alerting and filtering of SQL statement performance, performance counters, blocking, end-user experience and SQL Agent jobs.
• 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 increase in CPU usage, disk I/O, table scans, blocking, lock waits and much more.
• Know the SQL statements out of the 4,000 unique SQL statements running on a database server that had an increase in end-user response time from a prior baseline time period.
• Pinpoints in the server farm performance counters, SQL statements and SQL Agent jobs that have a poorer performance than any prior baseline time period.

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 SQL statements, performance counters and SQL Agent jobs that are performing poorer than prior SQL Server releases.

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 any prior baseline time period.

View in 3D degrading server farm performance from prior baseline time periods!