Ability to not monitor/show certain queries in the TOP 50 list.
The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow can be addressed.
Elena Lockyer commented
Thank you for your suggestion and feedback about SQL Monitor.
The information you have provided here is insightful for us and we're actively researching about how we can improve users address performance issues.
Out of interest, how often is this an issue for you?
Elena Lockyer – Product Designer, SQL Monitor