Category Archives: Windows Server 2008 R2

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 … Continue reading

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

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 … Continue reading

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

Two New TPC-E Submissions

Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three recent submissions back on June 15. The TPC-E benchmark is a very useful comparison and sizing tool for OLTP workloads. … Continue reading

Posted in Computer Hardware, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged , , | 2 Comments

Three New TPC-E Submissions

I just noticed three very recent new TPC-E Benchmark Submissions that I thought were quite interesting. As I have written before, I think the TPC-E OLTP benchmark is a very useful tool for helping to make hardware selection and sizing … Continue reading

Posted in Computer Hardware, Microsoft, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged | Leave a comment

A SQL Server Hardware Nugget A Day – Day 20

For Day 20 of this series, we are going to talk about some factors to consider if you are thinking about building a desktop SQL Server system for development, or testing use. I have had several questions about this subject … Continue reading

Posted in Computer Hardware, Processors, Windows Server 2008, Windows Server 2008 R2 | Tagged , | 2 Comments

A SQL Server Hardware Nugget A Day – Day 15

For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance. I have written about this subject a couple of times before, here and here. Other people, such as Paul Randal … Continue reading

Posted in Computer Hardware, Processors, Windows Server 2008, Windows Server 2008 R2 | Tagged | 3 Comments

How to Interpret SELECT @@VERSION in SQL Server

One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly understand the results that are returned. I have seen many people mix up the SQL Server portion of the results … Continue reading

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