Forum Discussion

Harshal114's avatar
Harshal114
Former Employee
Dec 02, 2019
Solved

Performance counter data for on Prem Analysis services is not populating

I have on prem Analysis services installed and the VM is connected to log analytics workspace to send perf data. I do have MSAS12 perf counters available but these counters seems to be collecting dat...
  • HiHarshal114 

    Your issue is similar to this one:

    https://techcommunity.microsoft.com/t5/Azure-Log-Analytics/SQL-cluster-performance-counters/m-p/882432

    Performance counters for SQL Analysis services are different based on the version and instance name. As described in the answer from the link you have to either add each counter for each version in your data source perf counters configuration in Log Analytics or you can use wild cards (*). For example: MSAS*:Memory(*)\Memory Limit High KB . That should allow gather the counter no matter what is the version. In case you have named instance that counter should look like this: MSOLAP$*:Memory(*)\Memory Limit High KB in order to get that counter no matter the instance name.