Tag Archives: Hardware

Speaking at Colorado Springs SQL Server User’s Group on June 15

Posted on May 9, 2011 by Glenn Berry

I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15, 2011.  I will be giving an updated version of my Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance … Continue reading →

Posted in PASS, Teaching | Tagged | Leave a comment

A SQL Server Hardware Nugget A Day – Series Recap

Posted on May 1, 2011 by Glenn Berry

Writing a month long series is always a lot more work than you initially expect. You would think that I would have remembered that fact from April 2010, when I wrote my DMV a Day series…  Since my memory was … Continue reading →

Posted in Computer Hardware | Tagged | 6 Comments

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

A SQL Server Hardware Nugget A Day – Day 16

Posted on April 16, 2011 by Glenn Berry

For Day 16 of this series, I want to talk a little bit about the new hardware license limits that were introduced with in SQL Server 2008 R2. As you may be aware, Microsoft introduced two new high-end editions of … Continue reading →

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

A SQL Server Hardware Nugget A Day – Day 11

Posted on April 10, 2011 by Glenn Berry

For Day 11, I want to talk about the new processor numbering system for Xeon processors that Intel introduced on April 5, 2011. This new system will only be used for the new processors that Intel released on April 5 … Continue reading →

Posted in Computer Hardware, Processors | Tagged , , | 1 Comment

A SQL Server Hardware Nugget A Day – Day 9

Posted on April 9, 2011 by Glenn Berry

For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for different sizes of database servers and different workload types. There is not as much change on the AMD front as … Continue reading →

Posted in Computer Hardware, Processors | Tagged , | 6 Comments