I/O by Database

The I/O By Database report is one of the instance level reports available in Database Health Monitor. The I/O by database page shows the databases with the most IO on your system.

This can be used to track down performance problems.

You can get to this report either by right clicking on the instance name, and choosing instance level reports, or by clicking the IO report on the server overview page.

I/O constraints can be one of those hidden items that slows down your database. These reports help determine which databases are using the most I/O, and you mind be surprised when you look at which databases on your system use the most I/O.

In the screen shots above these are on test systems. For instance the one that shows DBHealthHistory as the most I/O comes from a server that sits idle and doesn’t have any real workload on it.