No Servers Connected, yet I have SQL data
I installed the agent on a single server 24hours ago and I am still waiting for it to show in the Connected Servers area. However, i do have data/recommendations for the SQL Server Assessment pack.
Is it likely that there is something wrong, or should I continue to wait?
Hi Dan — if you are getting data for the server from the SQL Server Assessment IP, then this means data is flowing correctly.
I am currently seeing the “Servers Connected Directly” tile take several seconds to update with data — is your tile also slow to update? You can also run the following query to confirm if data is coming from the agent:
- | Measure Max(TimeGenerated) as LastData by Computer | Sort Computer
Closing as there has not been any activity for almost 4 weeks. Let us know if you still need help with this.
Dan Kellett commented
I just found this blog that helps troubleshoot connectivity issues, I will follow this and report back>