Why is all my analysis performance counter(MSAS 2008) always show no data

Question

i run my app on win 2008 and sql server 2008 , both of them are x64, and when i add all the msas2008 performance counters in monitor, there 's no data. the line is always flat.
can anyone tell me why? thanks !!

Answer 1

Hi Kevin,

Did you see any errors in the Application log?
Are all of the SSAS the Performance Monitor counters zero?
If not which counters are zero?


Regards,
Orsi

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

all of my ssas counter shows no data.
the processing went very well, with no error.

Answer 3

nobody come across this problem?? this is quite common, i got this problem in my win7 x32, two of my win2008 x64.

Answer 4

and by the way, when i choose the msas 2008 counter, the instance selection box is gray, showing me no instances, does it matter?
when i click 'ok', the instance column of listing counters is all '--'. i dont know why, other counters have this column fill

Answer 5

The following article has quite a lot of detail on troubleshooting Perf Counter issues
http://blogs.msdn.com/psssql/archive/2009/03/03/troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 6

still no luck. the article is too complicated.
darren, have you ever try the msas 2008 counter in vista or above, my installation is all standard, and without any error. so it should n't be wrong. maybe these counters never work in vista/win2008

Answer 7

i follow that article and do some of the steps which give me more detail in event log, and i found some error here:
The open procedure for service "WmiApRpl" in DLL
"C:\WINDOWS\System32\wbem\wmiaprpl.dll" has taken longer than the
established wait time to complete. There may be a problem with this
extensible counter or the service it is collecting data from or the system
may have been very busy when this call was attempted.

the error detail xml is :

< Event xmlns =" http://schemas.microsoft.com/win/2004/08/events/event " >

- < System >

  < Provider Name =" Microsoft-Windows-Perflib " Guid =" {13B197BD-7CEE-4B4E-8DD0-59314CE374CE} " EventSourceName =" Perflib " />

  < EventID Qualifiers =" 32768 " > 2002 </ EventID >

  < Version > 0 </ Version >

  < Level > 2 </ Level >

  < Task > 0 </ Task >

  < Opcode > 0 </ Opcode >

  < Keywords > 0x80000000000000 </ Keywords >

  < TimeCreated SystemTime =" 2009-11-06T08:22:20.000Z " />

  < EventRecordID > 307665 </ EventRecordID >

  < Correlation />

  < Execution ProcessID =" 0 " ThreadID =" 0 " />

  < Channel > Application </ Channel >

  < Computer >Test </ Computer >

  < Security />

  </ System >

- < UserData >

- < EventXML xmlns:auto-ns2 =" http://schemas.microsoft.com/win/2004/08/events " xmlns =" Perflib " >

  < param1 > WmiApRpl </ param1 >

  < param2 > C:\Windows\system32\wbem\wmiaprpl.dll </ param2 >

  </ EventXML >

  </ UserData >

  </ Event >

Answer 8

I don't know if that dll has anything to do with the SSAS counters or not.

If you are running in Vista, what account is the SSAS service running under? I think you will find that if it is running as "Network Service" that this account does not have enough rights to update the performance counters. If this is just a local dev instance, try running as "LocalSystem".

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 9

Yeah!!!! Darren, that is the problem, i change the running account type from network service to local system, and all the counters are working normally!!
thanks for solving the big problem, i 've kept searching for the answer for like a month already!!

related link:http://www.imkevinyang.com/2009/11/%E6%9D%83%E9%99%90%E5%AF%BC%E8%87%B4%E7%9A%84analysis%E6%80%A7%E8%83%BD%E8%AE%A1%E6%95%B0%E5%99%A8%E5%9C%A8vistawin2008%E4%B8%8B%E5%A4%B1%E6%95%88%E7%9A%84%E9%97%AE%E9%A2%98.html