Module: check_mk
Branch: master
Commit: d871473e520a11982d941e1700c8fd626ac6f1a3
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=d871473e520a11…
Author: Lars Michelsen <lm(a)mathias-kettner.de>
Date: Fri Jun 22 10:20:34 2012 +0200
Added pnp template for mssql tablespaces check
---
pnp-templates/check_mk-mssql_tablespaces.php | 53 ++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/pnp-templates/check_mk-mssql_tablespaces.php b/pnp-templates/check_mk-mssql_tablespaces.php
new file mode 100644
index 0000000..457d271
--- /dev/null
+++ b/pnp-templates/check_mk-mssql_tablespaces.php
@@ -0,0 +1,53 @@
+<?php
+# +------------------------------------------------------------------+
+# | ____ _ _ __ __ _ __ |
+# | / ___| |__ ___ ___| | __ | \/ | |/ / |
+# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / |
+# | | |___| | | | __/ (__| < | | | | . \ |
+# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ |
+# | |
+# | Copyright Mathias Kettner 2012 mk(a)mathias-kettner.de |
+# +------------------------------------------------------------------+
+#
+# This file is part of Check_MK.
+# The official homepage is at http://mathias-kettner.de/check_mk.
+#
+# check_mk is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation in version 2. check_mk is distributed
+# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with-
+# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A
+# PARTICULAR PURPOSE. See the GNU General Public License for more de-
+# ails. You should have received a copy of the GNU General Public
+# License along with GNU Make; see the file COPYING. If not, write
+# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
+# Boston, MA 02110-1301 USA.
+
+$title = str_replace("_", " ", $servicedesc);
+
+$opt[1] = "--vertical-label 'Bytes' -l0 --title \"$title\" ";
+#
+$def[1] = "DEF:size=$RRDFILE[1]:$DS[1]:MAX " ;
+$def[1] .= "DEF:unallocated=$RRDFILE[2]:$DS[1]:MAX " ;
+$def[1] .= "DEF:data=$RRDFILE[4]:$DS[1]:MAX " ;
+$def[1] .= "DEF:indexes=$RRDFILE[5]:$DS[1]:MAX " ;
+$def[1] .= "DEF:unused=$RRDFILE[6]:$DS[1]:MAX " ;
+
+$def[1] .= "AREA:size#f7f7f7:\"Size \" " ;
+$def[1] .= "GPRINT:size:LAST:\"%4.2lf%sB\" ";
+
+$def[1] .= "AREA:data#80c0ff:\"Data \" " ;
+$def[1] .= "LINE:data#6080c0:\"\" " ;
+$def[1] .= "GPRINT:data:LAST:\"%4.2lf%sB\" ";
+
+$def[1] .= "AREA:indexes#00ff80:\"Indexes\":STACK " ;
+$def[1] .= "GPRINT:indexes:LAST:\"%4.2lf%sB\\n\" ";
+
+$def[1] .= "AREA:unused#f0b000:\"Unused\":STACK " ;
+$def[1] .= "GPRINT:unused:LAST:\"%4.2lf%sB\" ";
+
+$def[1] .= "AREA:unallocated#dfdfdf:\"Unallocated\":STACK " ;
+$def[1] .= "GPRINT:unallocated:LAST:\"%4.2lf%sB\\n\" ";
+
+
+?>
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.