Nagios and SQL databases

[Hendrik "Boomer" Baecker]

Paul Bourgeau schrieb:

>I tried to search, but I did not see anything dealing with exactlly what I needed.  I know that you are able to monitor TCP ports, services and drive utilization, but I wanted to know how (if at all) to set up Nagios to monitor SQL databases themselves.  I am currently watching the SQL server services (mssql), but that's it.
>
>Can you monitor each individual database(size of, activity, health, etc..)?
>  
>
Yes. There exist a Nagios Plugin called "check_mssql.sh" --> 
http://www.nagios.org/faqs/viewfaq.php?faq_id=156

>Can you monitor who accesses the databases, number of users?
>  
>
Long time ago since I've played with it but I think with a little bit of 
work you can do whatever you want with.

Hope this helps.

>I'm guessing that I just need to add entries to the checkcommand.cfg file with SQL OID's, right?  Or is there a bit more to setup?  
>
>I am running ver 1.2 on redhat 8 (2.4.18-19.8.0)  Any help would be appreciated.
>
>Thanks,
>Paul
>
>Disclaimer: 9/2/2005
>
>MPC Computers is providing the following information in compliance with federal regulations:
> 
>MPC Computers, LLC
>906 E. Karcher Road
>Nampa, Idaho 83687
>1-888-224-4247
>http://www.mpccorp.com
>
>To discontinue receiving e-mail communications from MPC in the future, please go to: 
>http://www.mpccorp.com/email/manage.html and follow the instructions.
>
>
>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now.
>http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
>_______________________________________________
>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
>
>
>  
>



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
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