Step-by-Step Guide: How to spec your SQL Server hardware needs

One of the more difficult tasks on a database administrator's to-do list is to make economical hardware recommendations for applications still under development or about to be deployed. You must select a reputable hardware vendor with a strong future, quantify various indices about your anticipated workload in order to size the hardware correctly and ensure that your hardware solution is modularized to plug in additional capacity on demand. In addition, you have to continually consider new technology advancements, such as the move to 64-bit architectures or switching from local storage to storage area networks.

This guide walks you through the decision-making process.

Spec your SQL Server hardware needs

 Home: Introduction
 Step 1: Invest in good application design
 Step 2: Understand your workload
 Step 3: Know your memory support limitations
 Step 4: Choose a reliable hardware brand
 Step 5: Take advantage of 64-bit
 Step 6: Take advantage of storage area networks
 Step 7: Properly configure your RAID arrays
 Step 8: Use separate disk controllers
 Step 9: Choose and optimize your disks wisely
 Step 10: Optimize CPU activity and speed

---

More information from SearchSQLServer.com

Tip: Test for hardware problems using PHYSICAL ONLY

Tip: Optimize SQL Server hardware performance

Ask the Experts: When to separate physical hard drives

---

ABOUT THE AUTHOR:

Hilary Cotter Hilary Cotter has been involved in IT for more than 20 years as a Web and database consultant. Microsoft first awarded Cotter the Microsoft SQL Server MVP award in 2001. Cotter received his bachelor of applied science degree in mechanical engineering from the University of Toronto and studied economics at the University of Calgary and computer science at UC Berkeley. He is the author of a book on SQL Server transactional replication and is currently working on books on merge replication and Microsoft search technologies. Copyright 2006 TechTarget

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server availability How to configure storage in SQL Server DB with more writes than reads SQL Server replication methods: Snapshot, merge or transactional Licensing a standby server for SQL Server replication Get SQL Server log shipping functionality without Enterprise Edition Monitor database mirroring and replication after a SQL Server upgrade Upgrade live applications to SQL Server 2005 for high availability SQL Server high availability when upgrading to SQL Server 2005 Tutorial: Migrating to SANs from local SQL Server disk storage How to restore SQL Server database to transition server during upgrade SQL Server memory configurations for procedure cache and buffer cache SQL Server availability Research SQL Server backup and recovery Solve SQL Server errors and more from the DBA trenches -- part 2 Licensing a standby server for SQL Server replication Can I encrypt and restore a database backup in SQL Server 2005? SQL Server errors, failures and other problems fixed from the trenches Get SQL Server log shipping functionality without Enterprise Edition SQL Server 2008 backup compression pros and cons SQL Server backups using SAN database snapshots Tips for scheduling and testing SQL Server backups Code to restore SQL Server databases in VB.NET Tricking SQL Server into making full database backups SQL Server backup and recovery Research SQL Server database design and modeling Top 10 SQL Server Tips of 2008 Tutorial: SQL Server indexing tips to improve performance SQL Server database design disasters: How it all starts Physical data storage in SQL Server 2005 and 2008 Enforcing data integrity in a SQL Server database SQL Server 2008 data types: Datetime, string, user-defined and more Supertype and subtype tables in SQL Server SQL Server and data manipulation in T-SQL SQL Server database design disasters: What not to do Check SQL Server database and log file size with this stored procedure

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary rollback  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary