sp_BlitzIndex™ – SQL Server’s Index Sanity Test
Your SQL Server indexes may be less sane than you think. Download sp_BlitzIndex™ to find out– or scroll on down and watch a video to see how it help you find out:
- 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
Want to learn more about index tuning? Take an 8 minute tour of how to install, run, and use the results from sp_BlitzIndex™ here, or check out how you can get 18 months of access to more than 6.5 hours of video training, chock full of demos and quizzes.
Want to run sp_BlitzIndex™ with minimal permissions? It’s easy, get the prescription here.
See http://BrentOzar.com/go/eula for the End User Licensing Agreement.