?
Solved

Windows & SQL --  LUN / Partitioning best practices ?

Posted on 2008-11-12
2
Medium Priority
?
1,368 Views
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.
0
Comment
Question by:Deja99
2 Comments
 
LVL 6

Accepted Solution

by:
bcsql earned 1000 total points
ID: 22947140
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
 

Author Comment

by:Deja99
ID: 22955718
Just as a I thought.

Thank you for your comments.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
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 tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

807 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