Filter alerts based on contents of comment
I enter a comment about an alert such as the process that caused the alert.
“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.
Would return the 3 alerts above.
Interesting suggestion! Would the comment always contain a cause, or are there other kinds of information that you’d want to search for in your comments?
Kevin Frazier commented
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.
Thanks for your suggestion Kevin.