View in real-time or over any prior time period SQL statement wait types with their wait times. View wait times by month, week, hour, minute or second. Drill into any time interval to view of the resource contention causing SQL statements to not complete on a timely basis. Filter what is viewed by wait time, wait type, SQL statement, stored procedure, client host, database, end-user response time, wait time or time period. Be alerted in real-time to wait conditions causing server bottlenecks. Reducing SQL wait time -> reduces end-user response time -> improves server throughput. In most cases this can eliminate an expensive and unnecessary hardware upgrade.

View in real-time or over any prior time period Stored Procedure wait times. Also simultaneously view any subset of the performance counters over the same time period. Reducing SQL wait time -> reduces end-user response time -> improves server throughput. In most cases this can eliminate an expensive and unnecessary hardware upgrade.

View in real-time or over any prior time period wait times by wait type. Also simultaneously view any subset of the performance counters over the same time period. Reducing SQL wait time -> reduces end-user response time -> improves server throughput. In most cases this can eliminate an expensive and unnecessary hardware upgrade.

View in real-time or over any prior time period SQL statement wait types with their wait times. View wait times by month, week, hour, minute or second. Drill into any time interval to view of the resource contention causing SQL statements to not complete on a timely basis. Filter what is viewed by wait time, wait type, SQL statement, stored procedure, client host, database, end-user response time, wait time or time period. Be alerted in real-time to wait conditions causing server bottlenecks. Reducing SQL wait time -> reduces end-user response time -> improves server throughput. In most cases this can eliminate an expensive and unnecessary hardware upgrade.

Pinpoint SQL statements having high I/O, CPU usage and poor plans! These cause poor end-user responser time and high database server overhead. View in real-time or over any prior time period the SQL statements having plans that contain table scans, columns with no statistics, missing indexes, sorts, lookups, plan compilation timeouts and more.

View in real-time the performance of the entire server farm or any subset of it in 3D. Any subset of the performance metrics may be viewed. One 3D picture tells it all. The servers and performance metrics of interest are automatically updated in real-time. Move the mouse over a graph point and a popup data tip will explain the current server farm performance. Double click on a graph point and all of the server's current plus most recent SQL activity (using ZERO impact SQL capture architecture) with its performance will be displayed.

View in real-time the performance of the entire server farm or any subset of it in a 3D column chart. Any subset of the performance metrics may be viewed. One 3D picture tells it all. The servers and performance metrics of interest are automatically updated in real-time. Move the mouse over a graph point and a popup data tip will explain the current server farm performance. Double click on a graph point and all of the server's current plus most recent SQL activity (using ZERO impact SQL capture architecture) with its performance will be displayed.

View in real-time the performance of the entire server farm or any subset of it in a 3D line chart. Any subset of the performance metrics may be viewed. One 3D picture tells it all. The servers and performance metrics of interest are automatically updated in real-time. Move the mouse over a graph point and a popup data tip will explain the current server farm performance. Double click on a graph point and all of the server's current plus most recent SQL activity (using ZERO impact SQL capture architecture) with its performance will be displayed.

View in real-time the performance of any subset of the server farm in 2D. The servers of interest are automatically updated in real-time. Move the mouse over a graph point and a popup data tip will explain the current server farm performance. Double click on a graph point and all of the server's current plus most recent SQL activity (using ZERO impact SQL capture architecture) with its performance will be displayed.

View in a single 3D graph the database space usage for the entire server farm or any subset of it. Move the mouse over a graph point and a popup data tip will explain the database space usage.

View in a single 3D graph the database space usage for the entire server farm or any subset of it. Move the mouse over a graph point and a popup data tip will explain the database space usage.

View in a single 3D graph the disk space usage for the entire server farm or any subset of it. Disk space usage for each Server Farm database server's disk drive is summarized in MB by drive free space, other file disk drive space (non database file), database data file and database log file space usage. Move the mouse over a graph point and a popup data tip will explain the disk space usage.

View in a single 3D graph the disk space usage for the entire server farm or any subset of it. Move the mouse over a graph point and a popup data tip will explain the disk space usage.

View in a single 3D graph the procedure cache usage for the entire server farm or any subset of it. Identifies when cache bloat is occuring in OLTP environments due to infrequently used ad hoc SQL statement plans. Cache bloat causes CPU and memory pressure; as well as expensive SQL statement compilations. Move the mouse over a graph point and a popup data tip will explain the procedure cache usage.

