Tag Archives: Hardware Identification

A SQL Server Hardware Nugget A Day – Day 20

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

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

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

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

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

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

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

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