CODEWITHSUNDEEP
sql-servert-sqlsql-server-2008-r2
pritamS
pritamS

Reputation: 137

Linked server is slower in one server compared to other

I am trying to fetch data from two SQL Servers through linked servers. One is SQL 2014 Express and another is SQL 2008 Standard. But now the 2008 Standard edition is faster than 2014 Express edition.

They base server (from where I am trying to get data) is SQL 2008 R2 Standard.

Is there any reason for that? How to tune that?

Please reply.

Upvotes: 0

Views: 277

Answers (1)

Dan
Dan

Reputation: 10680

It's impossible to directly answer your questions, as there can be many reasons for this. Off the top of my head:

  • Are you using the same query to fetch the data from both servers? If so, are the query plans identical? What happens if you simply read all records from a table without any filters or joins?
  • Are the servers located on different parts of the network? (Firewall, load-balancer, etc.)
  • How are the databases on the remote servers configured? Multiple data files, etc.? Remember SQL Express has some limitations regarding number of cores in use, etc.
  • What are the specs of the remote servers? Does one have faster disks or more RAM than the other? Faster network interface? etc.
  • Are the servers busy with other tasks?
  • Are the servers virtual or physical?

The best advice I can give for now, is that you should try to examine the remote servers closely. Perhaps run your queries locally on each server, to find out how they perform directly on that server (to eliminate network concerns). Then, maybe try to import the data through SSIS, instead of using Linked servers (to eliminate some linked server configuration concerns). Take baby steps, and little by little, the problem should become more apparent.

Upvotes: 1

Related Questions