Unsolved
This post is more than 5 years old
2 Intern
•
227 Posts
0
490
September 3rd, 2014 14:00
VMware 5.1 VMFS/VMAX/SQL Best Practices
Looking for advice on what folks are doing when it comes to VMFS volumes and SQL. Are you separating the LOG/TEMPDB/DB files onto separate VMFS volumes, is there a need when backed by a single pool? Just looking for some thoughts?
No Events found!
justpaul1
25 Posts
0
September 22nd, 2014 11:00
Performance-wise, you are correct in that you are going to get the same since you are backed by the same pool. However, you may want to consider separating the DB's depending on their size and your RTO (recovery time objective). Additionally, if you are using Replication Manager for protecting your SQL (or any VDI/VSS backup technology), you need to keep them system databases (master, msdb, model, etc) on different volumes from your user databases. Microsoft SQL server does not support using VDI and snapshot technology to restore system databases.