DX Unified Infrastructure Management

Hello Guys,

I would like to ask your help.

We are monitoring a Windows Server 2012 server and the SQL Server application and everything is correct,
data are being collected, stored, and displayed in USM on UMP.

However, data from SQLServer is not being displayed, only data from other probes like cdm, ntservices, etc.

Figure 1: USM of Server, without SQL Server metrics.

Figure 2: Probes deployed on Server, with SQLServer.

Figure 3: Data from SQLServer probe on Performance Reports

I already deployed the sqlserver probe again,deleted the USM item via CSKEY,
cleaned the NIS Cache from the monitoring agent, etc and none of these actions
presented results.

Could someone help with this case?

ump version 8.20
hub version 7.70
discovery_server version 8.20
discovery_agent version 8.41
robot version 7.80
sqlserver version 5.10

Regards,
Jean Gomes

Hello Rowan,

I can search for the hostname of the server and it is Okay

And everything looks okay with the data server exibition.

Data from cdm, ntservices, ntevl is on xpto.domain (profile name) and data from SQLSERVER is on xpto (profile name) 

I know it is different, but it is this way on every server with sqlserver and everything is okay wiht USM.

Rowan,

The profile name showed in PRD is the hostname of the server, but in sqlserver probe where I could change the profile name?

For example, in sqlserver probe we configure the name of connection, server name (for connection), but none of these are the hostname of the server.

I think the profile name (PRD) is got automatically by probe sqlserver with dns or something by Server Name (that we use IP, Port)

Rowan,

I already tried the following actions:

Deploy again of probe sqlserver with new configuration

Update of the robot

nis_cache clean and reset device id of robot

Delete cskey from USM and discovery again

Finally, I tried the following method:

execute the query: UPDATE S_QOS_DATA SET ci_metric_id = NULL

deactive data_engine, nis_server, discovery_server and active again in the same order.

Unfortunately, none worked.

Rowan,

For example, we have the same scenario for another servers and everything is Okay.

Names differents on PRD 

But eveything is okay on USM

Agree FQDN name will not this issue , can you check whether Dev_Id and met_id is getting populated for sqlserver probe in Dr.nimbus .

Isaac08,

Yes, the probe of sqlserver is sending met_id and dev_id on QOS_MESSAGE subject

Jean -  Please raise a support ticket and proceed further ..You also tried almost all steps.

Isaac08,

I cannot, it is because we are using CAIUM 8.20 version (out-of-support version)

Thanks for your support/help.

I will keep trying. 

Have a look on the below .

UMP - No metrics available displayed for many nodes 

Missing Robots and/or Robot metrics in Unified Service Manager (USM) 

Do you have update_metric_id = yes in data engine ,pls confirm ?

data_engine Troubleshooting - CA Unified Infrastructure Management Probes - CA Technologies Documentation 

Issac08, 

No, data_engine does not have a update_metric_id = yes on RAW configuration.

Could I add this value on CAUIM 8.20 version?

I think that this value is for CAUIM 8.4, right?

I have applied this on 8.5.1 which has fixed , can someone from UIM team can confirm this .

Use of the data_engine setting 'update_metric_id' is valid for UIM 8.4 or higher.