Welcome to Sql Power Tools
Have mission critical applications that need to deliver a predictable response time to end-users?

Have SLA (service level agreements) with end-users for guaranteed end-user response time?

Cannot immediately pinpoint the SQL when end-users report poor end-user response time? Want to reduce problem resolution time by 95%?

Monitoring architectures using interval sampling are taking a long time/missing/not detecting poor performing SQL performance?

Want to know by client SQL request the difference in end-user response time before/after migration to the Cloud, Exadata Database Machine, cluster failovers, new software releases, changes in hardware/software, table indexing, SQL code?

Zero Impact Sql Capture Agent addresses the above requirements and MUCH more!

Know within milliseconds of long running client SQL with the Zero Impact Sql Capture Agent Lite!

Uses non-intrusive ZERO impact network sniffing to capture all or any subset of the SQL activity. Overhead is < 1%. Does NOT connect to the monitored database server.

Available for Informix, Oracle, SQL Server and Sybase.

Lite Version License Fees:

1 to 10 database instances $600/database instance.
11+ database instances $500/database instance.

Saves DBAs/SQL developers hours of time. Product payback is immediate.

Key Features:

  • Captures 100% of the client SQL text, end-user response time, errors, rows returned and more with ZERO impact on the database server.
  • Allows DBAs and SQL developers to pinpoint long running SQL immediately so end-users are not impacted.
  • Captures all or any subset of the SQL activity to an Excel, BCP, ONPLOAD or SQL batch file.
  • Pinpoints all poor performing SQL queries.
  • End-user experience service levels are known minute to minute, day to day, week to week, month to month.
  • Email alerting for SQL that runs longer than N seconds. E.g. longer than 200 milli seconds. Also email alerting when end-user service levels degrade. E.g. when average end-user response time > 250 milli seconds.
  • NEVER connects to the monitored database instance. It’s a ZERO impact SQL trace facility.
  • Polling/snapshots are not used since they miss much of what has occurred.
  • Does NOT impact high priority applications performance. Service disruptions are prevented since the poor performing SQL is immediately pinpointed.
  • Installs in a few minutes and has a low 1% overhead. Zero Impact Sql Capture Agent runs on the database server or any other host with port mirroring or a network tap.


 
Upgrade any time from the Zero Impact Sql Capture Agent Lite to the Zero Impact Sql Capture Agent Enterprise.

CLICK HERE for SCREENSHOTs.

Enterprise Version License Fees:

SQL Server license fees:
1 to 14 database instances $2,000/database instance.
15 to 49 database instances $1,500/database instance.
50 to 99 database instances $1,000/database instance.
100+ database instances $750/database instance.

CLICK HERE for SQL Server AGENTLESS monitoring info.

Informix, Oracle and Sybase fees:
1 to 14 database instances $2,500/database instance.
15 to 49 database instances $2,000/database instance.
50 database instances $1,500/database instance.
100+ database instances $1,000/database instance.

Key Features:

  • View the end-user response time for all client SQL activity over any time period from a web browser, mobile phone or tablet.
  • End-user experience service levels are known minute to minute, day to day, week to week, month to month.
  • Top N Sql Analysis of the daily SQL or over any N minute period when end-user response time was poor.
  • Track the end-user response time of every unique SQL request by minute, hour, day, week or month.
  • Baseline analysis of the end-user response time for the 10K+ unique SQL requests running on a server millions of times a day. Both degraded and improved end-user response times are reported for each unique SQL request.
  • Dashboard and heatmap views of server farm SQL end-user response time from web browsers and mobile devices.
  • Email alerting by specific SQL request. E.g. OLTP SQL no. 1 that runs longer than 0.1 seconds, OLTP SQL no. 2 that runs longer than 0.6 seconds, OLTP SQL no. 3 a stored procedure that runs longer than 0.25 seconds, BI SQL no. 1 that runs longer than 15 seconds, BI SQL no. 2 that runs longer than 45 seconds, reporting SQL no. 1 that runs longer than 5 seconds.
  • Writes the SQL activity in real-time to an Informix, Oracle, SQL Server or Sybase database repository for immediate viewing from a web browser and mobile device.
  • Accurate before and after comparison of end-user response time for every unique SQL request when any change is made. E.g. changes in hardware/software, table indexing, SQL code, new software releases, cloud migration, etc.

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

Customers
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