Aug 06 2019
12:29 AM
- last edited on
Apr 07 2022
06:02 PM
by
TechCommunityAP
Aug 06 2019
12:29 AM
- last edited on
Apr 07 2022
06:02 PM
by
TechCommunityAP
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.
Aug 06 2019 01:26 AM
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
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