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: