Hi SolarWinds Team,
May we request to have a general alert for ANY queries that will exceed a specific % of total instance wait time? Not just for a specific query/ID, but a general alert that will notify us if any query reaches the % of total instance wait time that is configured.
This will greatly help us if we can be notified of queries that exceed a specific instance wait time (Configurable, for example: 20% or more) so we can perform tuning for it. (as the Critical Tuning advisor does not seem to provide alerts, but needs to be checked one by one, and we only wish to tune and check those that have a higher instance wait time - some that show on the Critical Tuning Opportunities have around 5% only, which seems to be not worth tuning) Thank you very much!
