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

Archives: May 2012

Analyzing TPC-E Benchmark Performance by Physical Processor Core

The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is a not a replacement for the old TPC-C benchmark, but rather is a completely new OLTP benchmark. Even though this new benchmark has been available for about five years, there…

Read more

3 comments, 1,225 reads

Posted in Glenn Berry's SQL Server Performance on 23 May 2012

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3 CU5, which is Build 10.00.5785.00. There are only four fixes listed in the public fix list. The second Cumulative Update is SQL Server 2008 SP2 CU10, which is… Read more

1 comments, 1,192 reads

Posted in Glenn Berry's SQL Server Performance on 21 May 2012

Dell 12th Generation Server Cheat Sheet

Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use the new 32nm Intel Xeon E5 series processor (aka Sandy Bridge-EP). These new servers all have much higher memory density and more PCI-E slots (which are also PCI-E 3.0) compared… Read more

10 comments, 1,504 reads

Posted in Glenn Berry's SQL Server Performance on 16 May 2012

Speaking at Rocky Mountain Tech Trifecta 2012 on May 19

I will be presenting two sessions at the Rocky Mountain Tech Trifecta in Denver on May 19, 2012. This is an all-day, free event that is very similar to a SQLSaturday or a CodeCamp. There are a large number of great speakers at the event (which is not SQL Server… Read more

0 comments, 443 reads

Posted in Glenn Berry's SQL Server Performance on 10 May 2012

The Fantastic 12 of SQL Server 2012

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the SQL Server Product team talk about their favorite features and improvements in SQL Server 2012. These videos go up every Thursday, continuing through the end of June. The first… Read more

1 comments, 689 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2012

Updated SQL Rockstar Blogger Rankings

This morning, Thomas LaRock (blog |@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to see that I had been promoted to the ResourceDB group, which I really appreciate!  My co-worker, Joe Sack (blog | @josephsack) has been promoted… Read more

0 comments, 534 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2012

SQL Server 2005 Diagnostic Information Queries (May 2012)

Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are still using it and will be for some time to come. Because of this, I decided to release an updated version of my diagnostic queries for SQL Server 2005.… Read more

4 comments, 1,861 reads

Posted in Glenn Berry's SQL Server Performance on 4 May 2012

Building an Intel Ivy Bridge Desktop System, Part 2

A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm Ivy Bridge based desktop system. When I wrote that initial blog post, the actual Ivy Bridge desktop processors were not yet available for sale, but that changed on Sunday, April… Read more

5 comments, 1,330 reads

Posted in Glenn Berry's SQL Server Performance on 2 May 2012

Checking Your Main BIOS Version

As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration. I started out as an 0311 Basic Rifleman (aka Grunt) for a couple of years, and then became an 1811 Armor Crewman, ending up as a Tank Commander… Read more

10 comments, 1,193 reads

Posted in Glenn Berry's SQL Server Performance on 1 May 2012