Optimize disk configuration in SQL Server 6

[onpnt]

Extremely good article by one of our very own and probably most talented mrdenny

Optimize disk configuration in SQL Server

Read it and don't forget to thank him for his contributions to our community

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[SQLDenis]

Thanks Mr Denny, since you are not here onpnt will accept the Oscar star on your behalf

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[mrdenny]

Thanks guys

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

Denny,
Have a * for a very well written article!

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Thank you Paul.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gmmastros]

Very good article. Nicely done.

-George

"the screen with the little boxes in the window." - Moron

 

[fuzzyocelot]

Great article! It's going to help me out tremendously! Thank you for writing it, mrdenny! And thank you onpnt for posting the link!

 

[intelwizrd]

Thansk for putting together this information. we are getting ready to migrate an enterprise class database from a sql 2000 server to a sql 2005 server and i still had some doubts about the new drive setup. this will help to maximize the benefit of the new server.

----------------------------
Josh
CCNA, MCSE 2003(in progress)

 

[intelwizrd]

Question regarding the section mentioning aligning the data into 64 block sections.

The article says to use DISKPART and align the disk to 64. How do I accomplish this?

create partition primary offset=1

or

create partition primary offset=512

Any help with this would be much appreciated as the documenation does not seem to specify what it interprets the value given in the offset command as.

----------------------------
Josh
CCNA, MCSE 2003(in progress)

 

[mrdenny]

Josh,
I just posted in your thread.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com