The SQL Performance Monitor, without the performance overhead
Non-intrusive Performance Monitoring for Major Databases
iWatch™ from Exact Solutions is a best-of-breed standard for SQL Query-Level Performance Monitoring. Available for IBM Db2 for LUW, IBM Informix, SAP ASE, SAP IQ, Microsoft SQL Server, PostgreSQL, and MongoDB.
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.
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.
Database & Platform Support
iWatch is currently available to monitor SQL traffic to any or all of the following databases:
IBM Informix 10.1, 11.1, 11.5, 11.7, 12.1, 14.x
IBM Db2 LUW 8.x, 9.x, 10.x, 11.x
IBM Db2 z/OS for DDF 8.x, 9.x, 10.x, 11.x
Sybase ASE 12.0, 12.5, 15.x, SAP ASE 16.x
Sybase IQ 12.x, SAP IQ 16.x
Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019
PostgreSQL 8.x, 9.x, 10, 11, 12, 13
MongoDB 2.x, 3.x
Supported OS's include the following:
Linux (RHEL 6.x, 7.x, 8.x; SuSE 10, 11, 12, 15; Oracle Linux 6, 7, 8; Other Linux flavors also supported)
AIX 6.1, 7.1 (Power PC)
Solaris 10, 11 (SPARC & x86)
Windows Server 2008, 2008 R2, 2012, 2016, 2019
Licensing to monitor multiple database types or instances from a single iWatch instance is available.