SQL Server Data Collector: Nightly purge can leave orphaned rows

The Bug Description: The MDW database has a nightly purge job that removes old data unfortunately two tables are not purged by that job: notable_query_plans and notable_query_text.  This leaves orphaned rows in a Data Collector MDW. Are you Impacted? You will know you are impacted by this problem if you have run the built-in MDW…

3