Forum Discussion
Getting SQL query performance into log analytics
PatrikHansson Were you able to find a way to get this to work? I'm facing the same challenge right now
Hi, no i didn't get anywere.
I know there is a private preview for azure monitor targeting server workloads but I haven't applied since iv ben on vacation and don't have the time to make a participation meaningful atm.
https://twitter.com/AzureMonitor/status/1281250644481806336?s=20
Hi all , im not entire sure what is the performance counter you need, but you can try something like this.
go to the log analytics, -> Advance (In the settings like image below) :
then choose :
Then I think you just need to add something like this :
You can also add the performance counter of your choice.
You need to check what is the perfomance counter you need.
Hope this helps.
A least for me there isn't a perf counter for what I wanted. It needs to run a query inside sql and send the output to log analytics.
Scott_KinghornMicrosoft
PatrikHansson I am working on the SQL monitoring preview you saw in the tweet. We are calling DMVs to get the sql monitoring data. Currently we don't return a lot of details on query perf stats in the preview version. Is there a DMV that you would like to use for this? For example, sys.dm_exec_query_stats.
