Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m.esteghamat
Starting Member
47 Posts |
 Posted - 2014-12-26 : 20:13:28
|
| There is a Principle :- keep mdf files on a disk and ldf file on another disk for better performanceAnd now most of the servers are virtual.Are the Drives in Virtual servers Are equal to Disks in Physical serevrs? and keep data file and log file to 2 drives make a better performance?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-29 : 13:25:46
|
| It doesn't matter if your server is physical or virtual, the best practice still applies of separating your files. Whether or not the drives are equal is dependent upon your hardware and how it is configured. Yes it can and will make the server perform better. Whether or not is noticeable would be based on your hardware, settings and workload.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Drives in Virtual servers = Disks in Physical s.?