CASorter
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
would this come into play
http://azure.microsoft.com/en-us/documentation/articles/storage-premium-storage-preview-portal/
http://azure.microsoft.com/en-us/documentation/articles/storage-premium-storage-preview-portal/
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.
e.g. Premium or Standard, so OS on Standard Storage, and tempdb on Premium.
or you entire VM, on Premium Storage.
ASKER
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?