Category Archives: SQL Server 2008 R2

SQL Server Diagnostic Information Queries for September 2014

Posted on September 17, 2014 by Glenn Berry

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 … Continue reading →

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

SQL Server Diagnostic Information Queries for April 2014

Posted on April 18, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 1 Comment

SQL Server Diagnostic Information Queries for March 2014

Posted on March 11, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment

SQL Server 2008 R2 SP2 CU11

Posted on February 21, 2014 by Glenn Berry

On February 17, 2014, Microsoft released SQL Server 2008 R2 SP2 CU11, which is Build 10.50.4302. This cumulative update has twelve hotfixes in the public fix list. If you are running SQL Server 2008 R2, the only supported Service Pack … Continue reading →

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

SQL Server Diagnostic Information Queries for February 2014

Posted on February 6, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 1 Comment

Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs

Posted on January 27, 2014 by Glenn Berry

As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014,  (which is less than six months away), I am very curious whether Microsoft is planning on … Continue reading →

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

SQL Server Diagnostic Information Queries for January 2014

Posted on January 14, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 3 Comments

2013 in review

Posted on December 31, 2013 by Glenn Berry

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 280,000 times in 2013. If it were an exhibit at … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

SQL Server 2008 R2 Service Pack 2 Cumulative Update 10

Posted on December 17, 2013 by Glenn Berry

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 10, which is build 10.50.4297. This Cumulative Update has fifteen fixes in the public fix list. This Cumulative Update is only for SQL Server 2008 R2 Service Pack … Continue reading →

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

SQL Server Diagnostic Information Queries for December 2013

Posted on December 17, 2013 by Glenn Berry

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. I also spent some … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 3 Comments