sp_BlitzIndex

sp_BlitzIndex analyzes the design & health of your clustered & nonclustered rowstore indexes and gives you suggestions on how to get higher performance without changing your queries. If you run it with no parameters, you get advice on the indexes in the current database: Click to zoom You get warnings like: High value missing index…

When I first got started working with SQL Server, I assumed it was flawless because it came in a sealed box from a ginormous corporation. I figured they’d tested every edge case, and that there was no way things were gonna go sideways. These days, even though I read CU KB articles and giggle about…

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. They’re just behavioral traits. Let your freak flag fly. One of the warnings is “Aggressive Indexes,” which means sys.dm_db_operational_stats reports minutes of…