Analysis Services 2008 Performance Counters showing zero

[Darren Gosbell]

I had an issue recently with my SSAS 2008 performance counters - they were all showing up as 0. I could see them listed in Performance Monitor, but none of them worked. The counters for my SSAS 2005 instance worked fine, but the 2008 ones did not.

I had observed this behaviour on my old Vista x86 machine and now it was happening on a fresh install of Windows 7 x64.

I tried numerous steps to troubleshoot this issue including going through this detailed blog post from the CSS SQL Server Engineers blog, but I still could not fix this issue.

It was actually a forum post about issues someone was having with IIS counters that put me onto the right track. Apparently you can have issues with performance counters due to the permissions of the account that the service is running under.

I was running my SSAS 2008 service as Network Service, changing it to run as LocalSystem fixed my issue and now my SSAS 2008 performance counters are working.

I'm sure that this could also be fixed by manipulating the permissions of the files under
"\Microsoft SQL Server\MSAS10\OLAP\bin\Counters"
but for the time being this solution is sufficient for my needs. :)

Technorati Tags: Analysis Services,Performance Counters





Get More from the original blog...