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 |
|
oxegg
Starting Member
6 Posts |
 Posted - 2010-05-27 : 02:28:51
|
| I want to advance SQL Server performance.So I want to consult how to split MDF and LDF files?Thanks! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-27 : 04:11:54
|
| You can add additional data files, typically they get the .ndf extension. Look up ALTER DATABASE in Books Online.There's no point in splitting a log file for performance. SQL uses them sequentially, not in parallel.Adding additional data data files will only help performance if they are on different physical drives and if your bottleneck was IO-related.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
How to split MDF and LDF files?