Hello,
We have an app we’ve bought from a vendor that using MS SQL Server (v2005). We’ve installed this application in a VM running Windows 2003 in VMware Server (version 2). We are a small company and use VMware Server for all our virtualization needs (running 7-8 VM’s on 2 Servers). Everything is working well. We have lots of room on our Host servers and we are not running out of space.
The vendor has mentioned that in order to ensure we get the best performance from their application, we should add disks to our VM so that the SQL Server Tempdb and log files can be moved off the C: drive of the VM.
I know I can add disks to a VM, but my question is regarding where the datastore for these extra disks should live.
In VMWare Server 2, I define a datastore where our VM’s can be found. Our setup looks like the following:
Host Server (runs Win 2008). Raid 10 with partitioned drive (C: and D:). I have VM datastore on D: drive on this host server. For our VM where we would add another hard disk too, should I create the extra disk in the same datastore as where the VM lives (on the Host systems D: drive) or should I create a datastore on the host systems C: drive and add the extra disk there? Does it matter where this extra disk lives on our Host Server or is it just that we’ve moved the tempdb and log files off the VM’s C: drive (no matter where this extra drive lives on the Host Server) that will improve performance?
Any help you may provide in helping me understand the best approach would be greatly appreciated.
Thank You.
