SQL Server 32 bit counters on Windows Server 2008 R2

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
SSFFU
Posts: 8
Joined: Fri Sep 02, 2011 2:50 am

SQL Server 32 bit counters on Windows Server 2008 R2

Post 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.
yancy
Posts: 523
Joined: Thu Oct 06, 2011 10:12 am

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

Post 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
Locked