Ad Widget

Collapse

64-bit Windows Server 2003 + 32-bit MS SQL Server 2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • phoeneous
    Member
    • Nov 2010
    • 32

    #1

    64-bit Windows Server 2003 + 32-bit MS SQL Server 2005

    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:

    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
    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.
    Last edited by phoeneous; 24-11-2010, 00:22.
  • phoeneous
    Member
    • Nov 2010
    • 32

    #2
    Bump. Anyone?

    Comment

    Working...