Forum Discussion
PatrikHansson
Apr 01, 2020Brass Contributor
Getting SQL query performance into log analytics
Hi
Is it possible to get query performance from SQL Server (On an Azure VM) into Log analytics ?
Would like to be able to see top 10 longest running, most logical reads etc.
Can't find a hint on how to be able to do that. Any ideas ?
- CliveWatson
Microsoft
Have you tried adding some SQL Perf counters?
https://techcommunity.microsoft.com/t5/azure-log-analytics/sql-cluster-performance-counters/m-p/882432#M2017- PatrikHanssonBrass Contributor
Yea, but I'm not sure how perf counters are going to be able to give me a list of which queries are using most cpu.
I'm coming from the SCOM side of monitoring an there i would probably been able to write my own ManagementPack to run on the agent on the sql server and get the data from T-SQL but with azure monitor/Log analytics I'm at a loss on how to do it.