Setting up MS SQL and Service Groups

[syed.raza]

Hi,

I am using NRPE on Nagios 4.1.1 for Ubuntu 14.04 LTS and have set up hosts and host groups picking up services.

I'm looking for guides on how to setup more detailed information on MS SQL at the moment I'm only monitoring the SQL Services.
I would like to also set up Service Groups as at the moment I am getting There are no service groups defined.

I am a basic user as I have only used ubuntu and nagios for 3 days so as much information as possible please.
Host Groups are windows-server, sql-servers and linux-servers.

I have 4 servers running SQL 2008 R2 Standard.

Thanks

[lmiltchev]

I'm looking for guides on how to setup more detailed information on MS SQL at the moment I'm only monitoring the SQL Services.

What services are you currently monitoring? Do you know what else you would like to monitor? There are plenty of plugins on the Nagios Exchange. You may be able to find something that will do the job for you.

I would like to also set up Service Groups as at the moment I am getting There are no service groups defined.

Please, review our documentation on how to define servicegroups in nagios here:
https://assets.nagios.com/downloads/nag ... rvicegroup

[syed.raza]

Hi I am currently monitoring the following:


C:\ Drive Space
OK 10-02-2015 08:55:42 1d 22h 44m 18s 1/3 c: - total: 97.65 Gb - used: 61.78 Gb (63%) - free 35.87 Gb (37%)
CPU Load
OK 10-02-2015 08:56:56 1d 22h 43m 3s 1/3 CPU Load 2% (5 min average)
D:\ Drive Space
OK 10-02-2015 08:58:25 1d 22h 41m 47s 1/3 d: - total: 174.78 Gb - used: 91.06 Gb (52%) - free 83.72 Gb (48%)
E:\ Drive Space
OK 10-02-2015 09:02:05 1d 20h 46m 32s 1/3 e: - total: 12.00 Gb - used: 6.09 Gb (51%) - free 5.91 Gb (49%)
Memory Usage
OK 10-02-2015 09:03:19 1d 22h 39m 16s 1/3 Memory usage: total:55293.78 MB - used: 13680.75 MB (25%) - free: 41613.03 MB (75%)
NSClient++ Version
OK 10-02-2015 09:02:06 1d 22h 38m 1s 1/3 NSClient++ 0.4.3.143 2015-04-29
PING
OK 10-02-2015 09:03:21 1d 22h 36m 45s 1/3 PING OK - Packet loss = 0%, RTA = 1.51 ms
SQL Server - PRACTICE
OK 10-02-2015 08:59:42 0d 16h 54m 7s 1/3 MSSQL$PRACTICE: Started
SQL Server Agent - IRISPRACTICE
OK 10-02-2015 09:00:49 0d 16h 53m 1s 1/3 SQLAgent$PRACTICE: Started
SQL Server VSS Writer
OK 10-02-2015 09:03:02 0d 16h 50m 49s 1/3 SQLWriter: Started
Uptime

I am having a hard time understanding the nagios exchange plugins or the guide from nagios as the commands go over my head slightly - I do apologise for this.

[lmiltchev]

I am having a hard time understanding the nagios exchange plugins or the guide from nagios as the commands go over my head slightly - I do apologise for this.

Using Nagios Core could be challenging - there is a steep learning curve. I you could afford it, I would recommend using Nagios XI instead. It would be a lot easier for you to set it up/configure checks simply by running monitoring wizards.

If this is not an option for you, try learning the nagios basics. Here's a link to the Nagios Core documentation:

https://assets.nagios.com/downloads/nag ... n/toc.html

In regards to the plugins on the Nagios Exchange, most of them have a "help"/usage flag. It is usually "-h" or "--help". So, you can view the usage of the plugin by running from the command line:

Code: Select all

/path/to/your/plugins/<plugin name> -h

or

Code: Select all

/path/to/your/plugins/<plugin name> --help

In general, you will need to do the following:

1. Download the plugin to the plugins directory.
2. View the usage from the command line and test your plugin. Make sure it works from the command line.
3. Create a command and a service.
4. Make sure that it works in the GUI.

Let us know if you need help with setting up a specific check.

[syed.raza]

I would like to set up the following:

https://exchange.nagios.org/directory/P ... ts/details
https://exchange.nagios.org/directory/P ... ck/details (in hourly view)
https://exchange.nagios.org/directory/P ... er/details
https://exchange.nagios.org/directory/P ... ck/details

I know I'm asking for a lot but I'm really enjoying Nagios and getting to understand Linux.

Thanks

[tmcdonald]

That definitely is quite a list.

Normally explaining how to set up a plugin would be pretty straight-forward, but if you have little/no Linux experience then what would typically be a paragraph explanation will turn into a few pages. If you have specific issues you are running into we can help, but walking through the setup step-by-step when there are already plenty of great guides written is treading on consulting/training territory.

Have you read the link that lmiltchev posted? Specifically we have a section on how to monitor some popular public services:

https://assets.nagios.com/downloads/nag ... vices.html

That section should be fairly adaptable to your own plugins. And speaking of plugins, they are explained here:

https://assets.nagios.com/downloads/nag ... ugins.html

I would give those docs a good read-through or two, and if you still have specific questions we would be happy to help.