Monitoring SQL Server and SSAS i Log analytics

Julie Mohr 1 Reputation point
2020-08-28T10:58:56.833+00:00

Hi,

I am trying to make a monitoring dashboard with Log Analytics. I have seen many tutorials for writing KQL queries using the table Perf in Log Analytics. But how do I turn on the logging of this data from my SQL server and SSAS server?

Br Julie

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,803 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SwathiDhanwada-MSFT 17,401 Reputation points
    2020-08-31T09:11:48.747+00:00

    @Julie Mohr Here are few documents that will help you in monitoring SQL server and SSAS.

    SQL Server

    SSAS

    Also please note that Perf table contains the logs of Virtual Machines, Virtual Machine Scale Sets and Kubernetes Services. For more information on each of the tables based on resource type , you can refer this document.