There are 2 related SQL Server alarms on change plan:
However, these are based on the monitored instance but not on individual statement or batch
Out of the box, there are no alarms for plan changes on individual statements or batches. There could be numerous SQL statements / batches with their own execution changes, so it may not be effective to alert for each change. But based on the collected top SQL Statements, you can use the "Analyze Plan" option to review plan changes.
You may be able to accomplish this by using custom counter and custom alert. It is recommend to engage the PSO (Professional Services) group for assistance with this type of customization. Please note that such an addition would likely generate numerous alarms that might overwhelm users.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center