U****D
发帖数: 113 | 1 Is there a standard? Thanks. |
i****a
发帖数: 36252 | 2 Check index fragmentation.
【在 U****D 的大作中提到】
: Is there a standard? Thanks.
|
U****D
发帖数: 113 | 3 Thanks.
We have a 800G database. The administrator set the reorganize/Rebuild index
once a week. It takes more than 2 hours to reorganize index and over 8
hours to rebuild index. Is there a way to shorten the time?
【在 i****a 的大作中提到】
: Check index fragmentation.
|
B*****g
发帖数: 34098 | 4 Are you a administrator?
index
【在 U****D 的大作中提到】
: Thanks.
: We have a 800G database. The administrator set the reorganize/Rebuild index
: once a week. It takes more than 2 hours to reorganize index and over 8
: hours to rebuild index. Is there a way to shorten the time?
|
U****D
发帖数: 113 | 5 Want to be one.
【在 B*****g 的大作中提到】
: Are you a administrator?
:
: index
|
i****a
发帖数: 36252 | 6 SQL server? 2005 or later?
you can have horizontally partitioned tables, and only rebuild index on
the partitions that have fragments. but it's not a simple change if the
database is not already setup this way
index
【在 U****D 的大作中提到】
: Thanks.
: We have a 800G database. The administrator set the reorganize/Rebuild index
: once a week. It takes more than 2 hours to reorganize index and over 8
: hours to rebuild index. Is there a way to shorten the time?
|
U****D
发帖数: 113 | 7 2008 SQL server.
Unfortunately, no partition at all.
【在 i****a 的大作中提到】
: SQL server? 2005 or later?
: you can have horizontally partitioned tables, and only rebuild index on
: the partitions that have fragments. but it's not a simple change if the
: database is not already setup this way
:
: index
|
i****a
发帖数: 36252 | 8 then only rebuild the index that's fragmented
【在 U****D 的大作中提到】
: 2008 SQL server.
: Unfortunately, no partition at all.
|
U****D
发帖数: 113 | 9 OK. Thanks.
【在 i****a 的大作中提到】
: then only rebuild the index that's fragmented
|
g***l
发帖数: 18555 | 10 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了 |
a9
发帖数: 21638 | 11 index碎片影响到底有多大？感觉实际上没什么太大影响吧？
【在 g***l 的大作中提到】
: 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
: 定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
: JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
|
