Monitoring MS SQL 2000

[bytesize]

Hi,

Does anyone currently monitor Microsoft SQL Server 2000 using Zabbix?

If so, could you post a few of the items you use or local checks if thats what the agent needs?

Thanks in advance!

John

[erisan500]

here ya go:

perf_counter[\SQLServer:Buffer Manager()\Database pages]
perf_counter[\SQLServer:Buffer Manager()\Free pages]
perf_counter[\SQLServer:_Databases(DATABASENAME)\Data File(s) Size (KB)]
perf_counter[\SQLServer:_Databases(DATABASENAME)\Log File(s) Size (KB)]
perf_counter[\SQLServer:General Statistics()\User Connections]
perf_counter[\SQLServer:Memory Manager()\Total Server Memory (KB)]

Remove the _ (underscore) before Database. Needed to do this otherwise you would see :D.


no further explanation needed....or do you?

EriSan

[bytesize]

Thanks EriSan, thats done the trick!!!

[bytesize]

Hmm, Zabbix doesn't seem to like this entry:

perf_counter[\SQLServer:Memory Manager()\Total Server Memory (KB)]

When I add this as an item, Zabbix only ever inserts this into the database:

perf_counter[\SQLServer:Memory Manager()\Total Server Memory (KB

Any ideas why this might be?

Thanks!

John

[erisan500]

This is caused by the database design.
To solve this problem you need to increase the "Key" field in the "Items" table from "Varchar(64)" to "Varchar(128)".

Greetings EriSan