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.
精彩评论