Forum Discussion
roopesh_shetty
Aug 06, 2019Copper Contributor
SQL Databases monitor
Hi
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
- CliveWatsonFormer Employee
For SQL in a Virtual Machine please see https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-databases-object?view=sql-server-2017You can then enable the desired ones in the Log analytics portal
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