Feature Request: Search and Mass Clear

BrandonGalderisi · March 2, 2011 12:09PM

I would like the ability to search alerts and then mass clear.

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.

priyasinha · March 3, 2011 4:55AM

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

BrandonGalderisi · March 4, 2011 10:54AM

By host, I mean host connecting to the SQL Server, not the server itself.

priyasinha · March 4, 2011 11:56AM

Hi Brandon,

Apologies, but not sure I understand what you are refering to? Could you explain it bit more please?

Thanks,
Priya

BrandonGalderisi · March 7, 2011 4:04PM

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.

priyasinha · March 8, 2011 5:15AM

Hi Brandon,

Thanks for explaining. For your reference, I am tracking it as SRP-3615.

Thanks,
Priya

Feature Request: Search and Mass Clear

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk