Zero Impact SQL Capture Agent Product

Have These Important Business Requirements?

The Zero Impact Sql Capture Agent Can Help !

Zero Impact SQL Capture and End-User Response Time Monitoring using non intrusive Network Sniffing and Deep Packet Inspection. Monitors the performance of 100% of the SQL activity 7x24. Audits the SQL activity for potentially rogue or unauthorized SQL statements. Winner of several industry awards. Available for DB2, Informix, MariaDB, MySQL, Oracle, PostgreSQL, SQL Server and SAP Sybase.

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 2K to 20K unique SQL statements that typically run on a database server millions of time a day.
Previous
Next

How We Differ

- 1 -
- 2 -
- 3 -

Zero Impact Sql Capture Agent captures 100% of the SQL activity with its SQL text, end-user response time and much more. Alerts you within milli seconds to long running SQL or SQL that runs longer than its performance baseline.

Product 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 servers. Zero Impact Sql Capture Agent has a LOW memory usage and 1% CPU server overhead. 

No intrusive SQL profilers or traces having a HIGH database server overhead or event monitoring that miss client SQL are used. More accurate than SQL interval wait monitoring. Runs on the server or from any other server with a network span or 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 service levels.
  • Email alerts when average response time degrades for a monitored database instance.
  • Captures all or any subset of the SQL activity 24x7.
  • View SQL by response time, rows sent & much more.
  • Top N SQL analysis over any time period.
  • Baseline analysis of run time by SQL statement.
  • Email alerts when SQL response time is degraded.
  • View each SQL statement run time by hour, day & week.
  • Filter the client SQL activity over any time period.
  • Quick install with product setup wizard.
  • Database repository provides SQL historical view.
  • DB2, Informix, MySQL, Oracle, SQL Server & Sybase.

Screenshots

Captures 100% of the SQL and Baselines Every Unique SQL Statement's Performance so Unnecessary Hardware Upgrades do Not Occur!
Real-time Dashboard for SQL Response Time and Service Level Alerts
Alert thresholds may be set by database instance.
View SQL Response Time and End-User Service Level Alerts
View the SQL that ran longer than the SQL or Service Level Alert Thresholds.
Heatmap for SQL Response Time Issues
Red database instance SQL need to be investigated immediately.
End-User Service Levels
View average end-user response time in real-time or over any time period.
Capture and View All SQL Activity
View all SQL statement end-user response time in real-time or over any time period.
Top N SQL Analysis
Average, minimum and maximum end-user response time for 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.
Previous
Next
View SQL Server Agentless Monitoring Features

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

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