Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2011

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 (the E3 Series and the E7 Series) and the upcoming… Read more

0 comments, 108 reads

Posted in Glenn Berry's SQL Server Performance on 11 April 2011

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 system for new and upcoming processors).

Knowing how to… Read more

0 comments, 119 reads

Posted in Glenn Berry's SQL Server Performance on 10 April 2011

A SQL Server Hardware Nugget A Day – Day 9

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 there has been on the Intel side recently, so… Read more

0 comments, 238 reads

Posted in Glenn Berry's SQL Server Performance on 10 April 2011

A SQL Server Hardware Nugget A Day – Day 8

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 the recently released Intel processors over the past couple of… Read more

0 comments, 173 reads

Posted in Glenn Berry's SQL Server Performance on 8 April 2011

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

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. DMV: How to Use Dynamic Management Views to Monitor and…

Read more

1 comments, 346 reads

Posted in Glenn Berry's SQL Server Performance on 7 April 2011

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 download and use the 64-bit, English, no install… Read more

1 comments, 595 reads

Posted in Glenn Berry's SQL Server Performance on 7 April 2011

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

Unfortunately, this makes it much more difficult for… Read more

0 comments, 1,003 reads

Posted in Glenn Berry's SQL Server Performance on 6 April 2011

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 server, which might be a problem for some people, depending… Read more

0 comments, 158 reads

Posted in Glenn Berry's SQL Server Performance on 6 April 2011

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

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 who are not able to logon to their database servers… Read more

2 comments, 260 reads

Posted in Glenn Berry's SQL Server Performance on 5 April 2011

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 via RDP), I will talk about what you can learn… Read more

0 comments, 349 reads

Posted in Glenn Berry's SQL Server Performance on 5 April 2011

A SQL Server Hardware Nugget A Day – Day 4

Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released in Q3 2011. This will be a 32nm processor that will be used in both desktop systems and server systems. It will initially have up to 16-cores in… Read more

2 comments, 146 reads

Posted in Glenn Berry's SQL Server Performance on 4 April 2011

A SQL Server Hardware Nugget A Day – Day 3

Lest anyone accuse me of ignoring AMD in this series, I will talk about the AMD Opteron 6100 series processors today.  AMD released several new models in this family on February 14, 2011, the most interesting of which is the 2.5GHz, twelve-core Opteron 6180 SE, which is their new,… Read more

0 comments, 125 reads

Posted in Glenn Berry's SQL Server Performance on 3 April 2011

A SQL Server Hardware Nugget A Day – Day 2

For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor family. Instead of this processor series being called the Intel Xeon 7600 series (as was expected), it is going to be called the Intel Xeon E7 series, with separate… Read more

0 comments, 242 reads

Posted in Glenn Berry's SQL Server Performance on 2 April 2011

A SQL Server Hardware Nugget A Day – Day 1

Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV a Day”, where I wrote a blog post every day during the month of April, since I am going to do it again this year, focusing on hardware… Read more

0 comments, 192 reads

Posted in Glenn Berry's SQL Server Performance on 2 April 2011

Newer posts