search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
50 stars 27 forks source link

Discovery is not working if MS SQL is x86 and Win OS is x64 #11

Closed MantasTumenas closed 5 years ago

MantasTumenas commented 5 years ago

Discovery is not working if MS SQL is x86 and Win OS is x64

MantasTumenas commented 5 years ago

MS SQL instance name is selected from the registry (regedit) path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ If, MS SQL is x86 and Win OS is x64, then registry path is: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server. So, you need to update these files accordingly:

If you have a situation like Win OS x64, first SQL instance x64 and second instance x86 - you have to choose - which instance is more important for you. For now.

Will try to do a new discovery scripts

MantasTumenas commented 5 years ago

Also need to update a manual (deployment section).

MantasTumenas commented 5 years ago

Workaround is presented. Since MS SQL Server 2016 CTP 2.4. x86, or the 32-bit version, is no longer included. SQL Server 2016 is now 64-bit only. No need modify scripts for a problem which should fade away.