Comments
5 comments
-
Hi Brandon,
Thanks for your post.
This feature is already present in SQL Monitor. You can follow the following steps:
1. Select host name "GREENSQL1" on the left hand navigation.
2. Create the filter for "Long running query" + Low priority using Advanced Filter option.
3. Now use Select > All option.
4. You would notice that a green bar appears at this stage with hyperline for "Select all alerts across all pages".
5. Use this option to select all alerts across all page and then perform any action such as "Read", "Cleared" etc.
Thanks,
Priya -
By host, I mean host connecting to the SQL Server, not the server itself.
-
Hi Brandon,
Apologies, but not sure I understand what you are refering to? Could you explain it bit more please?
Thanks,
Priya -
I know that I have a particular process that runs on a particular machine that trips the long running query alert. I would like to do a search of "all connections from the host name of......". If you look at an alert, it's the HOST value.
-
Hi Brandon,
Thanks for explaining. For your reference, I am tracking it as SRP-3615.
Thanks,
Priya
Add comment
Please sign in to leave a comment.
Example of Search Alerts:
All Low priority, long-running query, from host name GREENSQL1.
Example of Mass clear:
Under Select, along with "All", "None", "Read" and "Unread", I would like to see "Select All" which spans across pages.
The mass clear would be used in conjunction to mass clear long running queries from a particular host.