In ONE mouse click drill into 120+ performance monitoring areas!
Fifteen SQL Server licenses: $15,000 or $1,000 per license.
Fifty SQL Server licenses: $25,000 or $500 per license.
Cannot pinpoint what is causing poor database server throughput? Where the server bottlenecks are? What is causing long SQL response time? Our agentless wait state monitoring can!
- Agentless server bottleneck monitoring (wait state monitoring). The wait types (600+ that a database server posts) causing SQL statements and stored procedures to not complete on a timely basis due to resource contention or being queued due to a lack of available resources are monitored. Wait condition wait times are tracked by SQL statement, stored procedure, wait type, application, database and the end-user client. Reducing SQL wait time -> reduces end-user response time -> improves server throughput. In most cases this can eliminate an expensive and unnecessary hardware upgrade.
- Automatic drill down into the wait types, wait times and performance counters for any poor performing SQL. Pinpoints the resource contention on the server that is causing the SQL statement to not complete on a timely basis! Just double click on any SQL statement displayed in the web browser interface. View historical SQL wait type history by year, month, week, day, hour and drill down to a one second view of SQL statement wait times.
- Stealth wait state monitoring when the Zero Impact Agent SQL Agent is enabled. With stealth wait state monitoring wait times are only investigated when a SQL statement on the server runs longer than N seconds. E.g. 100 milli seconds. This provides the lowest monitoring overhead for any wait state monitoring product in the industry!
- Agentless SQL statement I/O monitoring with automated plan mining. Low agentless monitoring overhead. Pinpoints SQL statements having high I/O, high CPU usage, long run times and poor plans! These cause poor end-user response 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. NO intrusive profiler sessions or traces are used that potentially degrade server performance by 30% and impact server I/O throughput.
- Database data and log file I/O stall/wait time monitoring monitors the I/O wait time for all database devices/files.
- End-user experience monitoring monitors the response time end-users actually receive for 100% of SQL activity when the Zero Impact SQL Capture Agent is enabled.
- Database and disk drive space usage monitoring monitors the space usage and availability in 3D graphs. View the entire Server Farm database or disk drive space usage in one 3D graph.
- Procedure cache and buffer cache monitoring monitors memory usage in 3D graphs. View the entire Server Farm procedure cache or buffer cache usage in one 3D graph.
- TempDB monitoring. Pinpoints all SQL statements, wait types, applications, end-users and stored procedures experiencing a wait condition/wait time on the TempDB database and files. Average I/O stall times on all TempDb data and log files are monitored as well as the number of I/O operations and throughput on all TempDB data and log files.
- Ad hoc comparison of end-user response time, SQL performance, wait times, I/O bottlenecks, performance counters and job run times between servers and time periods.
- View server performance in real-time or over any prior time period in 3D graphs.
- Preconfigured alert thresholds are available. Baseline analysis will also automatically calculate alert thresholds.
- Low low agentless monitoring overhead on monitored servers.
- 100% web enabled. No client workstation installs. Nothing is placed on monitored servers. Free product setup and training.
- Product provides an immediate ROI.
A daily baseline analysis of the day's performance is compared in 3D graphs to prior time periods for all SQL requests. Increases or decreases in end-user response time by SQL request and wait type are identified.
Baseline analysis identifies wait types, I/O bottleneck wait times by database device, SQL response time, performance counters and SQL jobs that have degraded or are improved.
Most importantly SQL statements, stored procedures, wait types, applications, databases and the end-user clients that have increasing wait times (i.e. increasing end-user response time) are immediately identified.
Proactively address performance issues before end-user response time is impacted.