Welcome to Sql Power Tools
Capture the SQL text, end-user response time, network time and performance of every SQL request with Sql Power Tools Zero Impact Sql Capture Agent. SQL activity is written in real-time to a database repository for immediate viewing from a web browser or mobile device. View within a few milli seconds any SQL having a poor end-user response time.

Think of it as a ZERO impact SQL trace facility. The Agent never connects to the monitored database instance and has a low 1% overhead. Have important production applications? Pinpoint immediately all poor performing SQL before or after changes are made to the database server environment.

View screenshots HERE.

License Fees:

The license fee to monitor < 25 Informix database instances is $2,500/database instance.
The license fee to monitor 25 Informix database instances is $2,000/database instance (having 1 to 10 CPUs) for an order of 25 licenses.
The license fee to monitor 50 Informix database instances is $1,500/database instance (having 1 to 10 CPUs) for an order of 50 licenses.

Key Features:

  • Captures 100% of the client SQL activity (with the end-user response time) with no impact on the monitored database instance. Pinpoints all long running SQL.
  • Real-time email alerts can be sent for long running SQL or when a database instance delivers a poor average end-user response time. E.g. when client SQL runs longer than 100 milli seconds.
  • Comprehensive Top N Sql Analysis of 100% of SQL activity. Most servers have about 10K+ unique client SQL requests that run millions of times over the business day. The performance of every unique SQL request is tracked.
  • Daily baseline analysis of the SQL performance for the 10K+ unique SQL requests that run on a server. Both degraded and improved SQL performance are reported for every unique SQL request. Know the percentage plus actual increase/decrease in end-user response time for every unique SQL request.
  • User defined baselines can also be defined. E.g. on 7/5/15 all of the SQL for PROD641 had good performance and PROD641 is an important server. Sql Power tools can be scheduled to also compare the performance of PROD641 between 9 am and 4 pm to the other 100+ database instances daily.
  • Ad hoc baseline analysis of SQL performance at any time. E.g. between 11 am and 11:30 am when end-user response time was poor.
  • Accurate measurement and comparison of SQL performance between two time periods when changes are made to the database instance. E.g. changes in the hardware, server, database instance configuration, table indexing, SQL code, install of new software releases, etc.
  • Track changes in SQL performance of specific stored procedures and SQL statements.
  • Product user interface is 100% web enabled for Chrome, Firefox, Internet Explorer, Microsoft Edge and Safari browsers.
  • FREE mobile app with every license that tracks database instance SQL performance on a phone or tablet. SQL response time heat maps, dashboards, performance graphs and alerts may be viewed on Android, Apple, Blackberry or Windows mobile devices.

Daily baseline analysis automatically compares the SQL performance of day N to day N-1 for each database instance. A summary email containing the results of the analysis can be scheduled to be sent to managers, DBA team members and developers. Below is an example of the email.

Email Subject: Baseline Analysis Summary of SQL Performance for 9/1/15. 3 database instances have SQL longer running than their average run time.

Email Content:

3 out of the 50 database instances had SQL that ran 10% longer than the prior business day.

1. PROD12 had 3 SQL request that ran 79% longer. The SQL had an average run time between 0.560 and 0.821 seconds.

2. PROD19 had 2 SQL request that ran 40% longer. The SQL had an average run time between 0.350 and 0.421 seconds.

3. PROD67 had 1 SQL request that ran 11% longer. The SQL had an average run time between 0.101 and 0.221 seconds.

The above email pinpoints incidents where SQL is beginning to run longer than its normal run time. Once this is known the SQL performance issue can be resolved prior to end-users experiencing poor response time.


 
Sql Power Tools agentless monitor has a low, low, low CPU, I/O and network overhead on monitored servers. Less than 1% overhead on monitored servers. If your current monitoring solution cannot keep up, pinpoint the bottlenecks or misses events - we can help. We do NOT:
  • Create tables in the TempDB database or issue millions of I/O operations to TempDB on monitored database servers.
  • Issue millions of ad hoc SQL requests to the monitored servers that bloat the procedure cache and cause expensive SQL compilations to occur 24x7.
  • Increase the database server wait conditions and wait time (due to resource contention) thereby impacting production users response time.
  • Send millions of characters of SQL monitoring text across the network.
  • Turn on SQL Profiler or SQL Trace that can reduce server throughput by 30% or more!
  • SYSADMIN role is NOT used for agentless monitoring of the server farm.

These monitoring solution architectures:

  • Reduce the monitored server's I/O throughput along with increasing CPU and memory pressure.
  • Can result in an annual cost of operation that far exceeds the license fee for the monitoring solution.

ZERO IMPACT SQL CAPTURE AGENT:

Our Zero Impact Sql Capture Agent (a SQL trace facility) for INFORMIX, MICROSOFT SQL SERVER, ORACLE and SYBASE uses non-intrusive ZERO impact network sniffing to capture all or any subset of the SQL activity. 100% of the SQL activity can be captured 24x7 with the complete SQL text and bind parameters plus most importantly the end-user experience end-user response time (and more).

Zero Impact Historical Performance Monitor

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.
  • 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).

Optimize the Database Workload 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.

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.

 
 
Award Winning

Testimonials

Sql Power Tools awarded a Best SQL Tool, Redmond Magazine, 2010 Sql Power Tools awarded a Best SQL Tool, Redmond Magazine, 2010..
Customers
Zero Impact Migration Service for SQL Server 2008 and 2012 is available! You have a mission critical production server serving thousands of users that processes 500 to 5,000 SQL requests/sec. The upgrade must occur with no impact on end-user response time. A plan must be in place that allows measurement of the performance of the upgraded database server release prior to placing it into production. Our Zero Impact Migration Service does this! Refer to Products.
Monitors the 600+ possible wait types that a database server posts when SQL statements do not move forward due to resource contention or being queued due to a lack of available resources. Wait times are tracked by SQL statement, stored procedure, wait type, application, database and the end-user client. View wait times in real-time or over any prior time period by year, quarter, month, week, day, hour, minute or second. Reduce SQL wait time -> reduces end-user response time -> improves server throughput -> unnecessary hardware upgrades do not occur!

Live Support