Share via

KQL to monitor Sql Server Performance for Azure SQLVM

Rahul 276 Reputation points
2023-01-06T13:07:58.863+00:00

All,

I'm looking KQL query to monitor SQL Server performance for Azure SQLVm using Log analytics workspace.

Thanks.

SQL Server on Azure Virtual Machines
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,885 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,321 questions
0 comments
Accepted answer
  1. Andrew Blumhardt 9,601 Reputation points Microsoft Employee
    2023-01-06T13:40:50.26+00:00

    I would start with VM Insights, review the default workbooks, and possibly add some alert rules. Azure platform metrics are collected by default and are free. You can add additional OS metrics if needed using log analytics.

    https://learn.microsoft.com/en-us/azure/azure-monitor/vm/vminsights-performance

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest