[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

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
0
CASorter
Asked:
CASorter
  • 3
  • 2
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
if you put the virtual disk, on a different faster datastore - yes.

but if the datastore, is the same speed for all virtual disks - it's the same!
0
 
CASorterAuthor Commented:
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?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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.
0
 
CASorterAuthor Commented:
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now