How to monitor MS SQL server


#1

Hello,

I am so sorry I used “search button” and Mr. Google also but I was not able to find how to monitor MS SQL server.
and probably I am doing something wrong but I don’t know where.

I need to check MS SQLserver with name for example Jupiter, with instance merkur and database is for example Test.

I am using check_nt plugin.

Can anyone please help m with this issue? I am starting to be little bit mad :frowning:

Thank you


#2

I monitor MS SQL from RHEL5 using NSClient++ on the Windows servers and check_nrpe on the Nagios box. Create services using check_npre CheckServiceState CheckAll to check for all automatically started services. If you want performance data using counters, use CheckCounter and check any PERFMON counter you want.