title: MSSQL: WorkFiles and WorkTables
agents: windows
catalog: app/mssql
license: GPLv2
distribution: check_mk
description:
 This check monitors the Access_Methods counters for temporary work files
 and work tables of a Microsoft SQL Server instance from the mssql_counters
 agent section.

 It reports the created work files per second and the created work tables
 per second. Levels for both values can be configured individually via the
 rule "MSSQL work files and tables". 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 workfiles_created/sec and worktables_created/sec.
