Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_chaser
Starting Member
33 Posts |
 Posted - 2015-03-11 : 15:11:17
|
| We are pulling data across the server through VPN tunnel by using Linked Server.The query that runs on the 30 seconds is taking 3 Minutes to run through the linked server. Few changes were done to bring it to 3 minutes.1) Changed to OpenQuery2) Validated the Indexes-- Is there anyway to force the Index by using Forceseek as some of the fields are not indexed... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-11 : 15:16:01
|
| Show us the query and statistics IO output.Please note that running a query through a linked server is going to be slow.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2015-03-12 : 12:11:54
|
| Create a stored proc on the remote server, and just exec the procedure rather than passing the query over. |
|
|
|
|
|
|
Linked Server Performance Issue