View in a single 3D graph the procedure cache usage for the entire server farm or any subset of it. Cache usage for each database server is summarized in MB for ad hoc SQL (not good for OLTP), prepared SQL statements, stored procedures, views, computed columns and other type of (rules, etc.) query plans. Move the mouse over a graph point and a popup data tip will explain the procedure cache usage.

View in a single 3D graph the buffer cache usage for the entire server farm or any subset of it. For a server view the buffer cache usage by database. For a database view the buffer cache space usage by data, text and indexes. Move the mouse over a graph point and a popup data tip will explain the buffer cache usage.

Contains the main navigation tree for all monitored database servers. Database server health issues are updated on a real-time basis. Server farm trees for all performance issues or trees specific to only SQL Agent jobs may be viewed in real-time. You can drill down into a server's peformance from a server farm tree. Server farm trees can be minimized when viewing the performance of servers.

View a Big Picture rolling view of a server's performance. Includes basic and advanced cockpits and dashboards. You can dynamically change the rolling graph of displayed performance counters. Double click on a graph point and all of the server's current plus most recent SQL activity (using ZERO impact SQL capture architecture) with its performance will be displayed.

When CPU or disk utilization of the database server is high, CPU or disk queue is long, SQL re-compilations are excessive, table scans are occurring, page splits are frequent, or any Windows performance counter value is high; you can immediately reconstruct and view the exact SQL that ran during the time period when any performance counter metric was poor. Double click on any graphed performance counter and the corresponding SQL statements that ran will be graphed!

Real time capture and monitoring of 100% of the SQL activity with ZERO impact - includes complete SQL text and .NET bind variables. Since 80% of all database performance issues are related to poor performing SQL, the ability to pinpoint the poor performing SQL is crucial. The monitoring component should be installed on the database server host. Then it can non-intrusively capture/monitor 100% of the SQL activity 24x7. This is very valuable. Double click on any graphed SQL statement and the corresponding performance counters will be graphed for the time period the SQL statement ran over!

Stealth architecture captures and monitors the SQL statement performance of poor performing SQL statements in embedded stored procedures and triggers.

Filter, exclude or include SQL statements by time, end user or database server response time, network time, rows returned, login id, application, database, server, client IP address, process id, errors, key words in SQL statement text and more.

Be informed of the SQL (plus stored procedures and packages) that execute most frequently and use the most resources (with Zero Impact). Pinpoint the SQL statements and stored procedures whose average end-user response time and performance falls before a daily, monthly or quarterly moving average. Tracks the performance of the 2K to 4K unique SQL statements that run on a server. Ad hoc Top N SQL Analysis over any prior time period (e.g. the SQL activity from 4 hours ago) pinpoints SQL performance issues when server performance was poor.

View a specific Top N Sql statements avg end user response or database server processing time over the business day

Blocked process tree graph includes the SQL text, resource usage, blocked time, and the locks held for every SQL statement involved in a blocking incident. The SQL most frequently either causing or involved in blocking is also summarized.

View a ranking of the SQL statements most commonly involved in database blocking.

View all in progress SQL Agent jobs in your server farm from your web browser. View job and job step historical performance for any subset of the server farm over any prior time period. Be alerted to short and long running jobs plus job failures , cancels and retrys. End of report summarizes job baseline performance issues, failures, cancels and retrys. Product automatically alerts you to server farm jobs or job steps that run 30% longer than their average run time.

Track the actual response time an end user receives by their login id. Real-time alerts may be sent when an end-user's average response time (or their SQL statement response time) exceeds a threshold. End User Experience baseline analysis identifies the end-users experiencing a response time poorer than prior baseline time periods.

Reports for every server in the database server farm the SQL Agent jobs, job steps, performance metrics and SQL statements whose performance degraded from a prior baseline time period. Ad hoc comparison of server performance may be performed at any time. Immediately know the impact of changes in hardware, database server configuration adjustments, table index changes, SQL code changes and new application releases.

Reports for every server in the database server farm the SQL Agent jobs, job steps, performance metrics and SQL statements whose performance degraded from a prior baseline time period. Ad hoc comparison of server performance may be performed at any time. Immediately know the impact of changes in hardware, database server configuration adjustments, table index changes, SQL code changes and new application releases.

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 degraded a prior baseline time period by a threshold percentage or value. Ad hoc comparison of server performance may be performed at any time. Immediately know the impact of SQL code changes and new application releases.