Capture 100% of (local) SQL statement text and performance metric in real-time
Monitor 30 day performance trends for historical comparisons
Easy-to-use web enabled interface
Alerts you in real-time or off-line to poor performing SQL or stored procedures
Real time monitoring of end user response time, database server response time, network time by server, application, end-user and unique SQL statement
Pinpoint in real-time poor performing SQL for production, test and development environments
All or any subset of the SQL may be archived to a database in real-time or off-line. High speed database archiving is used
Filter, exclude, include or reconstruct SQL statements by time, end user or database server response time, network time, login id, client IP address and more
The Sql Loopback Monitor allows monitoring SQL statement performance (local and network SQL) for batch processes, web servers, three tiered architectures, application servers and telnet sessions that run on the same platform as the database server. These SQL transactions are not sent over the network and therefore cannot be monitored by the Zero Impact Sql Monitor.>
The Sql Loopback Monitor is a companion product to the Zero Impact Sql Monitor and requires a license to the Zero Impact Sql Monitor. Available for AIX, HP-UX 11.x, Solaris and Windows.
The Sql Loopback Monitor must run on the same platform as the database server in order to monitor the SQL packets sent over the loopback interface. The product's overhead is minimal given its non-intrusive and efficient architecture.
The Zero Impact Performance Divergence Monitor is released. Offers early warning of deteriorating performance in SQL Server database server farms. Analyzes performance trends and deviations from historical baselines to identify which performance metrics and SQL statements are deteriorating from a prior rolling time period or historical baseline. Read more.
After years as a DBA, I can tell you there is absolutely nothing on the market that compares to the Zero Impact Sql Monitor product line...it is the best performance investment you will ever make.