AppInsight for SQL

jjhj

SolarWinds version: Hybrid Cloud Observability Advanced Enterprise Scale: 2024.1.0

We need to monitor multiple instances of SQL Server, but the monitoring result is not the same, below I list my instances to monitor, could you tell me if there is any restriction with the following versions:

1.-	MSSQLSERVER	12.0.6449	SP3	Enterprise Edition: Core-based Licensing (64-bit)
2.-	MSSQLSERVER	12.0.6449	SP3	Enterprise Edition: Core-based Licensing (64-bit)

In general the SQL Versions are: SQL Server 2014 Service Pack 3 (SP3).

The monitoring result for both servers is different:

1.- 

Status	QTY
Critical	1
Disabled	6
Unknown	49
Up	422
Warning	1

2.- 

Status	QTY
Critical	1
Disabled	127
Down	49
Unknown	29
Unplugged / Offline	24
Up	84

Credentials used for monitoring requirements include:

• Administrator permission at the host level
• Be a member of the db_datareader role in the msdb database
• VIEW SERVER STATE permissions
• VIEW ANY DEFINITION permissions
• Connect permission to all databases, including Master and msdb
• Execute permission on the Xp_readerrorlog stored procedure

Could anyone offer some technical perspective on what might be happening?

 

mesverrum

I'm not entirely sure what the table you are presenting is supposed to be saying, is that the statuses of the components under each instance?  You should not expect them to be the same unless they were just mirrors of each other, the appinsight template builds the relevant components based on the setup of your SQL instance.