Since it is nearly April, I will go ahead and jump the gun again and post an updated version of my SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There are a few queries that only work with SQL Server 2008 R2 SP1, but they are noted in the comments.
Many of these are DMV queries that require VIEW SERVER STATE permission. You really should run these queries one at a time, and take a few moments to look at each set of results, rather than running them in a single batch.
I have fixed a few minor issues with this version, and added a couple of new queries. Please let me know what you think!
Filed under: SQL Server 2008, SQL Server 2008 R2 Tagged: DMV Queries