Applications Systems

Discover AppInsight for SQL on clusters needs VIP

AppInsight for SQL does not discover on nodes as expected due to VIP and DNS requirements.

First published date

11/13/2018 2:37 AM

Last published date

12/1/2022 1:54 PM

Overview

To successfully discover AppInsight for SQL on clusters, SAM must be communicating with the virtual IP (VIP), not the cluster member IP. When running discovery, SAM uses DNS resolving to verify the IP for the cluster. If the DNS resolving fails during discovery, AppInsight for SQL will not be discovered on the node for the cluster even if the provided IP is the VIP.

If this occurs, you can still manually create the application, assigning the AppInsight for SQL template to the node, and continuing with polling normally. This limitation only is required for discovery. The check is performed strictly during discovery, not polling.

Product section

Server Application Monitor

Resolution

If you encounter an issue with discovery, you can manually add the node and AppInsight for SQL template to the node for monitoring.

Make sure to provide the VIP for a cluster for discovery to correctly locate and monitor AppInsight for SQL on a node. This is strictly required for a DNS resolving check to ensure SAM is communicating with the VIP.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.