SOLVED

Performance counter data for on Prem Analysis services is not populating

%3CLINGO-SUB%20id%3D%22lingo-sub-1041944%22%20slang%3D%22en-US%22%3EPerformance%20counter%20data%20for%20on%20Prem%20Analysis%20services%20is%20not%20populating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1041944%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20on%20prem%20Analysis%20services%20installed%20and%20the%20VM%20is%20connected%20to%20log%20analytics%20workspace%20to%20send%20perf%20data.%20I%20do%20have%20MSAS12%20perf%20counters%20available%20but%20these%20counters%20seems%20to%20be%20collecting%20data%20only%20for%20older%20versions%20of%20Analysis%20Services%20and%20not%20the%20lates.%20For%20eg%3A%20MS%20Analysis%20Services%202017.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20idea%20how%20I%20can%20pull%20perf%20counters%20of%20Analysis%20services%202017%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1041944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072097%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20counter%20data%20for%20on%20Prem%20Analysis%20services%20is%20not%20populating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072097%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F474917%22%20target%3D%22_blank%22%3E%40Harshal114%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20issue%20is%20similar%20to%20this%20one%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-Log-Analytics%2FSQL-cluster-performance-counters%2Fm-p%2F882432%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-Log-Analytics%2FSQL-cluster-performance-counters%2Fm-p%2F882432%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EPerformance%20counters%20for%20SQL%20Analysis%20services%20are%20different%20based%20on%20the%20version%20and%20instance%20name.%20As%20described%20in%20the%20answer%20from%20the%20link%20you%20have%20to%20either%20add%20each%20counter%20for%20each%20version%20in%20your%20data%20source%20perf%20counters%20configuration%20in%20Log%20Analytics%20or%20you%20can%20use%20wild%20cards%20(*).%20For%20example%3A%20MSAS*%3AMemory(*)%5CMemory%20Limit%20High%20KB%20.%20That%20should%20allow%20gather%20the%20counter%20no%20matter%20what%20is%20the%20version.%20In%20case%20you%20have%20named%20instance%20that%20counter%20should%20look%20like%20this%3A%20MSOLAP%24*%3AMemory(*)%5CMemory%20Limit%20High%20KB%20in%20order%20to%20get%20that%20counter%20no%20matter%20the%20instance%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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 data only for older versions of Analysis Services and not the lates. For eg: MS Analysis Services 2017.

 

Any idea how I can pull perf counters of Analysis services 2017? 

1 Reply
best response confirmed by Stanislav Zhelyazkov (MVP)
Solution

Hi@Harshal114 

Your issue is similar to this one:

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

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.