November 9, 2008 at 10:54 pm
Months ago, there was a script posted to this website: "SQL Server 2005 - Tell me your secrets"; has got a number of highly useful queries:
Causes of the server waits; Databases using the most IO; Count of missing indexes, by database;
Most important missing indexes along with the proposed covered index definition; Unused Indexes;
Most costly indexes (high maintenance); Most used indexes; Most fragmented indexes; Most costly queries, by average IO; Most costly queries, by average CPU; Most costly CLR queries, by average CLR time; Most executed queries; Queries suffering most from blocking; Queries with the lowest plan reuse.
Can anyone help me to find that script here? Your help would be much appreciated. Thank you in advance.
July 13, 2011 at 12:09 pm
I realize this is a long time after the original question was asked but for future visitors... I believe this is what you were looking for.
http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
In the comments of the dmv mega script that you can download it says...: SQL 2005 - Tell Me Your Secrets
Looks like you can also access the script directly here:
http://msdn.microsoft.com/en-us/magazine/cc164174.aspx?code=true&level=root&file=script.sql
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply