Activity overview
Latest activity by matt_rushton
Hi Alex, I can see how that would work but I don't want to change the global severity filter down to 16 because as you say, it would over capture and alert on too many errors. More specifically, I'd like instruction as to how to set up a custom metric that uses Extended Events to only capture the error number in question. By using Extended Events I could turn the XE off when I'm finished with my investigation without touching SQL Mon. All the Redgate tutorials I've found seem focused on capturing performance metrics and not errors and I'm an old Trace guy with next to no experience using XEs yet so I'm coming at this new to both Extended Events and SQL Mon. / comments
Hi Alex,I can see how that would work but I don't want to change the global severity filter down to 16 because as you say, it would over capture and alert on too many errors.More specifically, I'd ...
Capturing bespoke SQL Errors
I note that SQL Mon can enable Traces to capture events on either side of an alert. I also note that by default SQL Mon alerts on any SQL Error that hits the log which is severity > 20. How do I ...
Agent Job Filter not working?
When filtering SQL Agent Jobs by Category, I only want to see my Business Process Jobs. I have them categorised separately from my Database Maintenance Ones. Selecting the Category as shown below d...
Global Alert Filter out DBs
Just getting started with Monitor. Initially overwhelmed with alerts but many are nonsense such as no backup on the Model DB. Want to start removing these so I can focus on legitimate alerts.Is ...