[Nagiosplug-help] monitor mssql service

[Thomas Guyot-Sionnest]

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

Oops, I sent an old version of it. Please use this one :)

Thomas

On 10/10/07 11:22 AM, Thomas Guyot-Sionnest wrote:
> 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

iD8DBQFHDQMq6dZ+Kt5BchYRAisLAKCAS9HvTI8ugfR1i8og7kFBRptzUwCfRElY
4NWFpwTCv78FmD6tUilvkgw=
=b36b
-----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/02db109b/attachment.ksh>