Hello everyone, for some time I am trying to setup multi-instance monitoring by using template MSSQL by Zabbix agent 2 and I would like to know is it possible to have MSSQL Plugin run and be active with multiple agents?
Unfortunately my environment does not support/allow using Zabbix passive checks and I must utilize Zabbix active checks so I am left with two options:
Over engineer one single template by using named instances, one large discovery rule, complex script or maybe adjust plugin -- I want to avoid this option
Install additional agent for every named instance present on the server
Example of my environment:
Windows server 2019 and 2022
Not all servers have same number of named instances, some have 2 some 4
Passive checks are not allowed
I am exploring an option where I would have multiple agents installed on one host, each agent points to its own separate zabbix_agent2.conf and in config file for "secondary" agents I am adding a different Hostname, ControlSocket, updated paths, etc.
My problem is I cannot have two Zabbix Agent 2 services running at the same time when MSSQL plugin is enabled through mssql.conf file. When I comment line Plugins.MSSQL.System.Path= both Zabbix Agent 2 services are operational.
The way I set this up was, I created a copy of existing Zabbix Agent 2 installation folder and renamed it, then using following command I created secondary service:
Sadly I cannot figure out why both Zabbix Agent 2 services won't run when MSSQL Plugin is enabled, I have tried increasing DebugLevel to 5, checked Event Logs and even Process Monitor, I am not getting anything why second service will not start.
Is it a limitation of MSSQL plugin that it can work with only one Zabbix service even though each agent has its own exe for MSSQL Plugin?
Any help or ideas with this are appreciated, if anyone needs details about how I did something feel free to ask.
Thanks,
Milos
Unfortunately my environment does not support/allow using Zabbix passive checks and I must utilize Zabbix active checks so I am left with two options:
Over engineer one single template by using named instances, one large discovery rule, complex script or maybe adjust plugin -- I want to avoid this option
Install additional agent for every named instance present on the server
Example of my environment:
Windows server 2019 and 2022
Not all servers have same number of named instances, some have 2 some 4
Passive checks are not allowed
I am exploring an option where I would have multiple agents installed on one host, each agent points to its own separate zabbix_agent2.conf and in config file for "secondary" agents I am adding a different Hostname, ControlSocket, updated paths, etc.
My problem is I cannot have two Zabbix Agent 2 services running at the same time when MSSQL plugin is enabled through mssql.conf file. When I comment line Plugins.MSSQL.System.Path= both Zabbix Agent 2 services are operational.
The way I set this up was, I created a copy of existing Zabbix Agent 2 installation folder and renamed it, then using following command I created secondary service:
Code:
zabbix_agent2.exe --install --config "C:\Program Files\Zabbix Agent 2-DbInstance1\zabbix_agent2.conf" --multiple-agents
Is it a limitation of MSSQL plugin that it can work with only one Zabbix service even though each agent has its own exe for MSSQL Plugin?
Any help or ideas with this are appreciated, if anyone needs details about how I did something feel free to ask.
Thanks,
Milos