Report Portal
× New user registration is disabled!
Please post here just questions about MDX Studio. All other questions will be moved to "Analysis Services Forum".

Perfmon counter always 0

8 years 1 month ago #1098 by lcascio
Awesome tool! The perfmon counters are always 0. I have the .10 release and will try the .11 but didn't notice this problem in the release notice. I'm running as an administrator so I don't think that is it. Any suggestions?

If not, I can get the perfmon counters the old fashioned way directly from perfmon, except I have one problem. How do you reset the counters? For example the cell by cell counter doesn't seem to change. Is there a way to zero it out between queries?

MS Server 2003 64 bit
SQL Server 2008 64 bit Cummulative Updates 1

  • Anonymous
  • Anonymous's Avatar
  • Visitor
  • Visitor
8 years 1 month ago #1105 by Anonymous
I just realized my second question overstepped the topic of this forum, please disregard.

Regarding the first one question, are there any ideas on how to get the performance counters to work in MDX Studio? This is a very useful feature I'd like to get it working. My performance counter window only shows the query duration, all the counters stay at 0. It looks like there is at least one more thread about the performance counters but no replies on it also. Is there anything I should check on the SSAS side regarding perfmon counter configuration?

Any help appreciated.

  • mosha
  • mosha's Avatar
  • Visitor
  • Visitor
8 years 1 month ago #1110 by mosha
For SSAS2008 the perfmon counters only work for the named instance. I will fix it for the default instance in the upcoming release.
8 years 2 weeks ago #1166 by lcascio
Works like a charm! Thanks Mosha!
  • FrankPl
  • FrankPl's Avatar
  • Visitor
  • Visitor
6 years 3 months ago #2118 by FrankPl
I always only saw zeroes when connecting from my computer to the AS server, but saw perfmon values when running MDX studio locally on the server (logged in as local administrator).
I then realized that my local user was not member of the "Performance Logs User Group" on the server.
After adding it to this group, all perfmon counters show up in MDX Studio on the client computer as well.
  • EricLeBouffon
  • EricLeBouffon's Avatar
  • Visitor
  • Visitor
4 years 4 months ago #3081 by EricLeBouffon
Using version and I only see 0s even if logged in on the server as Administrator.

Any other suggestion?

Moderators: Vladimirdgosbell


2007-2015 VidasSoft Systems Inc.