Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

what is the best practice to create volumes to manage sql servers, file servers and web servers - all are in VM ? i am also planing a remote site with replication on selected volumes.

Please give your inputs - thanks.

share|improve this question
add comment

3 Answers

HP has a couple of documents that I would highly recommend. We configured our systems using these guides with excellent results.

The first one is building high-performance/high-availability IP storage networks: http://bizsupport2.austin.hp.com/bc/docs/support/SupportManual/c01750150/c01750150.pdf

The second one is for SQL configuration with HP P4000 SANs: http://bizsupport2.austin.hp.com/bc/docs/support/SupportManual/c01750912/c01750912.pdf

share|improve this answer
    
Chris S. is absolutely right. Passthrough LUNs are critical for performance. Additionally, make sure that your SQL log disk uses full provisioning and that you use 64k block size when formatting the data and log disks. I think these are in the guide, but wanted to elaborate just in case... –  newmanth Oct 5 '10 at 20:28
add comment

Quick rule of thumb. If you need maximum performance then use a passthrough LUN for every HD.

Usually this isn't the case. For SQL servers it is, use passthrough LUNs only. For everything else you can usually pile the VHDs together on a single LUN. It will depend on your cluster and SAN environment however; especially for replication and hypervisor software.

share|improve this answer
add comment
  1. Put as few VMs on a LUN/datastore as possible (depending on your situation).
  2. Typically your web servers are not going to be high disk IO, so they can live with either the SQL servers or the file servers.
  3. A lot of this depends on what kind of IO you are going to be pushing.
  4. Always follow the software vendor's best practices for setting up the applications.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.