Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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…

Read more

1 comments, 1,817 reads

Posted in Glenn Berry's SQL Server Performance on 18 April 2014

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…

Read more

0 comments, 500 reads

Posted in Glenn Berry's SQL Server Performance on 11 March 2014

SQL Server 2008 R2 SP2 CU11

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 level is SP2. Both SP1 and RTM have been… Read more

0 comments, 303 reads

Posted in Glenn Berry's SQL Server Performance on 21 February 2014

Scaling SQL Server 2014 Pre-Con in Copenhagen

I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28, 2014. This is a revised and expanded version of the pre-con I delivered at the 2013 PASS Summit, with a lot of new content. It should be a lot of… Read more

0 comments, 173 reads

Posted in Glenn Berry's SQL Server Performance on 12 February 2014

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…

Read more

1 comments, 243 reads

Posted in Glenn Berry's SQL Server Performance on 6 February 2014

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

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 releasing a SQL Server 2008 R2 Service Pack 3…

Read more

0 comments, 1,187 reads

Posted in Glenn Berry's SQL Server Performance on 27 January 2014

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…

Read more

3 comments, 146 reads

Posted in Glenn Berry's SQL Server Performance on 14 January 2014

2013 in review

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 the Louvre Museum, it would take about 12 days for…

Read more

0 comments, 98 reads

Posted in Glenn Berry's SQL Server Performance on 31 December 2013

SQL Server 2008 R2 Service Pack 2 Cumulative Update 10

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 2 (which is the only supported Service Pack for…

Read more

0 comments, 164 reads

Posted in Glenn Berry's SQL Server Performance on 17 December 2013

SQL Server Diagnostic Information Queries for 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.

I also spent some time this month to true up the SQL Server 2014…

Read more

3 comments, 111 reads

Posted in Glenn Berry's SQL Server Performance on 17 December 2013

SQL Server 2008 Service Pack 3 Cumulative Update 14

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 14, which is build 10.00.5848. This Cumulative Update has six fixes in the public fix list.

This is only for SQL Server 2008 Service Pack 3 (which is the only supported Service Pack for SQL Server 2008). If… Read more

0 comments, 93 reads

Posted in Glenn Berry's SQL Server Performance on 19 November 2013

Microsoft SQL Server 2012 SP1 Cumulative Update 7

Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47 fixes in the public hotfix list, a number of which seem to be quite significant for performance and stability.

Here are fourteen database engine-related fixes that are in SQL… Read more

0 comments, 641 reads

Posted in Glenn Berry's SQL Server Performance on 19 November 2013

SQL Server Diagnostic Information Queries for November 2013

I have made a number updates and bug fixes, including some additional columns in some of the queries for all of the versions of my SQL Server Diagnostic Information Queries for this month.  I have also added more comments and links about how to interpret the results.

Rather than having…

Read more

1 comments, 336 reads

Posted in Glenn Berry's SQL Server Performance on 15 November 2013

SQL Server Diagnostic Information Queries for October 2013

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. 

Rather than having a separate blog post for each version, I’ll just put the links for all five versions here.

SQL Server 2005 Diagnostic Information Queries        SQL Server…

Read more

10 comments, 373 reads

Posted in Glenn Berry's SQL Server Performance on 15 October 2013

SQL Server Diagnostic Information Queries for September 2013

I have gone through and 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…

Read more

1 comments, 432 reads

Posted in Glenn Berry's SQL Server Performance on 24 September 2013

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with higher physical core counts and lower power usage.

They are… Read more

3 comments, 1,789 reads

Posted in Glenn Berry's SQL Server Performance on 18 September 2013

TPC-E Benchmark Results for Intel Xeon E5-2697 v2

Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697 v2 (Ivy Bridge-EP) processor. The first result is for an IBM System x3650 M4 with 512GB of RAM, that has a score of 2590.93. The second result is for a… Read more

0 comments, 519 reads

Posted in Glenn Berry's SQL Server Performance on 12 September 2013

Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model

Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are created in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. I just checked, and the same issue is present in SQL Server 2014 CTP1… Read more

1 comments, 351 reads

Posted in Glenn Berry's SQL Server Performance on 29 August 2013

SQL Server 2012 RTM CU9

On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes in the public fix list. This a very low number of hotfixes compared to all previous SQL Server 2012 Cumulative Updates, which is probably a good sign about the…

Read more

1 comments, 387 reads

Posted in Glenn Berry's SQL Server Performance on 22 August 2013

SQL Server Diagnostic Information Queries for August 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I also added two new queries at the end of the script, to collect some information about the SQL Server Agent jobs and about the SQL…

Read more

10 comments, 2,070 reads

Posted in Glenn Berry's SQL Server Performance on 9 August 2013

Older posts