SQL Server Diagnostic Information Queries for December 2016

This month, I have added a separate set of queries for SQL Server vNext. Right now, they are almost identical to the SQL Server 2016 queries, but I will make changes to surface new functionality in SQL Server vNext over time. I have also added support for new functionality in SQL Server 2016 Service Pack […]

SQL Server Diagnostic Information Queries for November 2016

This month, I have added several new queries to SQL Server 2016 set, along with adding additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. I have gotten quite a bit of interest about making a special version of these queries for SQL Database in Microsoft Azure. So, I will be […]

SQL Server Diagnostic Information Queries for October 2016

This month, I have spent quite a bit of time trueing up the queries for SQL Server 2012, 2014 and 2016 sets, along with adding additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of these queries for […]

SQL Server Diagnostic Information Queries for September 2016

This month, I have a couple of new queries in the SQL Server 2012, 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of these queries for SQL Database in Microsoft Azure. […]

Speaking at 24 Hours of PASS on September 7, 2016

I will be presenting Dr. DMV: How to Use DMVs to Diagnose Performance Problems during the 24 Hours of PASS Preview Edition at 8AM Mountain Time (UTC –6) on September 7, 2016. Here is the abstract: SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL […]

SQL Server Diagnostic Information Queries for August 2016

This month, I have a new AlwaysOn AG query for SQL Server 2016 and several new improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of these […]

SQL Server Diagnostic Information Queries for July 2016

This month, I have several new improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of these queries for SQL Database in Microsoft Azure. So, I will […]

SQL Server Diagnostic Information Queries for June 2016

This month, I have several improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. One new feature is a series of six dashes after each query to make them easier to parse by people who use PowerShell to run the […]

SQL Server Diagnostic Information Queries for May 2016

This month, I have a new query in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. One thing I am considering is making a special version of these queries for SQL Database in Microsoft Azure. Does anybody want me to do […]

SQL Server Diagnostic Information Queries for April 2016

This month, I have some additional columns in several queries in the SQL Server 2016 set, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. Rather than having a separate blog post for each version, I have just put the links for all six major versions in this single […]

SQL Server Diagnostic Information Queries for March 2016

This month, I have one new query in the SQL Server 2016 set, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. Rather than having a separate blog post for each version, I have just put the links for all six major versions in this single post. There are […]

SQL Server Diagnostic Information Queries for February 2016

Rather than having a separate blog post for each version, I have just put the links for all six major versions in this single post. There are two separate links for each version. The first one on the top left is the actual diagnostic query script, and the one below on the right is the […]

SQL Server Diagnostic Information Queries for January 2016

As I discussed yesterday,  I have done some fairly significant reorganization work for the SQL Server 2016, SQL Server 2014, and SQL Server 2012 versions of these queries this month. I have also made some very minor changes to the SQL Server 2008 R2 and older versions of these queries. Rather than having a separate […]

SQL Server Diagnostic Query Reorganization

After much thought, and some procrastination, I have decided to implement a fairly significant reorganization of my SQL Server Diagnostic Information Queries, starting with the SQL Server 2016 version for January 2016. I use these queries on a daily basis during my consulting work at SQLskills.com, and I have been planning on making some changes […]

SQL Server Diagnostic Information Queries for December 2015

This month, I revised several queries, mainly based on suggestions from readers. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific queries and new columns in existing queries over the next few months as I discover interesting new things in SQL Server 2016. I am also continuing to add […]

SQL Server Diagnostic Information Queries for October 2015

This month, I spent some time adding columns for the new SERVERPROPERTY options, along with adding more comments and links to the scripts. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific queries and new columns in existing queries over the next few months as I discover interesting new […]

SQL Server Diagnostic Information Queries for September 2015

This month, I spent quite a bit of time synchronizing the scripts between the SQL Server 2016, 2014, and 2012 versions, making sure the small differences that were cropping up between the versions were cleaned up as much as possible. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific […]

SQL Server Diagnostic Information Queries for August 2015

This month, I have added a new query for SQL Server 2016, that checks your QueryStore options. The SQL Server 2016 version will continue to be improved with more SQL Server 2016-specific queries and new columns in existing queries over the next few months. I am also continuing to add more relevant comments and links […]

SQL Server Diagnostic Information Queries for July 2015

This month, I have added a couple of new queries for SQL Server 2016, including one that uses QueryStore. This version will continue to be improved with more SQL Server 2016-specific  queries and columns in existing queries over the next few months. Since SQL Server 2008 R2 and older are out of Mainstream support from […]

