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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-14 : 14:31:26
|
| I have a small doubt. If we keep our data files and log files on sepertate disks how this can improve the database performance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-14 : 14:36:59
|
| by having 2 disks do what otherwise one disk would have to do.so you reduce the disk IO._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 23:06:57
|
| And sql accesses db data file and log file in different way, separate them can let disk header move more efficient. |
|
|
|
|
|
|
DB performance