I have three MS SQL Servers, 2016. 1 source and two destinations.
There is a linked server setup from each destination server to the source.
We execute a simple select query from each destination server to the source server using OPENQUERY.
The query from destination 1 returns in 1 minute while the query from destination 2 returns in 7 minutes.
All the servers are in different data centers and we have checked the network, and we have not found any issues. What else can we check?
