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.