Industry Leader in Database Monitoring !

Have These Important Business Requirements?

The Zero Impact Sql Capture Agent Can Help !

Have Mission Critical Applications
That need to deliver a predictable response time to end-users daily plus after: Cloud migration, deployment on Database Machines, server fail-overs, new software releases, changes in indexing, SQL code or configuration changes.
End-user Service Level Agreements
With business areas for guaranteed end-user response time.
Immediately Pinpoint Long Running SQL
When end-users report poor response time. Allows DBAs and SQL developers to fix SQL performance issues ASAP since the exact SQL that caused the issue can be viewed from a web browser or mobile device.
Reduce Problem Resolution Time by 95%
Monitoring products using interval sampling of the SQL activity miss most of the long running SQL and focus only a small subset of the 10K unique SQL requests that typically run on a database server millions of time a day.
Know SQL's Baseline Performanc
Know within a few milli seconds when a SQL statement's performance is poorer than its historical performance baseline for each of the 10K unique SQL statements that typically run on a database server millions of time a day.

How We Differ

- 1 -
- 2 -
- 3 -

Zero Impact Sql Capture Agent captures 100% of the client SQL activity with its SQL text, end-user response time and much more. Alerts you within milli seconds on a mobile device or web browser of long running SQL or SQL that exceeds its baseline performance.

Uses non intrusive network packet sniffing to capture 100% of the SQL activity with ZERO impact on the database server. NEVER connects to the monitored database server. Zero Impact Sql Capture Agent has a LOW 1% server overhead.

No intrusive SQL profilers or traces having a HIGH database server overhead or event monitoring that miss client SQL are used. Orders of magnitude more accurate than SQL interval wait monitoring. Runs on the server or from any other server with a network tap.

Key Benefits

- 1 -
- 2 -
- 3 -
  • End-user service levels are always known.
  • Average response time reported every N seconds.
  • Service levels may be viewed over any time period.
  • Dashboard and heatmap views of user service levels.
  • Email alerts when avg response time > 0.5 seconds.
  • Captures all or any subset of the SQL activity.
  • View SQL by response time, login id, IP & much more.
  • Top N SQL analysis over any time period.
  • Baseline analysis of performance by SQL statement.
  • Email alerts when SQL response time is degraded.
  • View each SQL stmt run time by hour, day, week, etc.
  • Filter the client SQL activity over any time period.
  • Quick install with product setup wizard.
  • Database repository provides historical view of SQL.
  • Monitors Informix, Oracle, SQL Server and Sybase.

Screenshots

End-User Service Levels
View average end-user response time in real-time or over any time period.
All Client SQL Activity
View all SQL statement end-user response time in real-time or over any time period.
Top N SQL Analysis
Average response time of every unique SQL statement.
SQL Baseline Analysis
Difference in response time between two time periods.
SQL Baseline Performance over Time
For each unique SQL statement over time.
Performance Heatmap on Mobile
Also available in web browser GUI.
Dashboard on Mobile
Also available in web browser GUI.
Service Levels and SQL Activity on Mobile Device
Click on graph to display SQL text.
Service Levels and SQL Activity on Mobile Device
Click on graph to display SQL text on mobile phone.

© Copyright 2018 Sql Power Tools, Inc. All rights reserved.

Contact us:   (800) 733-5978   info@sqlpower.com