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

Archives: July 2012

SQL Server 2008 R2 Service Pack 2

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through SQL Server 2008 Service Pack 1 CU5. If you have already installed SQL Server 2008 R2 SP1 CU6 or CU7, you will want to wait until Microsoft releases SQL… Read more

0 comments, 1,079 reads

Posted in Glenn Berry's SQL Server Performance on 28 July 2012

Two Socket Database Servers vs. Four Socket Database Servers

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 eight physical cores per processor and is the top… Read more

5 comments, 1,091 reads

Posted in Glenn Berry's SQL Server Performance on 13 July 2012

SQL Server 2012 Diagnostic Information Queries (July 2012)

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 2012 results spreadsheet, where the tabs in the… Read more

9 comments, 738 reads

Posted in Glenn Berry's SQL Server Performance on 8 July 2012

SQL Server 2008 Diagnostic Information Queries (July 2012)

Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 results spreadsheet, where the tabs in the spreadsheet are…

Read more

10 comments, 780 reads

Posted in Glenn Berry's SQL Server Performance on 3 July 2012