VMware 5.1 VMFS/VMAX/SQL Best Practices

Question

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?

justpaul1 · Answer

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.

VMware 5.1 VMFS/VMAX/SQL Best Practices

Dell Support Resources

Latest Solutions

WiFi not show in my laptop

XPS 13 9315 2-in-1, need parts

Area-51, EVGA 3080 Ti, PSU question

After Bios updated 7320 instead of 7420

SATA Power