Checking an MSSQL

[Price, David]

Ian,

You can check SQL performace counters using NSClient's custom check.  For
example, I have the following lines in my config:

# Service definition
define service{
        use                    generic-service         ; Name of service
template to use

        host_name              c1sql2
        service_description    SQL User Connections
        is_volatile            0
        check_period           24x7
        max_check_attempts     3
        normal_check_interval  5
        retry_check_interval   1
        contact_groups         admins
        notification_interval  120
        notification_period    workhours
        notification_options   c,r
        check_command          check_nt_custom!"\\SQLServer:General
Statistics\\User Connections"!"User Connections: %.f"
        }

Hope this helps

David Price
 
 -----Original Message-----
From: Ian Farr [mailto:ianf at Oceanwide.com] 
Sent: Monday, May 12, 2003 9:48 AM
To: Nagios Users List (E-mail)
Subject: [Nagios-users] Checking an MSSQL

Hello all,

I would like to check an MS SQL 2000 database, and was wanting to know if
there are any people out there doing this already.

I know I can check the NT service with NSClient, but I wanted to do
something a little more than that to make sure that the SQL service is
indeed accepting requests and processing them.

My idea was to have an ODBC connection from the nagios box to the MS SQL box
and process the following:

1 - read data from a table
2- write new data to a table
3 - read the new data from a table to make sure that it worked
4 - delete data from the table
5 - read the table again to make sure that the data is gone.

any ideas if something like this exists before I go down the road of trying
to create my own script with unix ODBC and all that???

Thanks for the help..
____________________ 
Ian Farr 
Director of Network Infrastructure 
Oceanwide.com 
514-289-9090 ext 234 


-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com

_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null