Search
InstantDoc ID
GO

Browse By: Author | Issue

June 22, 2005 09:22 PM

Bare-Metal Tuning

Build a high-performance SQL Server system from the ground up
Rating: (0)
Kevin Kline
SQL Server Magazine
InstantDoc ID #46492
If you spend any time on the SQL Server Magazine discussion forums or Microsoft SQL Server newsgroups, you'll see a lot of questions about hardware setup and configuration. In fact, many of the performance problems that IT professionals encounter result from simple ignorance of good hardware design. I've spent many years as a DBA and developer, but it wasn't until I was specifically tasked with configuring enterprise-class servers that I learned to resolve many of the key difficulties in building well-tuned SQL Servers from the bare metal on up.

I freq...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Kevin, this article is priceless. It arrived in my mailbox a year ago, the day I was preparing to configure and purchase new SQL Server hardware. I am still using it a year later. The comments on hyperthreading proved true - our apps run much better with hyperthreading than without it. Thank you for spending the time to write this bit.

- Anthony Rizzo, MCSE, MCDBA, MCTS

ANTHONY7/7/2006 10:17:33 AM

excellent article

Purple Lady 8/15/2005 9:09:10 AM

Excellent article and very useful for an OLTP application. I'd be interested to see the same sort of discussion with regard to Sql Servers dedicated to Data Warehouses and DSS/Data Marts. Obviously, there would be at least two considerations, the read only issues for BI/Data mining and the update intensive processes for staging the data to these DSS/Data Marts. Since it's difficult to quantify what constitutes a transaction, this would be a tough test to structure.

ROBERT8/7/2005 7:37:51 PM

Article solves many dilemmass. Very helpful.

Matjaz_SQL7/11/2005 1:14:30 AM

Kevin,
This was an excellent article. I have found myself in these dilemmas many times. Thank you for putting this out. One question, though. At a client we found that Hyperthreading actually degraded performance, not improved it. Our testing was with Win2k3 Gold (not SP1). Did your testing include SP1? If not do you know of a reason why a DSS/DW load (ETL, large query, etc.) might prove the opposite of your findings in this article? Thanks in advance.


JONATHAN6/30/2005 11:12:20 AM

Any comments on x86-64bit and dual core would be very helpful.

ANDREW6/29/2005 2:12:14 PM

Excellent - well researchec and best of all, very practical!

Anonymous User 6/27/2005 5:09:22 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.