Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Our daily checks involve checking all servers in our network for conectivity. At present we manually log on to each server and their instance to check.

Is there a tool that will automaticaly check all servers and their instances on the network or can an sql script be coded to do this?

Thanks Andy

share|improve this question
add comment

3 Answers

Take a look at ServersAlive. It's worked well for me in the past at monitoring a big range of services.

share|improve this answer
    
I've been using ServersAlive for a couple of years now. Keep in mind that the native SQL task doesn't work well against newer (SQL 2008+) versions of SQL Server. But you can run a SQL Script using SQLCMD easily enough. The upside is that you can start the services is they are down as well. –  mrdenny Sep 7 '10 at 8:26
add comment

Nagios is a well-liked monitoring system, and it comes with plugins for many aspects to monitor - eg memory, network, CPU, servers, etc.

There's one for SQL Server too:

Use the plugin "check_mssql_health" to monitor MS SQL Servers. Unlike other plugins, it not only checks for a successful connection, but gets > 20 useful metrics

share|improve this answer
add comment

If you have enterprise needs, Microsoft's SCOM will monitor availability and performance for SQL Server - and loads of other Microsoft/Wintel products as well. It's competitively priced. Other monitoring solutions are available from the likes of BMC, HP etc

At a budget level, Idera's admin tool kit comes with a SQL Server ping function that will run every x minutes from the system tray - it's USD 295 per install. http://www.idera.com/Products/SQL-toolbox/SQL-admin-toolset/

Finally, why not try to script one yourself - a dedicated SQL Box, running SQL jobs to query other SQL Server's availability - and using database mail if there's a problem.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.