Monthly Archives: April 2011

A SQL Server Hardware Nugget A Day – Day 29

Posted on April 30, 2011 by Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 Glenn Berry

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 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