Category Archives: Windows Server 2008 R2

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

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

Two New TPC-E Submissions

Posted on August 4, 2011 by Glenn Berry

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

Posted on June 15, 2011 by Glenn Berry

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

Posted on April 20, 2011 by Glenn Berry

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

Posted on April 15, 2011 by Glenn Berry

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

Posted on February 17, 2011 by Glenn Berry

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

Windows Server 2008 R2 SP1 Released and Installed

Posted on February 16, 2011 by Glenn Berry

Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier today. They are using the Akamai Download Manager for these, and I was able to download them very quickly with … Continue reading →

Posted in Windows 7, Windows Server 2008 R2 | Tagged , | 1 Comment

Service Pack 1 for Windows Server 2008 R2 and Windows 7

Posted on February 9, 2011 by Glenn Berry

Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on “The Windows Blog”. It will be available for download on MSDN and TechNet on February 16, and on Windows Update … Continue reading →

Posted in Windows 7, Windows Server 2008 R2 | Tagged | Leave a comment

Microsoft Support Policies for Windows Server and SQL Server

Posted on January 30, 2011 by Glenn Berry

Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack level for Business and Developer products, which include Windows Server and SQL Server. The term “supported service pack level” means … Continue reading →

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