Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Server & Application Monitor (SAM) > Appinsight for SQL: Monitors in Unknown state

Appinsight for SQL: Monitors in Unknown state

Created by Chris Foley, last modified by MindTouch on Jun 23, 2016

Views: 63 Votes: 2 Revisions: 4

Overview

This article provides brief information and steps to resolve the issue when some components of AppInsight for SQL appear to be  in unknown state: 

  • Performance Counter Monitors
  • Windows Service Monitors
  • Windows Event Log Monitor

Environment

  • SAM version 6.0 or later
  • All versions of Windows

 

Cause 

The error can occur when any of the following happens to AppInsight for SQL Template:

  • Manually assigned to a Node using a polling method of SNMP.
  • The Application is given a SQL Account instead of a Windows account.  As a result, SAM has no Windows account to use to perform RPC or WMI queries.

Resolution

Use any of the following workarounds:

 

  1. Instead of manually assigning the Appinsight for SQL Template to the Node, discover it via the Node's "List Resources" interface. This method will detect that no Windows Authentication is available and automatically disable the Monitors mentioned above.

 

  1. Give the Appinsight for SQL a Windows account with Admin rights to the system hosting the SQL Server installation.

 

  1. Manually assign the Appinsight for SQL Template to the Node, however, edit the settings for the resulting Application and disable the above-mentioned Component.  Note: At the time of this writing, the Windows Event Log Monitor does not have an option to disable it.

 

 

 

 

Last modified
02:45, 23 Jun 2016

Tags

Classifications

Public