Tag Archives: Hardware Identification

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 12

Posted on April 12, 2011 by Glenn Berry

In Day 12 of this series, we will be talking about AMD Opteron Processor Numbering. Advanced Micro Devices  (AMD) has various versions of the Opteron family that are meant for server use. When assessing AMD processors, it is very helpful … Continue reading →

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

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 10

Posted on April 10, 2011 by Glenn Berry

Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By “classic”, I mean Intel Xeon processors produced from about 2006 until April 2011 (when Intel introduced a new processor numbering … Continue reading →

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

A SQL Server Hardware Nugget A Day – Day 7

Posted on April 7, 2011 by Glenn Berry

For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free from cpuid.com. The latest release of the tool is version 1.57, which came out on February 18, 2011. I always … Continue reading →

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

Getting More Hardware Information from SQL Server Denali DMV Queries

Posted on April 6, 2011 by Glenn Berry

As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly. Instead, they can only use SQL Server Management Studio (SSMS) to remotely manage the database servers that they are responsible … Continue reading →

Posted in Computer Hardware, SQL Server Denali | Tagged , | 1 Comment

A SQL Server Hardware Nugget A Day – Day 6

Posted on April 6, 2011 by Glenn Berry

For Day 6 of this series, I am going to talk about a few useful tools you can use to identify some hardware details about a database server. These tools all require that you have access to login to that … Continue reading →

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

A SQL Server Hardware Nugget A Day – Day 5

Posted on April 5, 2011 by Glenn Berry

For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a few database professionals do not have direct access to their database servers (i.e. they cannot login to their database server … Continue reading →

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