Monitoring SQL Server and SSAS i Log analytics

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

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.
1,804 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-08-31T09:11:48.747+00:00
    Swathi Dhanwada 9,381 Reputation points Microsoft Employee

    @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.