同时运行CHECKDB和重建索引作业 [英] Running CHECKDB and Rebuild Index Job Simultaneously

问题描述

您好，

我们最近遇到了服务器SQL2k12版本服务器性能显着下降的问题。查看当前正在运行的作业时，发现两个运行DBCC CHECKDB的SQL Server代理作业和另一个运行重建索引
的作业正在运行。终止这些工作后，恢复了正常状态。想知道这些过程如何相互影响？

We recently had an issue where server SQL2k12 ent edition server performance degraded significantly. When looked the current running jobs, found out that two SQL server agent jobs one that was running DBCC CHECKDB and another one running rebuilding of indexes was running. After terminating those jobs, normalcy was restored. Wondering how these processes affect each other?

谢谢。

Victor

Thanks.
Victor

Victor

推荐答案

嗨Victor，

Hi Victor,

这两项操作不应该一起运行。  CHECKDB将对数据库和索引进行逻辑和物理完整性检查。 如果索引重建同时进行，那么这将导致性能严重降低。

These 2 operations should not be ran together.  CHECKDB will be doing logical and physical integrity checks on the database and indexes.  If index rebuilds are going through at the same time then this will cause this to severely degrade performance.

重建索引会给CHECKDB带来很大的开销，因为重建工作正在完成正在执行检查。

Rebuilding of indexes will add a large overhead to CHECKDB due to the rebuild going through whilst an integrity check on them is being performed.

如果你将这些任务分开，那么你应该看到一个改进！

If you separate these tasks then you should see an improvement!

但我也会检查时间正在执行索引重建 - 您希望它在使用较少的情况下运行，因为这会产生IO开销（重建将改变表和索引中的数据，这会在查询
时导致性能问题用于此的额外磁盘IO。。

But I would also check the time that the index rebuild was being performed - you want this to run at times with less usage as this has an IO overhead (the rebuild will be altering data in the tables and indexes, which will cause performance issues when querying those indexes due to the extra disk IO used for this).

谢谢，

Matt

这篇关于同时运行CHECKDB和重建索引作业的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！