Post reply

RAID 5 Single Disk partition

  • March 5, 2009 at 10:29 am

    #131498

    Could someone summarize for me why I would not want to use the following subsystem configuration:

    I have a physical server that has a RAID 5 configuration with one disk partition. The OS, various applications, and SQL Server Standard Edition 2005 (along with all of the database and log files) are running on this drive.

    I need to explain in plain English (I don't know why this is so hard for me) why it would be better to have at least 2 logical partitions on this RAID array.

    Furthermore, could you suggest a better RAID configuration for this sytem - the databases are supporting network monitoring applications (i.e. Whatsup Gold, NetApp, Quest Spotlight).

    Thank you in advance!

    - S

  • March 5, 2009 at 10:53 am

    #954217

    here's a nice ref:

    http://kendalvandyke.blogspot.com/2009/02/disk-performance-hands-on-series.html

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • March 5, 2009 at 11:03 am

    #954223

    Thanks for the article link. I will find good use of it - perhaps I can summarize for my manager - unfortunately he won't read it.

    Basically I am trying to explain why I want to have more than one disk on this RAID 5 configuration. I told him it was to separate physical storage for the OS and then the database and log files.

    Since it's all on one RAID 5 I guess there's not much performance gain for creating another disk and separating the database files from the OS and application files...right?

  • March 5, 2009 at 11:04 am

    #954224

    I'm not sure you get a lot from 2 partitions. I suppose one could become corrupt and not the other, which would be nice to have data on one, logs/backups on the 2nd, but typically if the RAID array fails, you lose things.

    R5 isn't recommended anymore for db servers. And a DB server should have 2 physical partitions.

  • March 5, 2009 at 11:36 am

    #954246

    Thanks so much!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply