Link to home
Start Free TrialLog in
Avatar of CASorter
CASorterFlag for United States of America

asked on

would putting the tempDB on a separate logical drive help performance on a virtual machine like it would running on a physical box?

i have heard the logic and think in understand the reasoning of putting the tempDB on a separate physical drive when the SQL server is a standalone box.

and i *think* it is a combination of being on a separate controller and not sharing physical platter seeks when reading and writing data.


my question is
would that performance translate if the SQL server is a virtual machine?
is there a benefit to putting the tempdb on a different logical drive on the VM?

is there a separate "virtual" controller for the 2nd drive?


(also i think by extention...   putting the tempdb on a separate "drive" that is actually just a separate partion of one physical drive would not really provide the desired benefit either.... right?

also...  if this VM happens to be a VM on an Azure platform in the cloud ...  does that affect anything?


TIA
ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CASorter

ASKER

ya, that gets more into the virtual server world than i know.


i know nothing of how it is set up or how the drives are allocated.

can you have a virtual disk on a different datastore than the VM?
Yes, you can have the VM configuration on one datastore, and have different virtual disks, on fast and slow datastores, with different technologies. e.g. SSD/Flash or Standard slow hard drives.
It's a little different, because you select which storage you want to use, but it would apply.

e.g. Premium or Standard, so OS on Standard Storage, and tempdb on Premium.

or you entire VM, on Premium Storage.