Forum Discussion
Getting SQL query performance into log analytics
Hi, thanks for taking the time to answer.
I'v activated the SQL health check but it doesn't seem to collect what i'm looking for.
And the auditing is for security related if i remember correctly. And for that i would have to collect the whole Application event log.
So im still hunting for a solution 🙂
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.
