SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Server: Using linkserver Stored compile is very slow

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Server: Using linkserver Stored compile is very slow
Author Message
takakou



Joined: 27 Jan 2009
Posts: 16
Country: Japan

Post SQL Server: Using linkserver Stored compile is very slow Reply with quote
My project use about 30 Link server synonyms.
When I compiled stored procedure, result message elapsed time under 1 sec, but SQL Editor is busy about 1 min.

During SQL Editor is busy, Database execute sql for link server.
I checked by windows task manager.

May be SA try to refresh cash via link server.
But refresh area seems too big...
Tue Jun 12, 2018 9:24 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6749

Post Reply with quote
You should disable automatic cache refresh in this situation, which is performed after all DDL operations including ALTER PROCEDURE. This certainly slows down all thing in a setup like yours. The easiest way to do that is to uncheck the Auto-refresh checkbox in the Database Explorer pane (top-right corner). This works for the current instance of the SQL Editor.
To force manual refresh, click the Refresh icon next to the checkbox.
Wed Jun 13, 2018 2:39 am View user's profile Send private message
takakou



Joined: 27 Jan 2009
Posts: 16
Country: Japan

Post Reply with quote
SysOp wrote:
You should disable automatic cache refresh in this situation


Yes. It's nice!

Thank you
Tue Jun 19, 2018 9:28 pm View user's profile Send private message Send e-mail
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.