3 Replies Latest reply on Feb 21, 2019 11:03 AM by aiglee.castillo

    Alert for query with keyword in top queries

    aiglee.castillo

      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