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