SQLDBManager Plus

SQL Server Monitoring Software

Let's Help You!

Overview
Live Demo
Get Quote
Pricing
Compare Editions

Quick Links

Online Help
Troubleshooting
System Requirements
Screenshots

SQL Server Monitoring

SQL Query Performance Monitoring

Monitor Top Queries by CLR

SQL Query Monitored by I/O Usage

SQLDBManager Plus monitors and lists the top 10 costly queries, running within a database, by its I/O usage. It monitors the following metrics:

Average Logical I/O
Total I/O
Query
DB Name
Last Execution Time

It also allows the DBA to configure the alarms for Average I/O metric thus alerting the DBA whenever the logical read/write values exceed the pre-defined threshold.

Related SQL Query Monitoring Features:
Top Queries by CPU Top Queries by CLR Top Slow Running Queries Most Frequently Executed Queries	Most Blocked Queries Top Queries by Lowest Plan Reuse Cost of Missing Indexes Top Components by Memory Usage