Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

A Second March ‘Index Analysis’ Update

Unicorn Create IndexAfter this month’s Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column.  Thanks to Dick for this fix.

If you find issues or have suggestions for changes to the script, please send them to me.  I’ve missed providing credit for a few other changes in the past, going forward, I’ll be sure to provide that credit.

INDEX ANALYSIS UPDATES

The updates to the script in this release are the following:

  • Fixed data type on missing_index_impact (Credit: Dick Baker)

INDEX ANALYSIS DOWNLOADS

Click on the following links to download the index analysis script:

Comments and MORE INFORMATION

Let me know if you run into any issues with these scripts, my e-mail address is in the header of all of the procedures.  If you are looking for a few hundred pages of indexing information, you can check out Expert Performance Indexing for SQL Server 2012.  Along with that, for indexing resources from my blog, check out the index resource page.

Lastly, want to see this script do anything special with indexes?  Leave a comment and I’ll see what I can do.

Comments

Leave a comment on the original post [www.jasonstrate.com, opens in a new window]

Loading comments...