Page History
...
IDERA SQL Inventory Manager connects frequently to managed SQL Server instances to ensure they are available and responsive. If the SQL Server instance becomes unreachable for any reason, an alert will be raised to let operators know that an availability problem may have arisen.
...
First, attempt to connect to the SQL Server instance by means other than IDERA SQL Inventory Manager. If the connection fails, take note of any error message, which may in some cases explain what the issue is. If the message is not helpful or if the connection simply times out, verify whether the host Windows server is available through a ping test or by attempting to connect via remote desktop. If the server is not responsive, it may be necessary to troubleshoot further to determine whether it is a network issue or whether the server is itself offline or unresponsive. When the server is verified to be back online and reachable, check to make sure that the SQL Server services are started for any and all hosted SQL Server instances.
...
If the server is online and this message appears to be in error , it could be that network or security issues are preventing IDERA SQL Inventory Manager from making a connection. Ensure that IDERA SQL Inventory Manager is connecting to the SQL Server with credentials that have the right to connect to the target server.
| Excerpt |
|---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...
Update Health Check
The SQL Server is down health check alerts you when a server is down for more than 30 seconds. You can change this threshold by modifying the value for down time.
Please note that this change applies to all monitored servers. After making any change, alerts are not displayed until the new thresholds met or exceed the selected value.
To configure a health check, in the Administration view, click Manage Health Checks, and then click Configure for the appropriate health check. In this case, IDERA SQL Inventory Manager displays the Update Health Checks - SQL Server is down window.
Make the appropriate changes, and then click Save.
| Info | ||
|---|---|---|
| ||
For more information about the Health Checks performed by IDERA SQL Inventory Manager, go to What Health Checks are available with SQL Inventory Manager? |
...