Monthly Archives: April 2011

A SQL Server Hardware Nugget A Day – Day 29

Posted on April 30, 2011 by

For Day 29 of this series, I am going to talk about some of the basic things that you should consider from a hardware perspective when you are trying to increase the basic resiliency and availability of an individual database … Continue reading →

Posted in Computer Hardware | Tagged , | 1 Comment

A SQL Server Hardware Nugget A Day – Day 28

Posted on April 28, 2011 by

For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel desktop chipsets and Intel consumer level SSDs, and how they will work together. This technology is relevant for desktop systems … Continue reading →

Posted in Computer Hardware | Tagged , | 2 Comments

A SQL Server Hardware Nugget A Day – Day 27

Posted on April 27, 2011 by

For Day 27 of this series, I am going to talk a little bit about disk performance and one easy tool you can use to compare the performance of different types of disks and disk arrays. CrystalDiskMark, available from Crystal … Continue reading →

Posted in Computer Hardware | Tagged , | 1 Comment

A SQL Server Hardware Nugget A Day – Day 26

Posted on April 26, 2011 by

For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a lot of questions about it).  Many DBAs, Developers, and consultants use laptop computers as their primary workstations for working with … Continue reading →

Posted in Computer Hardware | Tagged | 1 Comment

A SQL Server Hardware Nugget A Day – Day 25

Posted on April 25, 2011 by

For Day 25 of this series, I want to talk about how you go about picking a CPU for your database server. A couple of days ago, I covered some factors to consider when choosing between a two-socket and a … Continue reading →

Posted in Computer Hardware | Tagged | 3 Comments

A SQL Server Hardware Nugget A Day – Day 24

Posted on April 24, 2011 by

For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark. The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in February 2007. TPC-E is a not a replacement … Continue reading →

Posted in Computer Hardware, Processors | Tagged | 1 Comment

A SQL Server Hardware Nugget A Day – Day 23

Posted on April 24, 2011 by

For Day 23 of this series, I want to talk a little about some things to consider as you make the decision whether to purchase a four socket database server or two socket database server. Traditionally, it was very common … Continue reading →

Posted in Computer Hardware, Processors | Tagged | 2 Comments

A SQL Server Hardware Nugget A Day – Day 22

Posted on April 22, 2011 by

For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related issues of 32-bit vs. 64-bit operating systems and 32-bit vs. 64-bit versions of SQL Server. Most recent releases of Windows … Continue reading →

Posted in Computer Hardware | 2 Comments

A SQL Server Hardware Nugget A Day – Day 21

Posted on April 21, 2011 by

For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance. Cache Size and the Importance of the L2 and L3 Caches All Intel-compatible CPUs have multiple levels of cache. The … Continue reading →

Posted in Computer Hardware | Tagged , | 2 Comments

A SQL Server Hardware Nugget A Day – Day 20

Posted on April 20, 2011 by

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