I dont Know

%3CLINGO-SUB%20id%3D%22lingo-sub-1816437%22%20slang%3D%22en-US%22%3EI%20dont%20Know%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816437%22%20slang%3D%22en-US%22%3ESubject%20%3A%20Log%20analytics%20workspace%20-%20add%20CPU%20%2B%20Memory%20usage%20per%20each%20query%20on%20analysis%3CBR%20%2F%3EHello%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3Emy%20goal%20is%20to%20retrieve%20from%20log%20analytics%20all%20queries%20being%20fired%20against%20analysis%20server.%3CBR%20%2F%3E%3CBR%20%2F%3Eso%20that%20is%20being%20done%20with%20the%20following%20rows%20below.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBUT%20my%20question%20is%20-%20how%20can%20i%20add%20per%20each%20query%20that%20is%20being%20fired%20-%20it's%20CPU%20and%20memory%20usage%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20advise.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1924604%22%20slang%3D%22en-US%22%3ERe%3A%20I%20dont%20Know%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1924604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845234%22%20target%3D%22_blank%22%3E%40Nishad2215%3C%2FA%3E%26nbsp%3B%20Is%20there%20a%20use%20case%2Fscenario%20on%20this%3F%20or%20do%20you%20have%20a%20query%20that%20you%20can%20reference%3F%20the%20question%20is%20a%20bit%20vague%20so%20it's%20tricky%20to%20provide%20any%20assistance.%20Are%20you%20looking%20for%20a%20way%20to%20fire%20up%20a%20notification%20each%20time%20an%20alert%20is%20triggered%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014082%22%20slang%3D%22en-US%22%3ERe%3A%20I%20dont%20Know%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014082%22%20slang%3D%22en-US%22%3EI%20think%20you'd%20need%20to%20use%20Event%20Hub%20to%20capture%20the%20queries%20you%20want%20then%20store%20them%20in%20a%20data%20store%20(i.e.%20Azure%20Blob%20Storage).%3CBR%20%2F%3E%3CBR%20%2F%3ELog%20Analytics%20won't%20be%20able%20to%20tell%20you%20what%20queries%20have%20been%20run%20on%20the%20DB%2C%20that's%20why%20you%20need%20to%20use%20Event%20Hub%20to%20capture%20these%20queries.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps!%3C%2FLINGO-BODY%3E
Occasional Visitor
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.

2 Replies

@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?

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!