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

Archives: November 2011

Tuesday Hardware Tidbits, Nov 29, 2011

Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core licenses per physical socket, I have had a few questions about what is the “best” quad-core processor to choose for SQL Server 2012 (in order to minimize your SQL… Read more

1 comments, 528 reads

Posted in Glenn Berry's SQL Server Performance on 30 November 2011

Promoted to Master Group By Thomas LaRock

SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had moved me up from the Model group to the Master group. This is quite an honor, since Thomas spends quite a bit of time monitoring and evaluating the content from… Read more

1 comments, 438 reads

Posted in Glenn Berry's SQL Server Performance on 29 November 2011

Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug

Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator.  I recently became reacquainted with this old problem with Error: 18056, Severity: 20, State: 29. Basically what happens is that a SQL Server 2008 or 2008 R2 database server… Read more

7 comments, 5,292 reads

Posted in Glenn Berry's SQL Server Performance on 26 November 2011

Speaking at Spring 2012 SQL Server Connections in Las Vegas

I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas, Nevada. This conference will be held from March 26-29, 2012, and you can register here. The banner on the conference web page says “We are excited to host one… Read more

0 comments, 658 reads

Posted in Glenn Berry's SQL Server Performance on 23 November 2011

SQL Server 2008 Service Pack 3 Cumulative Update 2 Released

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3 fixes in this CU. As I always do, I want to remind everyone that this CU is only for SQL Server 2008 SP2, not for SQL Server 2008 R2.… Read more

0 comments, 1,129 reads

Posted in Glenn Berry's SQL Server Performance on 22 November 2011

SQL Server 2008 Service Pack 2 Cumulative Update 7 Released

Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes in this CU, several of which are related to Full-Text indexes. If you are still on the SQL Server 2008 SP2 branch, I would be thinking about getting on… Read more

0 comments, 839 reads

Posted in Glenn Berry's SQL Server Performance on 22 November 2011

Tuesday Hardware Tidbits, Nov 15, 2011

A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end, Sandy Bridge-E desktop processors that use the LGA 2011 platform and X79 chipset. This is relevant for SQL Server professionals because Sandy Bridge-E is a binned version of the upcoming… Read more

0 comments, 534 reads

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

OT: Amateur Astronomy

Back in 1997, when the Mars Pathfinder bounced down on Mars on July 4, releasing the little Sojourner rover to move around the Martian surface, I became interested in Astronomy. I was living in an apartment in Foothill Ranch, California, stuck in an area with quite a bit of light… Read more

0 comments, 592 reads

Posted in Glenn Berry's SQL Server Performance on 12 November 2011

SQL Server 2012 Licensing and Hardware Considerations

Last week, Microsoft announced some pretty fundamental changes in how SQL Server 2012 will be licensed compared to previous versions of SQL Server. With SQL Server 2012, there will be three main Editions of SQL Server. These are Enterprise Edition, Business Intelligence Edition, and Standard Edition. Data Center Edition and… Read more

8 comments, 3,298 reads

Posted in Glenn Berry's SQL Server Performance on 11 November 2011

Eighty Logical Cores of Goodness!

I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will be used as database servers for SQL Server 2008 R2. These two servers have four Intel Xeon E7-4870 (32nm Westmere-EX) processors and 256GB of RAM each.  This model server can… Read more

4 comments, 959 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2011