|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
 Posted - 05/27/2010 : 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 Shaw
SQL Server MVP |
 |
|
How to split MDF and LDF files?
