Filter out Long Running Query alerts based on wait type
We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNC_NETWORK_IO for ages (close to 40 minutes).
We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).
We'd like a way that we can not raise a long running query alert if it's waiting on ASYNC_NETWORK_IO