Top IO Report

If you have arrived at this page as a result of running the Server Health report, congratulations you are on the first step to improving your server health.

To use the report, download the Database Health SSRS project, and run the Top IO report.  Be sure to adjust the shared datasource to point to your database.

 

What does this mean to my SQL Server

The queries with the TOP IO are the ones that often time are taking the longest to run, and are great candidates for optimization.

 

One Response to Top IO Report

  1. Pingback: » SQL Server Health Report Updated – Top IO added Steve Stedman

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweet Captcha