Windows & SQL --  LUN / Partitioning best practices ?

Posted on 2008-11-12
Last Modified: 2013-11-14
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.
Question by:Deja99
    LVL 6

    Accepted Solution

    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.

    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.


    Author Comment

    Just as a I thought.

    Thank you for your comments.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
    Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
    This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
    This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now