Proper disk configuration reading material

Question

Post reply

Proper disk configuration reading material

Chad Crawford

SSChampion

Points: 11610
More actions
April 13, 2010 at 10:00 am

#220473

I want to review the disk setup for our database servers and go a little deeper than just how many drives we have and how filegroups are set up. For example, I want to review sector size, LUNs spindles, partition alignment and track boundaries, and whatever else makes a difference. I know the items I’ve listed are important to consider, but I'm not sure exactly how to evaluate them and I know that this list is just the tip of the iceberg.
I have googled for some info and found a lot of good information, but it feels fragmented (like there might be some considerations missing) and sometimes I’m not sure what I’m reading is actually correct. So I guess I’m looking for a second opinion. Can you recommend any books, white papers, blogs or other sources that I can use to get down into the meat of how to configure the disk systems?
Thanks,
Chad

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Start Here:

http://msdn.microsoft.com/en-us/library/dd758814.aspx

Then check this one out

http://technet.microsoft.com/en-us/library/cc966534.aspx

Here is a recommendation by Buck Woody (MS Employee knows his stuff)

http://blogs.msdn.com/buckwoody/archive/2009/08/26/sql-server-best-practices-disk-partition-alignment.aspx

Another one by Denny Cherry (higher level disk config)

http://searchsqlserver.techtarget.com/tip/Optimize-disk-configuration-in-SQL-Server

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Chad Crawford SSChampion Points: 11610 More actions · Answer 2

Chad Crawford

SSChampion

Points: 11610

April 13, 2010 at 6:12 pm

#1151084

Awesome. Thanks Jason!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

You're welcome.

I hope it helps.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

WayneS SSC Guru Points: 95460 More actions · Answer 4

I sure wish that forums could be put into one's briefcase. This one would definitely qualify.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

WayneS (4/13/2010)
I sure wish that forums could be put into one's briefcase. This one would definitely qualify.

That would sure be nice. Maybe the IPad would qualify?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 6

This book has a pretty decent section on disk configuration.

SQL Server 2005 Performance Tuning

WROX

ISBN: 978-0-470-17639-9

Maybe you can borrow one?

Chad Crawford SSChampion Points: 11610 More actions · Answer 7

Great suggestion Steve! I'll see if someone in our local users group has a copy I can borrow.

Thanks,

Chad

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Steve-3_5_7_9 (4/15/2010)
This book has a pretty decent section on disk configuration.
SQL Server 2005 Performance Tuning
WROX
ISBN: 978-0-470-17639-9

Nice suggestion. I will have to check into that one too.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events