In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.
The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and database developers access to the information they need to analyze the health of their database.
Here is a screen shot of the Statistics report.
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.
Again this report is absolutely free something what I want to share with the SQL Server community. If you have any questions, just send me an email or contact me on twitter @SqlEmt.