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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2010-01-04 : 01:08:42
|
| Hi All,I am thinking to create one extra disk drive and allocate all index on this drive.Can it improve the performance?Also, do I need to create new filegroup?cheers |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-04 : 04:09:08
|
Yes.Yes. - Lumbagohttp://xkcd.com/327/ |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2010-01-04 : 16:40:28
|
Thanks. So basically, 1. Add extra disk drive (H) 2. For each db, create new filegroup named index. Specify directory on disk (H).3. For each db, move table index (cluster? or non cluster?) to the filegroup-index.is that correct?quote:
Originally posted by Lumbago
Yes.Yes.- Lumbagohttp://xkcd.com/327/
|
|
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2010-01-05 : 01:50:29
|
quote:
Originally posted by chih
Thanks. So basically, 1. Add extra disk drive (H) 2. For each db, create new filegroup named index. Specify directory on disk (H).3. For each db, move table index (cluster? or non cluster?) to the filegroup-index.is that correct?
Almost correct.1) Add a physical disk, not just logical drive.2) Firstly change only one database. After few days change other databases.3) Move only the nonclustered indexes. Because, leaf node of clustered index contains row. |
|
|
|
|
|
|
Index in separate filegroup