I've linked the Template_Microsoft_SQLServer_2005 template to my only ms sql server 05 box which is running 64-bit Windows Server 2003 and 32-bit MS SQL Server 2005. Immediately I started receiving "Some items are not supported" notification alerts. I checked the zabbix_server logs and came across this:
I ran perfmon on the sql server and checked the names of the counters. Of the 9 items listed above, "\Process(sqlservr#1)\%Processor Time" is the only counter available in perfmon. Upon further investigation, I discovered that it is because I'm running a 32-bit version of MS SQL Server 05 on 64-bit Windows Server 2003. When I run MMC /32 PERFMON.MSC , I am able to see all the SQL Server counters so I know they are active. I am still getting the same errors above, not sure where to go next.
Code:
2429:20101123:092150.348 Item [SQLSERVER:perf_counter["\Process(sqlservr#1)\%Processor Time"]] error: Not supported by Zabbix Agent 2428:20101123:092152.362 Item [SQLSERVER:perf_counter["\SQLServer:Buffer Manager\Database pages"]] error: Not supported by Zabbix Agent 2429:20101123:092153.365 Item [SQLSERVER:perf_counter["\SQLServer:Databases(_Total)\Data File(s) Size (KB)"]] error: Not supported by Zabbix Agent 2429:20101123:092154.382 Item [SQLSERVER:perf_counter["\SQLServer:Databases(_Total)\Log File(s) Size (KB)"]] error: Not supported by Zabbix Agent 2428:20101123:092155.392 Item [SQLSERVER:perf_counter["\SQLServer:Databases(_Total)\Transactions/sec"]] error: Not supported by Zabbix Agent 2426:20101123:092156.396 Item [SQLSERVER:perf_counter["\SQLServer:General Statistics\User Connections"]] error: Not supported by Zabbix Agent 2430:20101123:092157.404 Item [SQLSERVER:perf_counter["\SQLServer:Locks(_Total)\Lock Waits/sec"]] error: Not supported by Zabbix Agent 2429:20101123:092158.406 Item [SQLSERVER:perf_counter["\SQLServer:Locks(_Total)\Number of Deadlocks/sec"]] error: Not supported by Zabbix Agent 2426:20101123:092159.415 Item [SQLSERVER:perf_counter["\SQLServer:Memory Manager\Total Server Memory (KB)"]] error: Not supported by Zabbix Agent
Comment