Statistics

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 Statistics report.  Be sure to adjust the shared datasource to point to your database.

To see the full report, download the sample report StatisticsReport.pdf

 

What does this mean to my SQL Server

Statistics that are out of date may impact the actual usage of those indexes.  With out of date or no statistics, SQL server can’t accurately make the decisions needed for a query to perform well.  You may get an index scan when an index seek may be the better solution.

 

 

One Response to Statistics

  1. Pingback: » Index Statistics Report added to the FREE SQL Server Health Reports 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 sweetCaptchaWordpress Captcha