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?

  • 2
    Hi and welcome to dba.se. You could add the actual execution plan to pastetheplan.com That way we can have some more insight as to what you are dealing with. – Randi Vertongen Jul 22 '19 at 18:46
  • Hi, Are both destination server databases using the same database compatibility mode? IE 130 (SQL Server 2016). I have found great differences with certain queries between the 2, and if one is in SQL 2008, its using the older cardinality estimator, creating very different query plans which can result in very different query execution times. – WadeH Jul 22 '19 at 20:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.