开发者

SQL Server Database Tuning Advisor Blocking Issues

This is occurring during the end of the analysis when the DTA开发者_如何学JAVA tries to drop the indexes it created. Unfortunately, with the database in use, this is causing terrible blocking issues. Is there a way to prevent this?

Using SQL Server 2008


the only way to get rid of this is to not run the DTA on a live db.
create a backup of the live db, restore it, and run DTA on that.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