Immediately pinpoint in ONE mouse click server farm performance hotspots in a summary dashboard, SQL wait times, I/O wait times, TempDb contention, Top N SQL, SQL with poor plans, SQL with high I/O, SQL having degraded performance, blocking, deadlocks, performance counters, SQL agent job issues, index fragmentation issues, low disk space and high disk space growth issues, buffer cache usage, procedure cache usage, backup issues, VMware performance and more.

View in 3D graphs SQL wait times, I/O wait times, performance counters, database space usage, disk drive space usage, procedure cache usage, buffer cache usage and the results of the baseline analysis for the entire Server Farm.

Monitoring of wait conditions, wait times, I/O bottlenecks, SQL performance, performance counters, blocking, database space, disk drive space, procedure cache, buffer cache and SQL jobs is performed using an agentless monitoring architecture.

Unlike many other monitoring tools, Sql Power Tools has a LOW overhead on the monitored servers. Nor will it miss important monitoring events.

Our agentless monitor's CPU, TempDB I/O and network overhead on the monitored servers is a FRACTION of other monitoring solutions.

We do NOT issue millions of I/O requests to the monitored server's TempDB database thereby impacting the throughput of monitored server's disk sub-system and SQL end-user response time.

Nor do we FILL the monitored server's plan cache with ad hoc SQL monitoring requests that potentially force production SQL out of plan cache thereby increasing CPU pressure, memory pressure and cause needless SQL re-compilations.

Millions of characters of monitoring SQL text are not sent 24x7 across the network impacting the performance of the network.

Annual cost of operation is minimal. Monitoring solutions having a high overhead on monitored servers may have a cost of operation that exceeds their license fee.

THe SYSADMIN privilege or role is NOT needed for agentless monitoring of any monitored database server or the product database repository.

Our agentless wait state monitoring can! We monitor the 600+ wait conditions that a database server posts when a SQL statement cannot move forward to completion on a timely basis due to resource contention or being queued due to a lack of available resources. Wait condition wait times are tracked by SQL statement, stored procedure, wait type, 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.

The wait conditions (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, 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.

Stealth wait condition and state monitoring is available when our 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! Important for production monitoring.

Drill down into wait conditions and wait times from a weekly, daily or hourly summary of wait times down to the exact SQL that was running with its resource usage.

When a long running SQL statement is observed drill down into the corresponding wait conditions and performance counters.

When a poor performance counter value is observed drill down to the exact SQL that was running

Our FREE Zero Impact SQL Capture Agent can! Has a low 1% overhead on the monitored server. Optionally install and dynamically enable/disable the agent at any time.

Use it when you need it to pinpoint poor performing SQL on production servers or when regression testing applications. Think of it as a ZERO impact SQL profiler or trace facility. No intrusive server profiles or traces are used that degrade server performance by 30% to 60%. Ineffective SQL sampling is not used. Agent does not connect to the monitored server nor impact the network.

Optionally install and dynamically enable/disable the agent at any time. Agent based SQL capture uses non-intrusive ZERO impact network sniffing. Has a low 1% overhead on the monitored server. 100% of the SQL activity is captured 24x7 with the complete SQL text and bind parameters plus most importantly the end-user experience end-user response time (and more). Also captures the SQL text for prepared SQL statements.

Enable the agent on priority servers where end-user response time is important, on servers experiencing performance issues that cannot be pinpointed with agentless monitoring, or when a server change is about to be made. (refer to our ROI Database Performance Monitoring Methodology). FREE with every SERVER BOTTLENECK and END_USER EXPERIENCE MONITOR license.

Does not use ineffective server sampling that missed most of the client SQL activity.

Allows 100% of the SQL activity to be viewed over any time period.

Pinpoints the poor performing SQL that database performance views cannot show due to the averaging of SQL performance.

Does not use intrusive server SQL profiling or tracing that degrades server performance by 30% to 60%.

Capture 100% of the SQL activity with its performance using the Zero Impact SQL Capture Agent (its FREE). It has a low 1% overhead on the monitored server. Does not connect to the monitored server!

Install it when SQL performance is an issue, when end-user response time is important, on servers experiencing performance issues that cannot be pinpointed with agentless monitoring, or when a server change is about to be made. (refer to our ROI Database Performance Monitoring Methodology).

Ad hoc comparison at any time of performance between servers and time periods at the SQL statement, stored procedure, wait type, database or client host level.

Be informed of when the next server slowdown is about to occur!

Daily baseline analysis of the day's performance is automatically compared to the performance of prior baseline time periods. Increases or decreases in end-user response time, wait conditions, wait times, I/O bottlenecks, SQL performance, performance counters and SQL job run time are pinpointed. Allows performance issues to be proactively addressed before end-user response time is impacted.

Since 100% of the SQL activity with the end-user response time can be captured the impact of change can be accurately measured! Just run the Zero Impact SQL Capture Agent before and after an important change is made.

E.g. before and after a hardware upgrade, change in the server configuration, table index changes, SQL code changes, regression test of a new application release in QA, deployment of a new application release to production, or upgrade to a new release of the database server software such as Oracle 12, SQL Server 2012 or Sybase 15.7.

Now SQL statements having an improved or degraded end-user response time are accurately known. Performance issues can be immediately resolved prior to end-users experiencing poor performance.

Run the Zero Impact SQL Capture Agent (FREE) to capture 100% of the production SQL activity. Non-intrusive agent does not connect to the monitored server!

Perform a multi-threaded replay of the production SQL using SQL Server Profiler's replay facility.

All customers receive free product training.