Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Placement of OS and SQL files on a RAID Arrays.

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
dqnet
Asked:
dqnet
  • 2
  • 2
1 Solution
 
StampelCommented:
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
 
dqnetAuthor Commented:
Confirmed my opinion too - Thanks mate!
0
 
StampelCommented:
you're welcome
0
 
Gerald ConnollyCommented:
Just make sure your DB and redo log files are on separate spindles
0
 
dqnetAuthor Commented:
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now