How I Use sp_BlitzIndex To Find Indexing Problems In SQL Server Databases

[@BrusyurSoksow]

(Foolish) individuals often think that DBAs are these nerds that spend all the day being eager about pointing and clicking on things on triple screens. When people say that to me at parties these days I just say 'yeah, but have you seen that guy Erik Darling on KZbin?' and they fall silent. I salute your contribution to making the learning things part of my job fun and focussed.

[@ErikDarlingData]

HAHAHA, aw, thanks!

[@Garstor]

I really hope that you crocheted something after uploading this. Good stuff! I usually run BlitzIndex with @TableName and @Mode = 0. Now, I am going to try the less granular options seen here. Thanks!

[@ErikDarlingData]

Oh I don’t remember what I said in this one. But I have never crocheted anything. One time I ironed a patch on a jacket though.

[@toshaikzubair]

Super!!! Could please explain including fill factor and pad index in highly workload environment with explains and page analysis as well??

[@ErikDarlingData]

Those settings lost most of their value as hardware moved from spinning disks to SSDs/flash. I don't see a need to touch them.

[@toshaikzubair]

@@ErikDarlingData Noted and Thanks.

[@hentan4912]

Good evening. Interesting video, i want to ask about deleting indexes. Which strategy of deleting are best for you? Sorry for mistakes, haven't many practice with English)

[@ErikDarlingData]

I'm not sure what you're asking exactly. Your English is fine, but your question is unclear.

[@hentan4912]

@@ErikDarlingData How can I find indexes, which I must delete? (Unused index is index, where we have only scans and never have seeks, or we have small counts of seeks in our index). I think small count of seeks is reason to look at this index, maybe it isn't works good, and I can delete it.

[@ErikDarlingData]

Use the stored procedure in the video, heh.

[@hentan4912]

@@ErikDarlingData It will be interesting to look how you do it) thanks for answers!

[@somusomesh6440]

Is there way we can know how old the last seek/last scan results are? Like if an index’s last scan says NULL, does it mean it wasn’t scanned in the last week, two weeks? I was thinking the results are from the last sql server restart but not sure.

[@ErikDarlingData]

That will depend on which version/edition of SQL Server you're on, and if you're rebuilding indexes. In certain older versions, that will clear out the stats. You should probably not be wasting time rebuilding indexes, if that's the case. The other issue might be that the index is unused, and that's why the dates are NULL.

[@Groot_for_prez]

Great video.

[@ErikDarlingData]

Glad you enjoyed it!