SQL Server Diagnostic Information Queries for June 2015

This month, I have added a new, separate version of these queries for SQL Server 2016. This version will be improved with more SQL Server 2016-specific  queries and columns in existing queries in the near future. Since SQL Server 2008 R2 and older are out of Mainstream support from Microsoft (and because fewer of my […]

SQL Server Diagnostic Information Queries for May 2015

I revised a number of the queries this month in just the SQL Server 2012 and 2014 versions of the script.  As usual, the main enhancements are additional comments and documentation about the queries, including more information about how to interpret the results, including some more links to relevant blog post articles.  Since SQL Server […]

SQL Server Diagnostic Information Queries for April 2015

I revised several of the queries this month in only the SQL Server 2012 and 2014 versions of the script.  As usual, the main enhancements are additional comments and documentation about the queries, including more information about how to interpret the results.  Since SQL Server 2008 R2 and older are out of Mainstream support from […]

SQL Server Diagnostic Information Queries for March 2015

I revised several of the queries this month in all five versions of the script.  Once again, the main enhancements are additional comments and documentation about the queries, including more information about how to interpret the results.  Rather than having a separate blog post for each version, I have just put the links for all […]

SQL Server Diagnostic Information Queries for February 2015

I revised several of the queries this month in all five versions of the script.  The main enhancements are additional comments and documentation about the queries, including more information about how to interpret the results.  Rather than having a separate blog post for each version, I have just put the links for all five major […]

SQL Server Diagnostic Information Queries for January 2015

I revised a number of the queries this month in all five versions of the script.  The main enhancements are additional comments and documentation about the queries. Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries SQL Server 2008 R2    65 Queries SQL Server 2008         […]

SQL Server Diagnostic Information Queries for December 2014

I revised a number of the queries this month in all five versions of the script.  Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries SQL Server 2008 R2    65 Queries SQL Server 2008         59 Queries SQL Server 2005         51 Queries Rather than having a […]

SQL Server Diagnostic Information Queries for November 2014

I revised a number of the queries this month in all five versions of the script.  It was very nice to have so many people thank me for these queries during the PASS 2014 Conference! Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries SQL […]

SQL Server Diagnostic Information Queries for September 2014

I revised a number of the queries this month in all five versions of the script. I have also added several new queries to the SQL Server 2012 and SQL Server 2014 versions of the script. Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries […]

SQL Server Diagnostic Information Queries for July 2014

I revised several of the queries this month in all five versions of the script. There are also two new queries for SQL Server 2014, and one new query in the SQL Server 2008 through SQL Server 2012 versions of the script. Rather than having a separate blog post for each version, I have just […]

SQL Server Diagnostic Information Queries for June 2014

I added several new queries this month to all five versions of the script. I also spent quite a bit of time getting all five versions back in synch as much as possible, as far as my comments and other minor differences that had cropped up over the last few months. Rather than having a […]

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret the results of each query in the entire set. Rather than having a separate blog […]

SQL Server Diagnostic Information Queries for March 2014

I made a couple of changes in the order of the queries this month and made some other small improvements to a few queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each […]

SQL Server Diagnostic Information Queries for February 2014

I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each version. The first one on […]

SQL Server Diagnostic Information Queries for January 2014

I spent some time this month to true up the SQL Server 2005 version, with the other versions for the queries that are common between all of these versions, since some small differences had cropped up over time across those versions. I also added the drive-level latency query to the 2005 version. Rather than having […]

SQL Server 2012 Diagnostic Information Queries (December 2013)

I have made quite a few updates and improvements to this set of queries for December 2013. I have added several new queries, and changed the order of some of the existing queries in the set, which now has a total of 63 separate queries. I also spent some time this month to true up […]

SQL Server 2014 Diagnostic Information Queries (December 2013)

I have made quite a few updates and improvements to this set of queries for December 2013. I have added several new queries, and changed the order of some of the existing queries in the set, which now has a total of 65 separate queries. The blank results spreadsheet has also been updated to match. […]

SQL Server Diagnostic Information Queries for September 2013

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I have also added a new version for SQL Server 2014. Rather than having a separate blog post for each version, I’ll just put the links for all five versions here. SQL Server 2005 […]

SQL Server 2012 Diagnostic Information Queries for August 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server 2012 Diagnostic Information Queries for this month, along with adding two new queries at the end of the script. The links for the queries and the blank results spreadsheet are below. SQL Server 2012 Diagnostic Information Queries                […]