Forum Discussion
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
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
