How to monitor and alert all long running SQL queries details for SQL Server Instance from SCOM2019

VIJAY KUMAR 1 Reputation point
2022-12-20T05:23:24.863+00:00

Hello SCOM experts,

I'm looking for a custom alerting to monitor and alert all top 10 long running SQL queries details for SQL Server Instance from SCOM2019 and send email notification. I tried using OLEDB MP and no luck. If any one has solution Please share your inputs.

thanks,
VK

System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.