techmiss
asked on
SQL 2008, RAID & VM WAre
Hi All,
I am used to working with physical SQL servers, configuring different RAID packs for logs, OS & data files etc.
I am now faced with a VM Ware server that I wish to put SQL 2008 on, the host that I wish to install this SQL instance on is connected to a SAN through a datastore specifically for the SQL build I am configuring. The SAN uses RAID 50.
My question is this - do I need to worry about th RAID configuration within the virtual server, do I need a datastore for logs and a datastore for database files - or does VM Ware decide this intelligently (even if I had two datastores they could over-lap onto the same disk).
Thanks
I am used to working with physical SQL servers, configuring different RAID packs for logs, OS & data files etc.
I am now faced with a VM Ware server that I wish to put SQL 2008 on, the host that I wish to install this SQL instance on is connected to a SAN through a datastore specifically for the SQL build I am configuring. The SAN uses RAID 50.
My question is this - do I need to worry about th RAID configuration within the virtual server, do I need a datastore for logs and a datastore for database files - or does VM Ware decide this intelligently (even if I had two datastores they could over-lap onto the same disk).
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here's RAID50 explained however as "kevinhsieh" mentioned if you have only one LUN available then don't need to wory about anything else but different folders for different SQL files because your SAN will take care of the rest. Memory is one other thing you need to make sure is enough available for your VM running the SQL Server(s).
http://www.iscsi-raid.com/raid50.html
http://www.iscsi-raid.com/raid50.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Guys,
Thanks, thats pretty much what I figured - I will have to read through the best practices guide in detail.
Split the points as you were both of assistance.
Thanks
Thanks, thats pretty much what I figured - I will have to read through the best practices guide in detail.
Split the points as you were both of assistance.
Thanks
So ensure you configure as many disks as possible in a RAID 10, for optimum read and write performance for all virtual machine disks, that are stored on the datastore. All virtual machines will then benefit from the fast datastore.
More disks = more spindles = more IOPS = more performance.