Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are still using it and will be for some time to come. Because of this, I decided to release an updated version of my diagnostic queries for SQL Server 2005. The last time I released a version for SQL Server 2005 was back in March of 2011. You can get the new version from the following link: SQL Server 2005 Diagnostic Information Queries (May 2012).
I also wanted to thank everyone on Twitter who beta tested these scripts for me. Any remaining issues are totally my responsibility! Please tell me what you think of this version.
Filed under: SQL Server 2005 Tagged: DMV, DMV Queries