Monthly Archives: April 2011

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

A SQL Server Hardware Nugget A Day – Day 8

Posted on April 8, 2011 by Glenn Berry

For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for different sizes of database servers and different workload types. This list has a lot of changes because of all of … Continue reading →

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

Presenting Dr. DMV by Live Meeting on April 19 at 12PM CDT

Posted on April 7, 2011 by Glenn Berry

I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19. Here are the meeting details: Join the STLSSUG for a Live Meeting Lecture Tuesday on April 19th from 12-1:00pm CDT Dr. … Continue reading →

Posted in PASS, SQL Server 2008, SQL Server 2008 R2, Teaching | Tagged , | Leave a comment

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

Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali

Posted on April 5, 2011 by Glenn Berry

I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL Server Denali. This seems like a pretty easy change that would be extremely useful, especially for the many database professionals … Continue reading →

Posted in Computer Hardware, Microsoft, Processors, SQL Server Denali | Tagged , | 2 Comments

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