Need help configuring Long Running Query alert...
kmonroe@psecu.com
Posts: 8
Hey All...
I'm working through some alert configurations in SM and I have a SQL Server maintenance plan that is generating a lot of alerts for processor utilization, physical memory and long running queries on one of my servers.
This is a third party maintenance plan and we have accepted the run times of this process.
Right now I'm trying to configure SQL Monitor to ignore anything from this process but I'm unable to see the SQL process in the current alerts to add to the alert configuration to exclude.
Does anyone know how to exclude a SQL Server maintenance plan for at least the long running query alert?
Any help will be greatly appreciated.
Happy Holidays!!
Kevin
I'm working through some alert configurations in SM and I have a SQL Server maintenance plan that is generating a lot of alerts for processor utilization, physical memory and long running queries on one of my servers.
This is a third party maintenance plan and we have accepted the run times of this process.
Right now I'm trying to configure SQL Monitor to ignore anything from this process but I'm unable to see the SQL process in the current alerts to add to the alert configuration to exclude.
Does anyone know how to exclude a SQL Server maintenance plan for at least the long running query alert?
Any help will be greatly appreciated.
Happy Holidays!!
Kevin
Kevin Monroe
SQL Server DBA
SQL Server DBA
Comments
For example, to exclude any sql backup job, you can add the RegEx of "sqlbackup". This means that any job which uses the sqlbackup extended stored procedure in the script will not be alerted on.
I think I'm going to have to use Regular Expression to exclude the TSQL that the plan executes.
Any other ideas?
Regards!
Kevin
SQL Server DBA