We are getting alerts for a system table/view that seems to not have it's stats updated(plan_persist_wait_stats).
How can we exclude system tables from this alert ? We have already excluded system databases.
Hi @guruN , this is not a system table, but looks to be a user created table from the LTMDSCommonDB3 database. If you want to exclude that database, you can do it as part of the alert definition:
@darichar We did a meeting in a support case on this issue and it's not that simple. The item showing is an MS_SHIPPED index that isn't clearly in a database and exclude there seems to not work.
We are going to look into changes to the alert code if needed with the Dev
Ah sorry, got it. We should exclude where is_ms_shipped=1 objects. Yes, makes sense and that will most likely take a code change.
Thanks guys. It's heartening to know that the support team from SW is also patrolling these pages. We have confirmation from dev about the query we should use in the custom alert, and will be deploying that soon.
