Ad Widget

Collapse

ODBC stats items delay (not executing as suppose)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pcyran94
    Junior Member
    • Feb 2023
    • 7

    #1

    ODBC stats items delay (not executing as suppose)

    Hello everyone.

    I have a problem with ODBC monitoring of MSSQL and racle DBs.

    Normally, in template are general items like "Get stats", that execute complex query every minute and there are plenty dependent items that obtain specific values
    And in theory it works and should give update every 1 minute, however I observe weird thing. I'v discovered that hosts connected thrugh different proxy servers executes in different interval. Every host has the same (default) template attached.

    Hosts that are connected to:
    PROXY2 - report every ~1min
    PROXY1 - report every ~30min
    PROXY3 - report every 4,5-8h!

    Click image for larger version  Name:	MicrosoftTeams-image (1) (1).png Views:	21 Size:	172.2 KB ID:	465934

    I'm totally lost with this. Where start to debug this correlation between Proxy server and this delay? There are no timeouts on items etc.

    Zabbix server version: 6.4.1
    Zabbix proxies version: 6.4.1
    Deafult, newest Zabbix templates: MSSQL by ODBC and Oracle by ODBC.

    Last edited by pcyran94; 15-06-2023, 09:09.
  • pcyran94
    Junior Member
    • Feb 2023
    • 7

    #2
    Please, any help on this issue?

    Comment

    Working...