MSSQL services of a Windows MSSQL device are in stale. Can't able to get back to normal

Troubleshooting
, , ,
1

CMK version: 2.3.0p41
OS version: Debian 11

Error message: MSSQL services of a Windows MSSQL device are in stale. We have tried to install the agent after installing also, the MSSQL plugin can’t able to get the data and it still looks the same. We have also checked from the server end, every MSSQL services are running fine but it is showing stale in checkmk alone. We have also tried on changing the monitoring responsiveness to Ultra slow. The response time also is high which is above 60s.

Kindly assist with this issue.

image
image352×598 73.7 KB

Thanks & Regards,
Surendran S

**
**

2

Hi,

the MSSQL Plugin is usually quite demanding and slow.

To help with this configure your agent via check_mk.user.yml to increase the cache_age for this Plugin. And set async plugin execution if disabled.

Also increase the checkinterval for this host.

As last resort, you can increase the global check timeout. This works OOB with Enterprise, or via Config for Nagios.

Best Regards