"sp_BlitzIndex™ – SQL Server’s Index Sanity Test
Your SQL Server indexes may be less sane than you think.
Do you have duplicate indexes wasting your storage and memory?
Have wide clustering keys snuck into your schema, inflating your indexes?
Are there active heaps lurking in your database, causing strange fragmentation?
Is blocking creeping up behind you before you can realize it?
Our free sp_BlitzIndex™ stored procedure quickly does a sanity check on your database and diagnoses your indexes major disorders, then reports back to you. Each disorder has a URL that explains what to look for and how to handle the issue.
sp_BlitzIndex™ also saves YOUR sanity when index tuning, by giving you the option to see both the “missing” and existing indexes for a table in a single view– when prevents you from going crazy and adding duplicate indexes.
If you’ve ever struggled with index tuning, this may sound crazy good. We think it really is.
Get sp_BlitzIndex™ and Check Your Index Sanity
Download sp_BlitzIndex™ here!
Want to run sp_BlitzIndex™ with minimal permissions? It’s easy, get the prescription here.
You can also grab the code for sp_BlitzIndex™ right here: