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 |
|
mounikakala
Starting Member
14 Posts |
 Posted - 2008-10-11 : 19:18:50
|
| Hi,I have a set of Stored Procedures runing which Selects Data and inserts/Updates into Tables which are on a Linked Server. They are Taking very long time to run.When I changed the Stored Procedure to insert/update on a Different Database on the Same Instance, the SP's are quick.Is there are any problem in using Stored Procedures on Linked Servers and How do I overcome this?Please help.My DB Server is SQL 2005.ThanksMounikakala |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-12 : 02:24:31
|
| is stored procedure doing some complex operations?While executing,trace with profiler to see whats happening on background. |
 |
|
|
mounikakala
Starting Member
14 Posts |
Posted - 2008-10-12 : 12:05:28
|
| The same SP is working fine on the Same Instance, even I saw through Profiler not too much of complexity exists. Its Inserting and Updating the Data.The Issue is that on the Linked Server it is taking almost 3 times the time. So wanted to know if there any issues in SQL 2005 when running SP's on Linked Servers.ThanksMouni |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-12 : 15:20:05
|
| Why don't you use SSIS instead? |
|
|
|
mounikakala
Starting Member
14 Posts |
Posted - 2008-10-12 : 19:59:27
|
| Well SSIS Package can be tried thats an option I shall explore.But wanted to know if there any issues in SQL 2005 with SP's running between Linked Servers. |
|
|
|
|
|
|
SP's Running on Linked Servers