Counter Initialization Failed

Mar 31, 2009 at 6:28 PM
I have multiple servers running Windows 2003 R2 SP 2 x64 with SQL 2005 x64 SP 3 with Cummulative Update 1.  When SQLH2 Performance Collector service starts it reports the following in the application event log.

Source SQLH2 PerfCollector, Event ID: 31
Can't initialize counter SERVERNAME SQLSERVER:DATABASES:DATA FILE(S) SIZE (KB:_TOTAL  Category does not Exist.

I can open this counter on the remote server in PerfMon running on my collector

I then get EventID 104
SERVERNAME SQLSERVER:DATABASES:DATA FILE(S) SIZE (KB):TOTAL switches into after ailing to initialize.

The following is from my H2PerfConfigFile.XML
<PERFCOUNTER Object="SQLServer:Databases" Counter="Data File(s) Size (KB)" Instance="_Total" />

This also happens for the Transactions/Sec counter

Any help would be greatly appreciated.