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.