Unlike Agentless Monitoring solutions that miss monitoring ~95% of OLTP SQL since they only sample the server activity every N seconds – the Zero Impact Sql Capture Agent monitors/captures the performance of 100% of the SQL activity with no impact on the monitored servers. Agentless Monitoring solutions are helpful when monitoring high level server resource usage such as CPU, memory, disk. However not that helpful in detecting/monitoring with 99.9% accuracy poor OLTP SQL performance (e.g. SQL requests with degraded or poor end-user response time). SQL Wait Time agentless monitoring is helpful when monitoring data warehousing or data mining SQL where the SQL typically runs longer than 1 or 2 seconds.
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.
© Copyright 2024 Sql Power Tools, Inc. All rights reserved.
Contact us: (800) 733-5978 info@sqlpower.com