title: MSSQL: Access Index Usage
agents: windows
catalog: app/mssql
license: GPLv2
distribution: check_mk
description:
 This check monitors the Access_Methods counters of a Microsoft SQL Server
 instance from the mssql_counters agent section.

 It reports the full scans per second, the index searches per second, the
 resulting index searches per full scan and the index hit ratio in percent.
 Levels for the full scans, the index searches and the index hit ratio can
 be configured individually via the rule "MSSQL index usage". Setting a
 value to "No levels" disables the corresponding thresholds while the
 metric is still reported.

item:
 The name of the MSSQL instance.

discovery:
 One service is created for each instance that provides the Access_Methods
 counters full_scans/sec and index_searches/sec.
