Hi,
We have an scenario when an app fails and some queries start running on our operational DB. The queries will change but they all use CHANGETRACKING which is specific to that app. I would like an alert that will notify us when DPA sees any query with CHANGETRACKING in the text.
I found a custom alert that goes directly to the monitored DB, but I am ok waiting for DPA to see it in the top queries. I can't do it based on the hash or a specific DB instance though because I want to monitor multiple instances too.
Any help is greatly appreciated.
Thank you
