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

Archives: April 2012

SQL Server 2008 Diagnostic Information Queries (May 2012)

Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There are a few queries that only work with SQL Server 2008 R2 SP1, but… Read more

10 comments, 1,012 reads

Posted in Glenn Berry's SQL Server Performance on 30 April 2012

SQL Server 2012 Diagnostic Information Queries (April 2012)

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with SQL…

Read more

1 comments, 1,562 reads

Posted in Glenn Berry's SQL Server Performance on 26 April 2012

Quick Roundup of Intel Ivy Bridge Reviews

The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically 5-20% compared to the 32nmSandy Bridge, depending on the task), a pretty significant boost to integrated graphics performance (typically 40-65% compared to Sandy Bridge), and reduced power consumption under load… Read more

0 comments, 665 reads

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

Intel Ivy Bridge Release Coverage

Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories, which means that the Intel information embargo about the Ivy Bridge processor must be nearly about to expire. From what I have been able to determine, the information embargo is… Read more

1 comments, 650 reads

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

SQL Server 2012 Core Factor Table for AMD Processors

As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can download it here (PDF warning). The complete SQL Server 2012 Licensing Overview is here. The most relevant part of this table regards the newer AMD 31XX, 32XX, 41XX, 42XX,… Read more

3 comments, 1,751 reads

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

Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers

If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is a pretty recent (April 9, 2012) Urgent update to version 2.7.0 for the main system BIOS. Here is Dell’s description of the update:

Dell highly recommends applying…

Read more

4 comments, 1,225 reads

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

Windows Server 2012

Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next version of Windows Server will be called Windows Server 2012. Windows Server 2012 shares a common code base with Windows 8 (which is the client version of the OS). You… Read more

0 comments, 742 reads

Posted in Glenn Berry's SQL Server Performance on 17 April 2012

SQL Server 2008 R2 SP1 CU6 Released

This morning, Microsoft released SQL Server 2008 R2 SP1 CU6, which is Build 10.50.2811.0. This Cumulative Update lists 20 fixes in the public fix list. Remember, this CU is only for SQL Server 2008 R2 Service Pack 1.

Of particular interest to me is a fix for Error 18056,… Read more

0 comments, 1,856 reads

Posted in Glenn Berry's SQL Server Performance on 17 April 2012

SQL Server 2012 RTM Cumulative Update 1

Microsoft has released SQL Server 2012 RTM Cumulative Update 1, which is Build 11.0.2316.0. I count 55 fixes in the public fix list, which is a pretty high number of fixes. This is a good thing, to see the first CU come out so quickly after RTM, with a… Read more

2 comments, 1,338 reads

Posted in Glenn Berry's SQL Server Performance on 12 April 2012

Building an Intel Ivy Bridge Desktop System, Part 1

I stopped by my local Micro Center on April 9, 2012, and I noticed that they had just received their first shipment of ASUS Z77-based motherboards. They were still on the warehouse cart, not even on the shelves yet. There were a number of Micro Center sales people reading the… Read more

1 comments, 834 reads

Posted in Glenn Berry's SQL Server Performance on 11 April 2012

A Tale of Four Laptops

With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012, I thought it might be a good time to do my little part to stimulate the world economy by giving people some reasons to consider upgrading to a shiny new… Read more

2 comments, 2,143 reads

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

Onward and Upward!

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting on May 1, 2012. I am very excited by this opportunity, since I will have the chance to work with a small group of amazing people that I truly… Read more

10 comments, 569 reads

Posted in Glenn Berry's SQL Server Performance on 9 April 2012

More Fun with my NEST Thermostat

NEST has rolled out a nice software update for their NEST thermostat that gives you a 10 day history of your energy usage, that you can drill into in order to graphically display some pretty granular information. Below, you can see the orange bands showing exactly when my furnace was… Read more

3 comments, 631 reads

Posted in Glenn Berry's SQL Server Performance on 5 April 2012

Second TPC-E Benchmark Result Published For SQL Server 2012

NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is a new record of 4614.22 TpsE. This is for an eight socket system with 2.4GHz Intel Xeon E7-8870 processors, 2048GB of RAM, and 472 spindles (including 396 SSDs).

About a… Read more

3 comments, 1,170 reads

Posted in Glenn Berry's SQL Server Performance on 5 April 2012

Intel Sandy Bridge-EP Processor Recap

On March 6, 2012, Intel finally released the Xeon E5 processor family, (aka the Sandy Bridge-EP). Sandy Bridge is a Tock release for Intel, and as such, it represents a huge jump in both performance and power efficiency over the previous 32nm Westmere-EP (which was no slouch). It is initially… Read more

0 comments, 765 reads

Posted in Glenn Berry's SQL Server Performance on 5 April 2012

Toshiba Satellite C655-S5503 Review

If you are “in computers” according to your family and friends, you are typically expected to provide lifetime, free tech support for all computer related issues for everyone you know. Since you are “in computers”, you must automatically know everything there is to know about computers, whether it is hardware… Read more

9 comments, 848 reads

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