Day 8 – I/O By Database

Day 8 – I/O By Database
Download PDF

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. You may be surprised with what you find.

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.

You can get to this report by going to the Server Overview page and clicking the gray button in the instance report section for “I/O by Database”.


Also See:


Helpful reports like these are available in our online course “Using Database Health Monitor” 

Link to Course Page

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*