Category Archives: SQL Server 2012

SQL Server 2012 RTM Cumulative Update 3

Posted on August 30, 2012 by Glenn Berry

Microsoft has released SQL Server 2012 RTM Cumulative Update 3, which is Build 11.00.2332. There are 36 fixes (by my count) in the public fix list.  Since SQL Server 2012 RTM is still fairly new, there are still quite a … Continue reading →

Posted in Microsoft, SQL Server 2012 | Tagged | 1 Comment

Upcoming Speaking Events

Posted on August 28, 2012 by Glenn Berry

I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will be presenting a preview version of my PASS Summit 2012 session about how to migrate to SQL Server 2012. The … Continue reading →

Posted in Microsoft, SQL Server 2012, Teaching | Tagged , , | 3 Comments

SQL Server 2012 Diagnostic Information Queries (August 2012)

Posted on August 7, 2012 by Glenn Berry

Here is the August 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries. To go with it is an updated, blank SQL Server 2012 results spreadsheet, … Continue reading →

Posted in SQL Server 2012 | Tagged , | 1 Comment

Two Socket Database Servers vs. Four Socket Database Servers

Posted on July 12, 2012 by Glenn Berry

Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of 1,871.81.  It is no real surprise that this system is using the very capable Intel Xeon E5-2690 processor, which has … Continue reading →

Posted in Computer Hardware, Processors, SQL Server 2012 | Tagged , | 5 Comments

SQL Server 2012 Diagnostic Information Queries (July 2012)

Posted on July 8, 2012 by Glenn Berry

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and two new queries. To go with it is an updated, blank SQL Server … Continue reading →

Posted in SQL Server 2012 | Tagged , | 13 Comments

Win A Free Registration to SQLskills Immersion Event 1

Posted on June 29, 2012 by Glenn Berry

You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training class in Bellevue, WA on August 6 – 10, 2012, sponsored by SQLSentry.  This is really a great chance to … Continue reading →

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

SQL Server 2012 RTM Cumulative Update 2

Posted on June 19, 2012 by Glenn Berry

Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in the public fix list, which is a pretty high number for a cumulative update.  Microsoft maintains a build list for … Continue reading →

Posted in SQL Server 2012 | Tagged | Leave a comment

SQL Server 2012 Diagnostic Information Queries (June 2012)

Posted on June 11, 2012 by Glenn Berry

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including query numbering and one new query at the end. To go with it is an updated, blank results spreadsheet, where … Continue reading →

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 5 Comments

Analyzing TPC-E Benchmark Performance by Physical Processor Core

Posted on May 23, 2012 by Glenn Berry

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

Posted in AMD, Computer Hardware, Intel, Processors, SQL Server 2008 R2, SQL Server 2012 | Tagged , | 3 Comments

Dell 12th Generation Server Cheat Sheet

Posted on May 15, 2012 by Glenn Berry

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

Posted in Computer Hardware, Dell, Processors, SQL Server 2012 | Tagged | 10 Comments