Hi All

This is regarding Database Tuning Advisor (DTA) in SQL Server 2005, Currently I am using DTA directly on the main production machine system. Of late I have noticed there is a recompilation, why this happens? Is it not proper to use Database Tuning Advisor (DTA) in SQL Server 2005 directly on main machine. What are the Implications?

Thanks,