This should be in the product. I don't want to filter to all LRQ alerts; I want to find how many times a particular proc has raised this alert so searching by proc name would be most helpful.

Since this has been a suggestion since 2012 and you have been looking into it since 2016, is there any chance you are going to add this feature?

I'm finding that functionality like this would be very useful - any update on this?

Much needed

Maybe it could be enough with a new alertsGridTemplateNew?

Add a new view setting for the alert inbox where the user can choose to add event fields that would be present for such an event in the profiler.

Or alternatively.

Add a view mode that shows, database, user and application for each event.

I would expand this to the ability to filter the Job failed alert by Name/Description keywords and/or Category.

I would document the name of the application, database, process, table, and if I see the reason for the problem such as a missing commit.

This is the information I would try to filter on.

I could see some people would try to filter base on a ticket number so they could quickly lookup the issue associated with the work ticket.

Hi,

Would you be able to describe your setup in more detail as I'm not fully understanding the issue? Is it not possible to filter the alert using the process name that appears on the details page of the long-running query alerts?

Thanks
Chris (Test Engineer, Red Gate Software)

I also would like to be filter for 'Exclude queries with a SQL Process' by entering something like [2007 Microsoft Office system]. We have several processes that always generate long running queries that we can't do anything about due to it being an attached table.

Thanks for your suggestion Kevin.

I enter a comment about an alert such as the process that caused the alert.
Examples:
“Blocking alert caused by Process1”
“Deadlock alert caused by Process1”
“Processor utilization alert caused by Process1”

Later I need to look up all the problems this process has caused. I would like to filter alerts based on text in comments to find all alerts caused by that process.
Example: “Process1”
Would return the 3 alerts above.

Hi Kenny,

Thanks for the suggestion. I've raised this enhancement as SRP-5842. We'd like to improve the alert filtering so we'll certainly consider this.

Thanks
Adam

It would be a nice addition to alerts if it would be possible to add more filtering options to the alert overview. Process, DBname and User(s) would be nice additions to be able to filter on.