Monthly Archives: January 2012

January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries

Posted on January 23, 2012 by Glenn Berry

Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time to release a new version of my SQL Server 2008/2008 R2 Diagnostic Information Queries for January 2012. You will need … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 4 Comments

Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3

Posted on January 12, 2012 by Glenn Berry

I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two node, single instance fail-over cluster, running on Windows Server 2003 R2 SP2. As you may be aware, this entire stack … Continue reading →

Posted in Microsoft, SQL Server 2005, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged | 9 Comments

Scaling SQL Server Presentation from SQLSaturday #104 Precon

Posted on January 12, 2012 by Glenn Berry

On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation down in Colorado Springs. I think it went pretty well, and I got some nice feedback from the attendees. Being … Continue reading →

Posted in PASS, Processors, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 2 Comments

New TPC-E Benchmark for HP DL385 G7

Posted on January 3, 2012 by Glenn Berry

Somewhat unnoticed during the holiday season, HP has submitted a new TPC-E benchmark for the DL385 G7 two socket database server, equipped with two 32nm 2.6GHz AMD Opteron 6282SE processors. This system, with 256GB of RAM and 84 spindles (in … Continue reading →

Posted in Microsoft, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged , | 4 Comments