Post reply

SQL Server and Nagios

  • August 17, 2009 at 10:26 am

    #224905

    Does anyone here using Nagios to monitor SQL ?

    I know a plugin needs to be installed on the Linux server, does anyone know what the plugin is.

    Also, how to you call stored procedures from Nagios ?

  • August 18, 2009 at 6:59 am

    #1040807

    You may try this one ....

    http://chrisdickey.info/blog/?p=10

    hth,

    Thanks,

    Haque

  • August 18, 2009 at 3:51 pm

    #1041205

    I am using Nagios to monitor our SQL Server, while it may not be comparable to the many paid products out there, it certainly does the job.

    You will need check_nt plugin, and NSClient++ on the machine you monitor.

    You can monitor processes, services, CPU over x time, and memory. If you want to dig deeper, you can use WMI and check if the DB is online, DB Log size, and DB Size; all this can also be graphed so that you can see a trend on how your DBs are growing.

    You should look at the Nagis Mailing List Archive, there has been lots of examples and discussion on SQL Server 2005 monitoring.

    Thanks.

  • February 11, 2011 at 1:32 pm

    #1285890

    To monitore SQL Server, you can use plugin check_mssql_health : http://www.xoowiki.com/Article/Shell/nagioscentreon-check_mssql_health-498.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply