Virtual machine setup – SQL 2005

35 pts.
Tags:
SQL
SQL 2005
Virtual Machines
VM
I’m setting up a virtual machine -- SQL 2005 install -- and I want to make a separate drive for the logs and one for the data, but as this is a virtual environment using the same mirrored physical disk, is that advisable?
ASKED: February 25, 2009  2:22 PM
UPDATED: February 25, 2009  6:57 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes it is still advisable as this way the virtual machine’s OS will see the two disks separately and each will have its own IO queue. It also gives you more flexibility in the future if you move the VM to a larger host machine which has the drives laid out in multiple RAID 5 or RAID 10 arrays.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following