Tag Archives: DMV Queries

SQL Server 2005 Diagnostic Information Queries (May 2013)

Posted on May 7, 2013 by

Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. To go with it is an updated, blank 2005 results spreadsheet, where the tabs … Continue reading →

Posted in SQL Server 2005 | Tagged , | Leave a comment

SQL Server 2008 Diagnostic Information Queries (May 2013)

Posted on May 7, 2013 by

Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL … Continue reading →

Posted in SQL Server 2008 | Tagged , | Leave a comment

SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

Posted on May 6, 2013 by

Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for … Continue reading →

Posted in SQL Server 2008 R2 | Tagged , | Leave a comment

SQL Server 2012 Diagnostic Information Queries (May 2013)

Posted on May 6, 2013 by

Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have improved the formatting of the results to make many of the queries … Continue reading →

Posted in SQL Server 2012 | Tagged , | Leave a comment

SQL Server 2012 Diagnostic Information Queries (April 2013)

Posted on April 15, 2013 by

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the … Continue reading →

Posted in SQL Server 2012 | Tagged , | 2 Comments

SQL Server 2012 Diagnostic Information Queries (March 2013)

Posted on March 3, 2013 by

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the … Continue reading →

Posted in Diagnostic Queries, SQL Server 2012 | Tagged , | 3 Comments

SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013)

Posted on February 5, 2013 by

Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for … Continue reading →

Posted in Diagnostic Queries, SQL Server 2008 R2 | Tagged , | 6 Comments

SQL Server 2012 Diagnostic Information Queries (Feb 2013)

Posted on February 1, 2013 by

Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. There is also one new query that looks for missing indexes for all databases … Continue reading →

Posted in Diagnostic Queries, SQL Server 2012 | Tagged , | 2 Comments

SQL Server 2008 Diagnostic Information Queries (Jan 2013)

Posted on January 12, 2013 by

Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 2 Comments

SQL Server 2012 Diagnostic Information Queries (Jan 2013)

Posted on January 12, 2013 by

Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. … Continue reading →

Posted in SQL Server 2012 | Tagged , | 3 Comments