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?
- Would you like help to find unused indexes that are bloating your backups?
- 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.
If Microsoft supports it, so do we – unfortunately, that means SQL 2000 and 2005 are out of luck. We use a lot of cool DMVs and techniques that only work in current versions of SQL Server.
See http://BrentOzar.com/go/eula for the End User Licensing Agreement.
Current version: v3.0 (March 12, 2016)
- Streamlined results – now prioritized and minimized so you can focus on the most critical indexing issues.
- @GetAllDatabases = 1 – this new parameter lets you analyze all of your user databases at once. Really helpful for software-as-a-service companies where each client gets their own database. If you have more than 50 databases, you have to use the @BringThePain = 1 parameter too.
- Moved URL to near the end of columns
- Added 100k/day minimum benefit to high-value missing index recs
- Expanded avg query cost on missing indexes to 4 decimal places
- Formatted number of uses on missing indexes to use commas (money format)
- Changed benefit formula to divide benefit number by uptime