Solved

Placement of OS and SQL files on a RAID Arrays.

Posted on 2014-10-22
5
268 Views
Last Modified: 2014-10-23
Hi,
We are in process of setting up our SQL server which is clustered across 2 HP DL380p servers using a HP P2000 for the shared storage with 2 raid 10 (8 disks) arrays and raid 1 mirror (2 disks). We have created 3 LUNS (LUN10, 20, 30) and have created 4 separate VHDx files. 1. OS/SQL (LUN10) 2. MDF (LUN10) 3. LDF (LUN 20) 4. TempDB (LUN30)

LUN 10 is a RAID 10 array with 8 disks
LUN 20 is a RAID 10 array with 8 disks
LUN 30 is a RAID 10 array with 2 disks

My only concern is putting the OS and SQL install and Database files on the same LUN? Is this something that is not recommended or does it really not make a difference? They are separate VHDx files [OS / SQL Install VHD] and [MDF files VHD] but still reside on the same LUN with the same spindles. Do you recommend moving the OS to its own completely independent set of disks? I am guessing there will hardly be any activity on the (OS and SQL binary install VHDx) to justify its need for its own set of spindles? Can they share the same spindles as the MDF files?

Thanks.
0
Comment
Question by:dqnet
  • 2
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Stampel earned 500 total points
ID: 40398757
Yes theoretically it would have been smarter to place OS on a separated RAID1.
But nowadays controllers are very smart, so as far as your Operating System is not a busy one i would probably not bother to move it to a separate place and global performance could be greater when everything is on a RAID10.
Except if you are chasing milliseconds in your application there is no risk to me.

Not to mention we are using Oracle+OS on RAID10 2 VHD for the biggest warehouses stock management in EU. Since RAID10 distributes the IO better over the disks and we have always another HA server immediately available in case failover is needed.
0
 

Author Comment

by:dqnet
ID: 40399023
Confirmed my opinion too - Thanks mate!
0
 
LVL 7

Expert Comment

by:Stampel
ID: 40399039
you're welcome
0
 
LVL 16

Expert Comment

by:Gerald Connolly
ID: 40399550
Just make sure your DB and redo log files are on separate spindles
0
 

Author Comment

by:dqnet
ID: 40399733
They will be. I was just worried about the OS and SQL binaries on the same set of spindles as the DB files.
0

Featured Post

Save on storage to protect fatherhood memories

You're the dad who has everything. This Father's Day, make sure your family memories are protected. My Passport Ultra has automatic backup and password protection to keep your cherished photos and videos safe. With up to 3TB, you have plenty of room to hold the adventures ahead.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to install/upgrade the Blitz responder kit 8 27
TSQL - IF ELSE? 3 29
sql query questions 2 25
sql server group by every 2hrs 5 21
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

863 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

18 Experts available now in Live!

Get 1:1 Help Now