Management Data Warehouse notable_query_plans table not purging
The snapshots.notablequeryplans table does not seem to be getting purged. I have ~40GB DB, and the notablequeryplans table is ~30GB of it with data going back to August 2008. It is still growing by > 200MB per day.
The mdwpurgedata job seems to be running fine for the rest of the data, it just doesn't seem to affect the query plans table.
Upvotes: 0<=-=Dec 15 2009 11:54AM=-=>
Thank you for your feedback. This issue has been previously reported and a fix has already been released. You can find the details of the issue and links to the update that fixes it in the Microsoft KB article at http://support.microsoft.com/kb/970014/.