Report Portal
Welcome, Guest
Username: Password: Remember me
Please post here just questions about MDX Studio. All other questions will be moved to "Analysis Services Forum".

TOPIC: Perfmon counter always 0

Perfmon counter always 0 7 years 3 months ago #1098

  • lcascio
  • lcascio's Avatar
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

Thanks,
Lee
The administrator has disabled public write access.

Re: Perfmon counter always 0 7 years 3 months ago #1105

  • Anonymous
  • Anonymous's Avatar
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.

Thanks,
Lee
The administrator has disabled public write access.

Re: Perfmon counter always 0 7 years 3 months ago #1110

  • mosha
  • mosha's Avatar
For SSAS2008 the perfmon counters only work for the named instance. I will fix it for the default instance in the upcoming release.
The administrator has disabled public write access.

Re: Perfmon counter always 0 7 years 2 months ago #1166

  • lcascio
  • lcascio's Avatar
Works like a charm! Thanks Mosha!
The administrator has disabled public write access.

Re:Perfmon counter always 0 5 years 6 months ago #2118

  • FrankPl
  • FrankPl's Avatar
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.
The administrator has disabled public write access.

Re:Perfmon counter always 0 3 years 7 months ago #3081

  • EricLeBouffon
  • EricLeBouffon's Avatar
Using version 0.4.14.0 and I only see 0s even if logged in on the server as Administrator.

Any other suggestion?


Thanks
The administrator has disabled public write access.
Moderators: Vladimir, dgosbell

 

2007-2015 VidasSoft Systems Inc.