Sql Power Tools Server Bottleneck and End-user Experience Monitor performs agentless monitoring of wait types, wait times, I/O bottlenecks, SQL performance, performance counters, blocking, SQL jobs and performance baselines.

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!

Key Features:

• 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, 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.
• 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!
• 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.
• 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.
• 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 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, 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.

Agent based SQL capture using non-intrusive ZERO impact network sniffing. 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).

Cannot pinpoint the SQL causing poor performance? Cannot pinpoint the SQL running longer than 100 milli seconds? Do not know the bind parameters the SQL was run with? Cannot measure the impact of database server changes? Our ZERO impact agent can with 100% accuracy!

Optionally install our Zero Impact Sql Capture Agent at any time. It has a low 1% overhead. 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 server sampling that misses most of the poor performing SQL is not used. Agent does not connect to the monitored server nor impact the network.

Key Features:

• Can always reconstruct with complete accuracy the exact SQL with its bind parameters that were running when server performance is poor or when end-users complain about poor response time.
• Since bind parameters are captured poor performing SQL statements in stored procedures can be accurately investigated (SQL Server MSDB does not capture stored procedure parameters). Also the SQL text for prepared SQL statements is reported by the agent every time the statement is executed. SQL traces do not provide this.
• Top N Sql Analysis of 100% of the agent based SQL capture. The SQL performance is tracked for the 6,000 unique SQL requests that typically run on a server 100+ million times a day. SQL statements flushed out of cache are not missed.
• Zero Impact SQL Capture Agent usage is optional. Can be installed at any time and dynamically enabled or disabled on servers of interest. Free with every Server Bottleneck and End-user Experience Monitor license.
• 100% accurate comparison of SQL performance between servers or time periods. Can be done on an ad hoc or scheduled basis. Both improved and degraded SQL end-user response time is reported for the 6,000 unique SQL requests that typically run on a server 100+ million times a day.
• 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 below ROI Methodology).

Leverage new ROI Database Performance Monitoring Methodology:

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.