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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-08-12 : 08:38:31
|
| Dear All,i've read in an article stating that placing datapages and index pages on seperate disks will boost the performance. if so,please let me know how can i do this?i think i've to create seperate ndf file. after creating this, how can i trsansfer all the indexes to the newly created datafile?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-12 : 09:05:09
|
| Create a ndf file and put in separate FG. You can right click index and put in separate FG in separate Disk. You will move table as well if transfer clustered index to that FG. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-12 : 23:57:35
|
| >> how can i trsansfer all the indexes to the newly created datafile?You can't separate clustered index from data. By the way, separating index from data doesn't always boost performance. You need test it to see. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-13 : 00:58:53
|
quote:
Originally posted by sodeep
You can right click index and put in separate FG in separate Disk.
where can i found the index to roght click......ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-13 : 12:53:49
|
| On table-index-properties:But as being said: you need Clustered index to move table to other FG. |
|
|
|
|
|
|
datapages and index pages on seperate disks