Non-intrusive Performance Monitoring for Major Databases

The best-of-breed standard for SQL query-level performance monitoring. Using a completely non-intrusive approach, iWatch creates a continuous performance record of every SQL statement -- all without affecting the performance of the underlying database or application. Available in versions for most major database platforms, iWatch can be deployed quickly and easily to monitor a single data server, or scaled to monitor hundreds of critical servers across a large enterprise.

iWatch captures and measures each and every SQL transaction and maintains the resulting records in a convenient, easily searchable database. Key strengths of iWatch are its non-intrusive operation, intuitive interface, extensive metrics, and an industry-unique repository that allows it to cope with large volumes of performance data. By implementing iWatch, organizations can streamline trouble shooting, improve application stability & performance, track SQL response times; consequently gauge User Response times and focus scarce resources more cost-effectively.

Non-Intrusive Operation iWatch is designed to operate non-intrusively, so it will not affect the performance of your critical applications. Based on a passive network capture model, iWatch does not require configuration changes or connections to your database, nor does it rely on server-side traces or any other form of intrusive process. In the most common type of deployment, where iWatch is installed directly on the database host, overhead is typically less than 1% to 2%.   If even lower overhead is required, iWatch can also be deployed on a separate host or dedicated appliance; with this type of deployment, overhead is effectively reduced to zero. This presents a stark contrast with traditional database-level tools, which typically require 10-15% CPU overhead, and can consume significantly more as users seek additional detail.

​

Measures from the End-User Perspective Traditional OS-level or Database-level performance tools deliver IT-centric metrics such as Disk I/O or CPU utilization, that may have little obvious correlation to end user experiences. In contrast, iWatch measures every SQL transaction, directly from the perspective of the application or end user, removing guesswork and allowing efforts to be focused precisely in those areas that yield the most dramatic performance improvements.   This is a significant advantage in complex, distributed environments, where critical time can be wasted simply determining which area of expertise within the IT organization can best be brought to bear to resolve a particular issue.

Features

• Non-Intrusive Monitoring: Operates passively without altering database configurations or adding server load.
• End-User Perspective Metrics: Tracks SQL response times from the application level for accurate performance insights.
• Wide Database Support: Compatible with IBM Db2, Informix, SQL Server, SAP ASE, PostgreSQL, MongoDB, and more.
• Scalable Architecture: Handles large volumes of performance data with an intuitive, searchable repository.
• Flexible Deployment: Install on database host or separate appliance to reduce overhead to nearly zero.