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