Module: check_mk
Branch: master
Commit: b5bf37e16fda16778f47f95e8399f7aada5e99c0
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=b5bf37e16fda16…
Author: Lars Michelsen <lm(a)mathias-kettner.de>
Date: Fri Jun 22 09:05:38 2012 +0200
Added missing mssql check manpages
---
checkman/mssql_counters.cache_hits | 31 +++++++++++++++++++++++++++++++
checkman/mssql_counters.file_sizes | 26 ++++++++++++++++++++++++++
checkman/mssql_counters.transactions | 26 ++++++++++++++++++++++++++
3 files changed, 83 insertions(+), 0 deletions(-)
diff --git a/checkman/mssql_counters.cache_hits b/checkman/mssql_counters.cache_hits
new file mode 100644
index 0000000..c1c192e
--- /dev/null
+++ b/checkman/mssql_counters.cache_hits
@@ -0,0 +1,31 @@
+title: Checks MSSQL cache hit ratio
+agents: windows
+author: Lars Michelsen <lm(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ 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.
+
+item:
+ The MSSQL instance name, counter name and object name (like the tablespace
+ name) are used for the item.
+
+perfdata:
+ One value(float): The percentage of queries which hit the cache.
+
+inventory:
+ 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".
+
+[parameters]
+warn_percent(int): Check will raise a warning state if ratio is below or equal this value.
+crit_percent(int): Check will raise a critical state if ratio is below or equal this value.
diff --git a/checkman/mssql_counters.file_sizes b/checkman/mssql_counters.file_sizes
new file mode 100644
index 0000000..b30fd15
--- /dev/null
+++ b/checkman/mssql_counters.file_sizes
@@ -0,0 +1,26 @@
+title: Checks size of data- and logfiles of MSSQL tablespaces
+agents: windows
+author: Lars Michelsen <lm(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check monitors the size of data- and logfiles of MSSQL
+ tablespaces as reported by MSSQL.
+
+ 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.
+
+item:
+ The MSSQL instance name and the tablespace name separated by a space.
+
+perfdata:
+ data_files(int): The total datafile size in bytes.
+ log_files(int): The total logfile size in bytes.
+ log_files_used(int): Currently used bytes in logfile.
+
+inventory:
+ One separate check for each tablespace will be created.
diff --git a/checkman/mssql_counters.transactions b/checkman/mssql_counters.transactions
new file mode 100644
index 0000000..779d702
--- /dev/null
+++ b/checkman/mssql_counters.transactions
@@ -0,0 +1,26 @@
+title: Checks transactions per second in MSSQL tablespaces
+agents: windows
+author: Lars Michelsen <lm(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check monitors the transactions, write transactions and
+ tracked transactions of MSSQL tablespaces.
+
+ 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.
+
+item:
+ The MSSQL instance name and the tablespace name separated by a space.
+
+perfdata:
+ transactions/sec(int): Number of transactions per second.
+ write_transactions/sec(int): Number of write transactions per second.
+ tracked_transactions/sec(int): Number of tracked transactions per second.
+
+inventory:
+ One separate check for each tablespace will be created.