Solved

VMWare , use multiple volumes and datastores for vcenter and SQL?

Posted on 2013-11-24
11
647 Views
Last Modified: 2013-12-30
Is it best practice to have vcenter and the SQL database files and the database logs all on separate volumes?

I need to show a co worker evidence of this best practice do you have a link?


 thanks
0
Comment
Question by:NAMEWITHELD12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +3
11 Comments
 
LVL 14

Expert Comment

by:RickEpnet
ID: 39673353
How many VMware hosts do you have?
0
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39673383
16

thanks
0
 
LVL 31

Assisted Solution

by:Gareth Gudger
Gareth Gudger earned 100 total points
ID: 39673390
This is more of a SQL best practice than a VMware one. If possible it is best practice to keep the logs and databases on separate drives.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39673400
what about separate volumes or datastrores? is there any reason not to do this?
0
 
LVL 31

Expert Comment

by:Gareth Gudger
ID: 39673410
Are you using local storage or shared storage?
0
 
LVL 14

Assisted Solution

by:RickEpnet
RickEpnet earned 100 total points
ID: 39673449
When it says drive is mean different spindles. If you have a raid 5 with 3 drives on it. It is not really going to make much of a difference if you put them on separate drives the big difference comes in then you put them on different set of spindles. You want your data abd logs on the fastest set of drive. Separate is better.

So if you have 2 volumes that are on different raid sets that would be best.
0
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39673464
this will be on a netapp san. So what I am going to go with is 3 separate sets of  spindles

1. for the C drive of the SQL spindle set 1

2. for the DB files D: drive spindle set 2

3. for the DB  log files E: drive spindle set 3
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 39673731
In this case I do not think it is needed but you can put the Temp DB on another drive too.

Your Plan looks good.
0
 
LVL 121

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 100 total points
ID: 39673900
If you consult SQL DBAs and SQL Circles, they will advise to do this, but if you have a SAN, which all volumes and LUNs are on the same spindles, difficult todo, and these recommendations were in the days, when we did have SAN volumes spanning hundreds of spindles.
0
 
LVL 22

Assisted Solution

by:robocat
robocat earned 100 total points
ID: 39673939
From a data recovery viewpoint, you should put database and logfiles onto different volumes, especially if you plan to use Netapp Snapmanager for SQL. This way, you can restore the database volume from a snapshot without losing the logfiles (needed for recovery).

If you're really paranoid, you can put the database and log volumes on different aggregates, allowing a full recovery up to the last database transaction, even if you lose an entire aggregate. In a vcenter context, this is not necessary because the vcenter database is not that critical.
0
 
LVL 20

Accepted Solution

by:
compdigit44 earned 100 total points
ID: 39679521
In regards to SQL it is best to reseperate the server drives like the following example:
c:\ = OS
d:\ = Application Install Dir
e:\ = DB Files
f:\ = Log Files
G:\ = Backup
H:\  = Page Files

For the datastore try to break up your volume into high, medium and low IOPS usage.
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
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…

631 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