SQL Databases monitor



We have a requirement to monitor the number of transactions per second on SQL Databases on hosted on azure servers? Can this be done using Log Analytics Workspace? If yes what Windows Performance Counters we need to enable in data collections of log analytics workspace? Please advice.

1 Reply


For SQL in a Virtual Machine please see https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-databases-o...


You can then enable the desired ones in the Log analytics portal

Annotation 2019-08-06 091758.png


You should also look at Azure Metrics - in case any of those options are relevant https://docs.microsoft.com/en-gb/azure/azure-monitor/platform/metrics-getting-started