i*a
2 楼
Check index fragmentation.
【在 U****D 的大作中提到】
: Is there a standard? Thanks.
【在 U****D 的大作中提到】
: Is there a standard? Thanks.
U*D
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.
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
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?
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
5 楼
Want to be one.
【在 B*****g 的大作中提到】
: Are you a administrator?
:
: index
【在 B*****g 的大作中提到】
: Are you a administrator?
:
: index
i*a
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?
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
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
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
8 楼
then only rebuild the index that's fragmented
【在 U****D 的大作中提到】
: 2008 SQL server.
: Unfortunately, no partition at all.
【在 U****D 的大作中提到】
: 2008 SQL server.
: Unfortunately, no partition at all.
U*D
9 楼
OK. Thanks.
【在 i****a 的大作中提到】
: then only rebuild the index that's fragmented
【在 i****a 的大作中提到】
: then only rebuild the index that's fragmented
g*l
10 楼
是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
a9
11 楼
index碎片影响到底有多大？感觉实际上没什么太大影响吧？
【在 g***l 的大作中提到】
: 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
: 定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
: JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
【在 g***l 的大作中提到】
: 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
: 定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
: JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
相关阅读
sql server 怎么关掉logsql server management studio to oracle现在有没有人做什么网页数据库用于帮助失散的灾民寻亲啊oracle学习从哪本书看起啊？how to set a reference to Microsoft Excel in Access?sql query help 急问： 请问SQL适合做这种计算吗？【求指点】毕业设计，选什么好？高手指点: 服务器有谁用SQL Server的DTS package连过Teradata吗?2 questions on MySQL privileges小女子，请求帮助SAS 概率面试题请问哪儿有parallel database的简明教程？我是外行，请教一个问题query estimation shows cost 900%?Massive Attack: Half A Million Microsoft-Powered Sites Hit With SQL Injection（ZZ)Questions about SQL Server Lock timeoutexcel 数据中间有‘|’请问那里可以找到Hierarchical Clustering 算法的 C code请教SQL server大牛一个问题