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, 2,309 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,908 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
10 comments, 1,049 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…
10 comments, 1,343 reads
Posted in Glenn Berry's SQL Server Performance on 3 July 2012