[Nagiosplug-help] monitor mssql service

[Thomas Guyot-Sionnest]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/10/07 08:44 AM, Hollick Matthew - ICT Systems wrote:
> Hi there,
>  
> A lot of monitoring of MSSQL can be achieved through performance
> counters, you may already have a selection of performance counters being
> monitored for OS performance. You will need a nagios agent installed on
> the server like ns_client, nsclient++, nc_net to collect these counters.
> Beyond these counters you may wish to consider the following counters:
>  
> \System\Processor Queue Length
> \System\Threads
> \System\Context Switches/sec
> \Memory\Pages/sec
> \Paging File(_Total)\% Usage
> \PhysicalDisk(_Total)\Avg. Disk Queue Length    
>  
> \SQLServer:General Statistics\User Connections
> \SQLServer:Locks(_Total)\Lock Waits/sec
> \SQLServer:Locks(_Total)\Lock Wait Time (ms)
> \SQLServer:Databases(_Total)\Log Growths
> \SQLServer:Databases(_Total)\Percent Log Used
> \SQLServer:Databases(_Total)\Transactions/sec
> \SQLServer:Memory Manager\Memory Grants Pending
> \SQLServer:Latches\Latch Waits/sec
>  
> You may well need to adjust the counters to allow for multiple MSSQL
> instances and databases. Disk queue should probably be monitored on a
> per device level too.
>  
> Setting sensible values for warning and critical levels can be hit and
> miss. For each of the counters I set up a cron job to run a
> check_nt pull of the data at 5 minute intervals into a rrd database.
> This gave me nice graphical data to make a first guess on where to peg
> the warning and critical levels.
>  
> Going forward you may wish to install FreeDTS and sqsh on your nagios
> server. A small amount of scripting effort will reward you with a plugin
> which can query tables/views and run stored procedures.
> Microsoft provides extensive details on interesting views and stored
> procedures.
>  

Hi there,

For the script you originally talked about you can get it from the
source tarball of Nagios-plugins. It's not installed by default so you
will have to copy it from contrib/ to the actual path for your Nagios
plugins (usually /usr/local/nagios/libexec/).

If you're interested I also wrote a Perl plugin myself (attached). It
requires FreeTDS (like the bash script in /contrib) and also the
following Perl modules:

Nagios::Plugin
DBD::Sybase
Time::HiRes

I'll either get included in the official Nagios-plugins distribution ir
upload it on Nagiosexchange...

PS: Is you want a fast answer please cc tguyot at gmail.com - I'm out of
town and X-Forwarding is slow as hell :)

Thomas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHDO4E6dZ+Kt5BchYRAqB6AJ9TUJa5Y0XXhekltvxOGRrw3zTOpwCglJYb
vqfClJFih9bzFzi5Bq30Sy0=
=3t+x
-----END PGP SIGNATURE-----
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: check_mssql
URL: <https://www.monitoring-plugins.org/archive/help/attachments/20071010/0824e1e8/attachment.ksh>