The Server Ping tool helps you monitor the status of SQL Server instances across your enterprise by routinely pinging specified instances. You can run Server Ping as centralized interface or as system tray service alerts you when instance goes offline or becomes unhealthy.
How the Server Ping tool works
By default, Server Ping connects to the specified SQL Server instances using the credentials of your currently logged on Windows account.
Server Ping then uses either a WMI or SQL query to collect information such as whether the SQL Server services are running or when an instance comes online or goes offline.
Server Ping allows you to:
- Monitor a SQL Server instance or a server group
- Run the tool in the system tray to:
- Use status icons to quickly ascertain whether a server is online
- Use pop-up alerts to monitor when instances come online or go offline
- Launch tool when the Windows operating system starts
- Refresh data automatically at specified intervals
- Avoid unnecessary alerts by selecting which instances should be ignored during maintenance periods
- Choose WMI or a SQL query to collect health information
Use the Server Ping tool
To use the Server Ping tool:
- Open the IDERA SQL Admin Toolset Launchpad, and then click Server Ping.
- Specify the SQL Server instance or server group that contains the logins whose passwords you want to check. Use the following steps to specify more than one instance:
- Click Add.
- On the Add Server window, type the name of each instance, separating multiple instances with semicolons.
- Specify the type of authentication you want Server Ping to use to connect to the specified instances. By default, the credentials of your current Windows account are used.
- To verify that the connection settings are valid for the specified instances, click Test Connection.
- Indicate whether you want to receive overall status information or alerts and notifications about the specified instance.
- Click OK.
- Select the appropriate system tray options.
- Choose whether you to run a WMI or SQL query to retrieve the status of the specified instances. You can specify which SQL command you want to run in the query.
- Click Check Servers Now.