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 29

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 server. These are some of the first steps you… Read more

0 comments, 538 reads

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

A SQL Server Hardware Nugget A Day – Day 28

For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel desktop chipsets and Intel consumer level SSDs, and how they will work together. This technology is relevant for desktop systems initially, but will probably show up in laptop systems… Read more

0 comments, 658 reads

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

A SQL Server Hardware Nugget A Day – Day 27

For Day 27 of this series, I am going to talk a little bit about disk performance and one easy tool you can use to compare the performance of different types of disks and disk arrays.

CrystalDiskMark, available from Crystal Dew World  is a widely used I/O component…

Read more

0 comments, 637 reads

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

A SQL Server Hardware Nugget A Day – Day 26

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 SQL Server. Even more than an actual database server,… Read more

7 comments, 539 reads

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

A SQL Server Hardware Nugget A Day – Day 25

For Day 25 of this series, I want to talk about how you go about picking a CPU for your database server. A couple of days ago, I covered some factors to consider when choosing between a two-socket and a four-socket database server. As you come to a decision… Read more

1 comments, 217 reads

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

A SQL Server Hardware Nugget A Day – Day 24

For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.

The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in February 2007. TPC-E is a not a replacement for the older TPC-C benchmark, but rather is…

Read more

0 comments, 244 reads

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

A SQL Server Hardware Nugget A Day – Day 23

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 to use a four socket machine for most database server… Read more

0 comments, 308 reads

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

A SQL Server Hardware Nugget A Day – Day 22

For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related issues of 32-bit vs. 64-bit operating systems and 32-bit vs. 64-bit versions of SQL Server.

Most recent releases of Windows Server are available in three different versions: x86 (32-bit), x64…

Read more

2 comments, 359 reads

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

A SQL Server Hardware Nugget A Day – Day 21

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 Level 1 (L1) cache has the lowest latency (i.e. the…

Read more

1 comments, 413 reads

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

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 recently, and I have been thinking about it some… Read more

0 comments, 267 reads

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

A SQL Server Hardware Nugget A Day – Day 19

For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array controllers. Here is what Wikipedia has to say about RAID controllers:

A disk array controller is a device which manages the physical disk drives and presents them to the computer…

Read more

0 comments, 168 reads

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

SQL Server 2008 R2 RTM Cumulative Update 7

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 7, which is Build 10.50.1777. 0.  I count 33 fixes in this Cumulative Update. The most interesting one for me is this one, regarding a “Non-yielding scheduler error when you run a query that uses a TVP in… Read more

0 comments, 417 reads

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

A SQL Server Hardware Nugget A Day – Day 18

For Day 18 of the series, we will talk about AMD Turbo CORE technology. AMD Turbo CORE is a technology that was recently introduced in the AMD Phenom desktop processor, but the way AMD is going to implement it in the upcoming Bulldozer family of processors is greatly enhanced. AMD… Read more

2 comments, 170 reads

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

A SQL Server Hardware Nugget A Day – Day 17

For Day 17 of this series, I am going to talk about Geekbench. Geekbench is a cross-platform, synthetic benchmark tool from Primate Labs. It provides a comprehensive set of benchmarks designed to quickly and accurately measure processor and memory performance. There are 32-bit and 64-bit versions of Geekbench,… Read more

0 comments, 197 reads

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

A SQL Server Hardware Nugget A Day – Day 16

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 SQL Server that are above the old “top-of-the-line” SQL Server… Read more

0 comments, 427 reads

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

A SQL Server Hardware Nugget A Day – Day 15

For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance. I have written about this subject a couple of times before, here and here. Other people, such as Paul Randal (blog|Twitter) and Brent Ozar… Read more

0 comments, 178 reads

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

A SQL Server Hardware Nugget A Day – Day 14

Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce a new processor family, incorporating a new microarchitecture; this is the Tock release. One year after the Tock release, they introduce a new processor family that uses the same microarchitecture…

Read more

0 comments, 182 reads

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

A SQL Server Hardware Nugget A Day – Day 13

For Day 13 of this series, we will cover Intel Turbo Boost Technology. This is not like the the old Turbo button that was on many computers back in the 1980s-1990s. Instead, Turbo Boost Technology and the newer Turbo Boost Technology 2.0 are essentially intelligent overclocking of individual cores… Read more

0 comments, 185 reads

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

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 to understand what the model numbers mean.

Recent AMD… Read more

0 comments, 233 reads

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

April Version of SQL Server 2008 Diagnostic Queries

I have added two new queries to this month’s version, to try to collect some more hardware information about the database server. I specifically wanted to find out more information about the processor type from T-SQL, since many DBAs don’t have direct access to their database server to run a… Read more

2 comments, 193 reads

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

Older posts