How do you pick the right indexes to add on your tables? Which indexes aren’t doing you any good, and are only slowing you down? How many indexes should a table have?
Get the answers to these questions and more in this one-hour session on SQL Server index tuning. I show how to use Dynamic Management Views (DMVs) to add, remove, and monitor your indexes.
Here’s the links referenced in the video:
- DMV query to find unused indexes – indexes that are just slowing us down every time we do an insert/update/delete
- DMV query to find missing indexes – indexes we could add to get more performance
- Index maintenance script at SQLServerPedia – defragment or rebuild your indexes for a free performance gain
- Michelle Ufford’s articles on index maintenance
And check out my other free SQL Server training videos.
Hi Brent,
Your explanation and presentation is Superb….
Thanks for sharing in and out of Indexes…
Regards,
RamaUdaya.K
Thanks, glad you liked it!
Excellent DMV’s and presentation. Thanks Brent.
Thanks Brent for Sharing.
Hey Brent , its one of the best presentation i have ever seen on sql index.
Thanks, glad you enjoyed it!
Hi Brent,
Awesome presentation. Just wanted to know your thoughts on how hints work along side indexes and would they be a more efficient method to execute DML’s (having statistics updated) with minimal indexes in place?
Hi! I’ve written about that here:
http://www.brentozar.com/archive/2010/03/2-features-of-sql-server-you-should-avoid/
Hope that helps!
Please update with the links referred to in the video, http://questkb.com/live/ is expired.
Jason – sorry, I no longer work for Quest, so I don’t have access to those. Thanks for your understanding.
Great video! Thanks Brent, with this i’ve already removed 3gb of unused indexes.
Hi Brent,
Nice presentation. Very useful. I just want to know if you have any idea about estimating workaround time for reorg/rebuild an large index(for eg: 300GB size of index)
Regards
Mir
Mir – it depends on the amount of load on the server, the speed of the IO subsystems, whether TempDB is separated or not, and more.