Free Power Tools Brochure
Get Mark Minasi's
17-page guide today!



      

advertisement

Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Productivity Tips

Subscribe Now!

June 22, 2005 09:22 PM

Bare-Metal Tuning

Build a high-performance SQL Server system from the ground up
Rating: (0)
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...

ARTICLE TOOLS

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Monthly or Annual

Professional Membership

VIP Membership

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

advertisement

Related Resources

Exchange Storage Ins and Outs
A EBook by Dell/EqualLogic
Special Report: Perspectives on SQL Server Sprawl
A Essential Guide by PolyServe
More

windows 7 profile removal

Does anyone know of a script that will delete all domain profiles or all if easier upon reboot? With XP I used to do this with Delprof. I know there i...222-96223

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

Podcasts

To successfully implement virtual desktops, IT administrators must carefully match user requirements to specific desktop technologies. Listen to this podcast to learn what you need to keep in mind when formulating your approach to desktop virtualization.

Downloads

PacketTrap IT is a comprehensive and affordable network management and application monitoring solution that solves problems associated with bandwidth, network and application performance, and connectivity. Gain insight into your network - try PacketTrapIT free for 21 days!

Web Seminars

Aside from its employees, data is an organization’s most important resource. Join Windows technical specialist and 11-time MVP John Savill to learn the best practices for managing data using features in Windows Server.
View this web seminar on demand!

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux

Subscribe to Windows IT Pro!

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