Check manual page of mssql_counters.cache_hits
MSSQL cache hit ratio
This check monitors the cache hit ratio counters as reported by
the MSSQL server.
The check has been developed with MSSQL Server 2008 R2 but should
work with other versions too.
This check needs the Check_MK mssql.vbs -plugin installed in
the agent. Please refer to the online documentation
for how to install that plugin.
The MSSQL instance name, counter name and object name (like the tablespace
name) are used for the item.
One separate check for each available cache hit counter will be created.
This might be dedicated to tablespaces but also MSSQL server internal parts
like the "Buffer Manager".