cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL server undetected in data explorer

leonatay
Observer

Hi community 

 

I configured 9 SQL server monitoring configurations for MSSQL.

leonatay_1-1663575403340.png

 

However, when trying to add into dashboard, only 2 out of the configurations were detected. This happens when split by "SQL server instances" and "device.name" were used. For split by "device" and "device.address" it returns 9 no problem.

leonatay_2-1663575444362.png

leonatay_3-1663575572892.png

 

Question: Why only 2 SQL server is detected when split by "SQL server instances" and "device.name" were used? it would be useful if device.name can return all 9 as it is more recognizable than ip address

 

Any help on this is much appreciated, thanks!

 

-Leona

4 REPLIES 4

david_lopes
Dynatrace Advisor
Dynatrace Advisor

Can you send a link to your environment to extensions@dynatrace.com? I would like to investigate what is going on here (it seems to me that the dimensions for instance and device name are not being sent for the other seven, but I would like to confirm it)

If you have already opened a ticket about it please also share that link with us.

Hi David, thank you so much for helping, already sent the link

 

 

david_lopes
Dynatrace Advisor
Dynatrace Advisor

This is fixed with Dynatrace Activegate version 1.251

For now the work around is to add the IP address and DNS information to the hosts file of the Activegates that are running the extension

Thanks David