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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-08-14 : 06:54:31
|
| What is the advantage of having two secondary files inside a filegroup.For example, I can create a table and place it inside a filegroup which obviously will use the secondary files.Not sure why some DBAs create just one but otherscreate more than one secondar files in a filegroup.I have read the booksonline but can not figure out the advantages.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 23:09:31
|
| If server has multiple processores, sql can generate multiple threads to access multiple files in filegroup in parallel. |
 |
|
|
jdba
Starting Member
1 Post |
Posted - 2007-08-15 : 08:54:21
|
| rmiano is quite right for performance reason. place data into different file group can also make backup and restore much more easier. if the hot spot could be predicable, put the frequently access tables into different filegroup at different HD is a best way to go. But it's hard to design which tables are the hot spots. so, someone may just put filegroups in RAID to make things easier |
|
|
|
|
|
|
filegroup