Hello
I have SCOM 2019 , i want to monitor the SQL queries which consume more than 50% of my processor usage and 40% from RAM usage.
Is it doable in SCOM?
Thanks
Hello
I have SCOM 2019 , i want to monitor the SQL queries which consume more than 50% of my processor usage and 40% from RAM usage.
Is it doable in SCOM?
Thanks
Hello @yasserMohamedAbdelMoneim-0269 - Thanks for reaching out.
To find the Query resource consumption , we may need to run another SQL to query multiple dmvs and get an output , if we can do that from SCOM then that should be fine . I don't think SCOM allows to run a SQL query in a specific DB
Or as an whole monitoring process , We can invoke the same query in all available database from PowerShell. And Azure SQL DB has inbuilt metrics which can be viewed from portal , So setting this up is an additional task.
Also PAAS servers has their in-built metrics which gets generated automatically with the help of (query store)
Please take a look at this doc for more reference : Monitoring-your-servers-and-databases-scom-and-sql-monitor
Also this doc - Query-Performance-Insight-Use
Hope this helps.
If the above response helped, please feel free to "Accept as Answer" so it can beneficial to the community.
9 people are following this question.