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

Archives: January 2012

January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries

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 VIEW SERVER STATE permission for most of these queries,… Read more

4 comments, 823 reads

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

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

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 is out of Mainstream support from Microsoft (both the OS… Read more

9 comments, 1,751 reads

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

Scaling SQL Server Presentation from SQLSaturday #104 Precon

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 in a smaller room gives you a much better opportunity… Read more

2 comments, 771 reads

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

New TPC-E Benchmark for HP DL385 G7

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 two Violin Memory Systems V3205 Flash Memory arrays Read more

4 comments, 1,229 reads

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