SQL Server 2005 disk array

by:
Adam Machanic

What is the best configuration for SQL Server 2005?

From what I've seen so far, recommendations for optimal disk configurations will not change when upgrading to SQL Server 2005 from SQL Server 2000. The article Working with direct attached storage devices: Cost effective drive alignment and RAID configuration , by SQL Server MVP Bill Wunder, does an excellent job of describing disk considerations for SQL Server 2000.

The only additional piece of advice I can recommend for SQL Server 2005 is to ensure that tempdb is on the fastest disks available. Thanks to new features such as shapshot isolation, tempdb will encounter even greater stress than it does in SQL Server 2000 installations. Test carefully when upgrading and make sure it can handle the extra load.

Step 2 of 2:

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor

Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in June 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Pricing out the new Windows Azure SQL Database
E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Adam Machanic

Database Snapshots: Creating read-only copies of a database

Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic...continue reading

SQL vs. T-SQL

SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert...continue reading

Upgrading SQL Servers

Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ...continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Relief groups get big helping hand from self-service BI tools

Fundraising for charitable organizations can be extremely competitive, so some nonprofits are turning to self-service BI to help ...

Data analytics applications let teams call new ticket-pricing plays

Professional sports teams are increasingly embracing analytics tools to help them implement dynamic pricing strategies designed ...

Discover the steps needed to reach successful cloud BI

As company data and processes are moved to the cloud, it makes sense for organizations to begin using cloud BI and analytics ...

SearchDataCenter

Master Red Hat, Debian approaches to Linux package management

Whether you use Red Hat or Debian package manager, get informed on the repositories and commands for easier Linux management.

Outsource IT support without losing control

Secure a highly available IT platform by ensuring you have the best data center support. Without precautions, you may suffer from...

The new face of scale-out storage

There are plenty of new approaches to address ever-growing data needs, including scale-out vs. scale-up designs, the shift ...

SearchDataManagement

CDO jobs on the rise to help wring more business value out of data

Chief data officers are becoming more prevalent in companies, and more necessary, consultant John Ladley said in a webinar -- so ...

It's back to the future for machine learning applications of big data

Machine learning techniques are far from new. What is new, however, is the number of parallelized data processing platforms ...

MapR Hadoop update plies data center waters; Azure learns new tricks

Hadoop vendor MapR's latest release puts the focus on database replication across data centers. Also, Microsoft has built a ...

SearchAWS

The evolution of AWS IaaS and PaaS

When AWS introduced IaaS, it was just the beginning. Services such as Lambda and EC2 Container Service have pushed IaaS and PaaS ...

AWS EBS volumes push the scalability envelope

AWS EBS volumes now offer 16 TB volume sizes and support for up to 20,000 IOPS, but users wish upgrading to the new volumes was a...

Buy or DIY? Get the right performance monitoring service

You can't get around AWS app performance monitoring, but you can avoid the costs. Don't hire a third party -- experiment in-house.

SearchOracle

Oracle touts new switches, servers at Mobile World Congress 2015

Oracle highlighted several new systems and networking products, including the ES2-72 and ES2-64 switches, at the Mobile World ...

Oracle sues top campaign aides over Cover Oregon failure

Oracle and Oregon start another round of lawsuits about Cover Oregon, with Oracle alleging that Cover Oregon failed as a campaign...

New president brings global change management skills to OAUG

The 2015 OAUG president, Melissa English, found a love of education in teaching her peers. Now she brings global change ...

SearchContentManagement

The Clinton email brouhaha and information governance

Hillary Clinton's use of a personal email account raises information governance issues that need to be addressed.

Can SharePoint eDiscovery Center meet your company's legal needs?

SharePoint provides useful native e-discovery capabilities, but they might not be adequate for companies dealing with complex ...

Website upgrades lay groundwork for customer experience strategy

For companies trying to step into the modern era with Web presence, WCM software investments are only the first step.

SearchWindowsServer

Why the free Hyper-V Server may not be worth it

Boasting the ability to install easily and, perhaps even better, cost nothing, Hyper-V Server is a cost-effective option. Should ...

Prepare for these five Windows administrator interview questions

Windows administrator interview candidates need careful preparation to stand out among a crowded field of professionals.

A look at Windows MultiPoint Services role

A Windows MultiPoint Server allows users to have their own sessions while connected to one machine. Here's where it helps, and ...

Dig deeper on Microsoft SQL Server 2005

E-Handbook

E-Handbook

Related Q&A; from Adam Machanic

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: