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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-08-12 : 11:59:32
|
| Hi All,In one of my database A, i wanted to change from 2 data file to multiple data files and individual data files need to be placed in separate drives and LUNS as the Server is having 21 processors.so,that the performance can increase,i need a suggestion that is it a best practice in doing this.Thanks In Advance. |
|
|
3magic
Starting Member
14 Posts |
Posted - 2011-08-17 : 03:54:18
|
| According to me , Yes this is good even for backup also.. |
 |
|
|
|
|
|
Dividing Data files