Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health. The queries are not rocket science, but they are long and rely on DMVs that you may not have learned about yet. They also provide useful and easy shortcuts to common questions on SQL Server 2005. Check them out at:
http://www.davidemauri.it/SqlScripts.aspx
I now use them a lot. So I'm sure you'll find them useful too.
Great job, Davide, and thank you for sharing!
Cheers,
-Kev
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About KKline
Kevin Kline is Technical Strategy Manager for the SQL Server business unit at Quest Software. Kevin was the original architect and dev manager for many of Quest's SQL Server tools. Prior to Quest, Kevin worked as an enterprise DBA for a variety of large corporations and government agencies.