Monthly Archives: April 2011

A SQL Server Hardware Nugget A Day – Day 29

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

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

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

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

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

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

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