In SQL Monitor, I want to...

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

6 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Greg shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base