Feature Request: Search and Mass Clear

BrandonGalderisiBrandonGalderisi Posts: 22
edited March 8, 2011 5:15AM in SQL Monitor Previous Versions
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.

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
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.