Windows & SQL -- LUN / Partitioning best practices ?

Environment: Windows 2003 Ent, SQL 2005 standard, EMC CX320 FC.

I have a 2 node active/active SQL 2005 cluster. Our DBA has presented a table of the drive setups he wants as setup cluster resources.
This list contains 8 separate drives.

My question is related to best practice for lun presentation/carving.
The luns will be created across 2 RAID 1/0 RAID Groups, setup on the same spindles.

Is it better to create 8 luns and present a unique lun to the OS for single drive partitioning (per lun) or to present larger luns and create multiple partitions on them ?

Any advice is will be welcomed.
Deja99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bcsqlCommented:
You do not buy anything by setting up multiple luns on the same spindles for multiple drives, luns, offered to windows. EMC should have a best practice on how to setup "drives", luns, for mssql databases. What I have run across it you setup three aggregates across 3 different set of spindals. If the disks in the different aggregates, groups of disk, are the same, same rpm etc..,  then you just setup a drive for tempdb a drive for the tranlogs and a drive for the datafiles. To have two luns that span the same spindals offered as two drive to windows only gets you the convience of having different drive letters.

If I am reading this wrong and you can setup each lun across seperate spindals then in theory the dba's setup could work well.

So in short what you want to give the DB is the most spindals possible. Creating multiple luns across the same spendles buys you only convience, unless you can exactly dictate where you lay your files and data on the spindals. But by all means go with the EMC best practices.

http://www.emc.com/collateral/software/solution-overview/h2203-ms-sql-svr-symm-ldv.pdf

Note: I have run across a few occations where the tempdb and the datafiles can not be on the same lun or even aggregate  to use some of the disks advanced features.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Deja99Author Commented:
Just as a I thought.

Thank you for your comments.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.