MS SQL Server - improving perfomance by moving the tempdb and log files

By greavette ·

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 200. Raid 10 with partitioned drive (C: and ). I have VM datastore on 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 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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

That particular performance improvement

by Tony Hopkinson In reply to MS SQL Server - improving ...

is only of real use (to any sql server app) for a split across physical disks, in fact to get a real hit controllers. It can then simultaneously update log and data. I can't see a low level hardware performance improvement having any noticeable impact thru an app runnimg on a VM. If it aint't broke don't fix it would be thought...

Collapse -

It would seem we would need a completely new hard drive then...

by greavette In reply to That particular performan ...

Hello Tony,

Thank you for the reply. It would seem that for us to realize a performance boost by moving our tempdb would be to move the tempdb completely off our host drives (our Host Server Raid 10 array). Perhaps attach an external drive (through USB or Firewire) and put the tempdb there.

Collapse -

Well if you can add another drive

by Tony Hopkinson In reply to It would seem we would ne ...

and make it available to the VM running sql server and then map the location of the file to it, you may get some performance improvement, but that will be dependant on how the VM works not sql server.
The whole point of a VM is to isolate it from the physical hardware and this improvement is a physical one, I'm dubious about any return you'll get from this effort.

Related Discussions

Related Forums