Search found 3 matches

by jhagedorn
Thu Oct 17, 2013 1:01 pm
Forum: Open Source Nagios Projects
Topic: Nagios & SQL 2013 Monitoring
Replies: 5
Views: 3306

Re: Nagios & SQL 2013 Monitoring

Im going to modify this to pass 3 parameters HostName/Instance/AvailabityGroup... Ill update it, when I get it working.. LOL Unless someone was to do my task.. :)
by jhagedorn
Wed Oct 16, 2013 11:20 am
Forum: Open Source Nagios Projects
Topic: Nagios & SQL 2013 Monitoring
Replies: 5
Views: 3306

Re: Nagios & SQL 2013 Monitoring

It is not FULLY documented.. But if you have setup remote powershell scripts, it should be ok.. There are other PSSQL commands.. :) http://technet.microsoft.com/en-us/libr ... 78391.aspx
by jhagedorn
Wed Oct 16, 2013 11:11 am
Forum: Open Source Nagios Projects
Topic: Nagios & SQL 2013 Monitoring
Replies: 5
Views: 3306

Nagios & SQL 2013 Monitoring

This might help out anyone tring to monitor "SQL 2013 Always-On".. :) Setup Nagios to call local command: sqlps -Command "&{C:\Scripts\AvailableGroupStatus.ps1}" Replace "SERVERNAME" with your SQL ServerName Replace "SQLINSTANCE" with your SQL InstanceName...