Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Management Data Warehouse notable_query_plans table not purging

The snapshots.notable_query_plans table does not seem to be getting purged. I have ~40GB DB, and the notable_query_plans table is ~30GB of it with data going back to August 2008. It is still growing by > 200MB per day.

The mdw_purge_data job seems to be running fine for the rest of the data, it just doesn't seem to affect the query plans table.

0 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base