Forum Discussion

Nishad2215's avatar
Nishad2215
Copper Contributor
Oct 25, 2020

I dont Know

Subject : Log analytics workspace - add CPU + Memory usage per each query on analysis
Hello ,

my goal is to retrieve from log analytics all queries being fired against analysis server.

so that is being done with the following rows below.



BUT my question is - how can i add per each query that is being fired - it's CPU and memory usage ?

Please advise.

  • MawandaH's avatar
    MawandaH
    Brass Contributor
    Nov 23, 2020

    Nishad2215  Is there a use case/scenario on this? or do you have a query that you can reference? the question is a bit vague so it's tricky to provide any assistance. Are you looking for a way to fire up a notification each time an alert is triggered?

  • HusseinAwad's avatar
    HusseinAwad
    Copper Contributor
    Dec 24, 2020

    I think you'd need to enable the diagnostic settings for your DB. This will allow you to see different queries and their processing time!

    Log Analytics won't be able to tell you what queries have been run on the DB.

    Hope this helps!

Share