Solved

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

Posted on 2015-02-05
5
232 Views
Last Modified: 2015-02-12
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
Comment
Question by:CASorter
  • 3
  • 2
5 Comments
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40592542
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
 

Author Comment

by:CASorter
ID: 40592587
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
 
LVL 119
ID: 40592593
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
 

Author Comment

by:CASorter
ID: 40592600
0
 
LVL 119
ID: 40592614
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Workspace One/ VDIM/ Airwatch 6 22
Microsoft Access Write errors seem to be caused by bit fields 4 36
VB.NET 2008 - SQL Timeout 9 24
host cache 3 30
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question