topic Re: SQL server undetected in data explorer in Open Q&A

SQL server undetected in data explorer

leonatay — Tue, 20 Sep 2022 07:37:48 GMT

Hi community

I configured 9 SQL server monitoring configurations for MSSQL.

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.

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

Re: SQL server undetected in data explorer

david_lopes — Tue, 20 Sep 2022 17:04:05 GMT

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.

Re: SQL server undetected in data explorer

leonatay — Wed, 21 Sep 2022 01:27:35 GMT

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

Re: SQL server undetected in data explorer

david_lopes — Wed, 21 Sep 2022 02:22:36 GMT

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

Re: SQL server undetected in data explorer

leonatay — Wed, 21 Sep 2022 08:40:49 GMT

Thanks David