Page 1 of 1

SQL Server 32 bit counters on Windows Server 2008 R2

Posted: Tue Jan 08, 2013 2:40 am
by SSFFU
Good morning,
we are experiencing problems in collecting SQL Server 2005 32bit DB Dimensions, the error we receive is

CRIT: Counter not found: \SQLServer:Database(tempdb)\Dimensioni file di dati (KB): Impossibile trovare nel sistema loggetto specificato. (C0000BB8)

SQL Server 2005 Standard is a 32bit platform, installed on a Windows Server 2008 R2 (then 64bit platform)
It seems that the 32bit SQL counter cannot be read by a 64bit OS platform.

Anyone else experienced this problem?
Is there a way to collect these datas?

Our Nagios environment is Passive.

Thanks in Advance.
F.

Re: SQL Server 32 bit counters on Windows Server 2008 R2

Posted: Tue Jan 08, 2013 10:46 am
by yancy
Good morning,

Are you able to get the performance counter information via powershell using Get-counter?

What data are you trying to collect from MSSQL? You may also be able to use WMI and send the data back to Nagios.


Thanks,

-Yancy