Hello everybody!
I'm managing Zabbix 7.0.17 (both server and client) for a customer and recenlty I'm testing Agent2 with MSSQL plugin (downloaded from here).
On the first testing machine most item works as intended but a couple aren't.
My issues are on "Active Transactions", "Data file size", "Log file size", "Log file used size" and "Transactions per second" and the error on all them is "no data matches the specified path".
Digging further on every dependency item, I'v found that "Get performance counters" isn't retrieving that values. Here's the content of my Performance Counters item:
Code:
[{
"cntr_value": 0,
"counter_name": "Cursor deletes/sec",
"instance_name": "MSSQLSERVER",
"object_name": "SQL Server 2017 XTP Cursors"
}, {
... output omitted ...
}, {
"cntr_value": 531082,
"counter_name": "Uptime",
"instance_name": "",
"object_name": "SQLServer"
}, {
"cntr_value": 0,
"counter_name": "Version",
"instance_name": "Microsoft SQL Server 2019 (RTM-CU32) (KB5054833) - 15.0.4430.1 (X64) \n\tFeb 21 2025 17:28:26 \n\tCopyright (C) 2019 Microsoft Corporation\n\tStandard Edition (64-bit) on Windows Server 2019 Standard 10.0 \u003cX64\u003e (Build 17763: ) (Hypervisor)\n",
"object_name": "SQLServer"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB1",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB2",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB3",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB4",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB5",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB6",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DB...",
"object_name": "SQLServer:Databases"
}, {
"cntr_value": 0,
"counter_name": "State",
"instance_name": "DBN",
"object_name": "SQLServer:Databases"
}]
As additional informations, maybe useless:
- I've created a new template with the "MSSQL by Zabbix agent 2" inside, than disabled some item/discoveries/triggers.
- All macros are the default one except {$MSSQL.USER}, {$MSSQL.PASSWORD} and {$MSSQL.URI} (as "sqlserver://127.0.0.1:1433/" since I'm working on the default instance), those 3 are set on mine template to prevent edits on original one.
- The "DB State" state is working as intended.
- The grant given to the user are the 6
Can't figure why the item contains data but not everything was planned to. Thought about permission but i guess the wwhole raw item would failt if it's something like that.
Agent log doesn't show anything useful:
Code:
2025/07/30 11:49:28.527874 Starting Zabbix Agent 2 (7.0.17) 2025/07/30 11:49:28.532516 OpenSSL library (OpenSSL 3.4.1 11 Feb 2025) initialized 2025/07/30 11:49:28.532516 using configuration file: C:\Program Files\Zabbix Agent 2\zabbix_agent2.conf 2025/07/30 11:49:28.533049 using plugin 'Agent' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.533049 using plugin 'Ceph' (built-in) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537347 using plugin 'Cpu' (built-in) providing following interfaces: exporter, runner, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537347 using plugin 'DNS' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537347 using plugin 'File' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537347 using plugin 'Log' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537863 using plugin 'MQTT' (built-in) providing following interfaces: watcher, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537863 using plugin 'MSSQL' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mssql.exe) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Memcached' (built-in) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Memory' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Modbus' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Mysql' (built-in) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'NetIf' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Oracle' (built-in) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Proc' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Redis' (built-in) providing following interfaces: exporter, runner, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Registry' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Smart' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Sw' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Swap' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'SystemRun' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'TCP' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'UDP' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Uname' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Uptime' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Users' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'VFSDir' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'VMemory' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'VfsFs' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WebCertificate' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WebPage' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WindowsEventlog' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WindowsPerfInstance' (built-in) providing following interfaces: exporter, maximum capacity: 1, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WindowsPerfMon' (built-in) providing following interfaces: exporter, runner, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'WindowsServices' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'Wmi' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'ZabbixAsync' (built-in) providing following interfaces: exporter, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.537894 using plugin 'ZabbixStats' (built-in) providing following interfaces: exporter, configurator, maximum capacity: 1000, active checks on start enabled: false 2025/07/30 11:49:28.538405 using plugin 'ZabbixSync' (built-in) providing following interfaces: exporter, maximum capacity: 1, active checks on start enabled: false 2025/07/30 11:49:29.747204 Plugin communication protocol version is 6.4.0 2025/07/30 11:49:29.747204 Zabbix Agent2 hostname: [xxxxx.yyyy.tt] 2025/07/30 11:50:35.249779 [MSSQL] Creating new connection to "sqlserver://127.0.0.1:1433/", with user "monitor" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version "" zz0.qv61zsnjp9zz
Thanks in advance