question

yasserMohamedAbdelMoneim-0269 avatar image
0 Votes"
yasserMohamedAbdelMoneim-0269 asked Monalla-MSFT edited

SQL Query Monitoring

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

azure-monitor
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalla-MSFT avatar image
0 Votes"
Monalla-MSFT answered Monalla-MSFT edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.