First the details:
Check_mk raw 1.5.0p21
Windows Server 2016
SQL Server 2016
Using the mssql.vbs plugin
We occasionally get the following errors for all the databases on our sql server:
UNKN - Item not found in agent output
This will occur maybe once every couple of days (cannot find a pattern) and last for anything from 5 minutes to a half hour before reporting Ok.
I have seen online that this could relate to the server being under pressure and the agent not being able to report, however there don’t appear to be any performance issues with the server that I can find.
A workaround I have seen is to edit the check_mk.ini file and set the execution of the plugin to asynchronous and increase the cache_age. I have done this (current cache_age 300) but it doesn’t seem to have solved the issue. I have just doubled the cache_age to 600 to see what happens. It is the only plugin we have running.
Does anyone have any thoughts on what the issue coud be?