Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it seems like a good time for me to release an updated version of my SQL Server 2012 Diagnostic Information Queries. This set includes most of the relevant new DMVs that are included in SQL Server 2012. Some of these new DMVs are also in SQL Server 2008 R2 SP1.
Even though SQL Server 2012 is still in a Community Technology Preview (CTP) status, with an announced final release date of “the first half of 2012”, it is not too early to start trying it out.