Archives: April 2011
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
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
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…
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
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
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…
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
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…
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…
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
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…
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
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
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
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
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
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…
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
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
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