|
Hi, Can someone explain why running a stored procedure through an Execute SQL Task would be slower than executing it via SQL Server Management Studio? I am finding that it is almost a 100 times slower. Regards,
(comments are locked)
|
|
Lots of possible causes...... What is the stored procedure doing? What does the stored procedure return? Where is the SSIS task executing, with regards to the database server? Same server, over network? Where are you running SSMS, with regards to database server? On server, over network?
(comments are locked)
|
Your answer
There was a blocking error on the Server. Overlooked going through the basic checks.
Another thing to be conscience of is the Transaction Isolation Level of the SSIS objects, most default to Serializable and this may not be what you want. Changing the property to Read Committed may be more appropriate for your situation
Thanks for suggestion, now i need to close this post but cant see where to do that on this site?
If someone came up with an answer that answered your question, you can mark it - there's a little image-button for that just under the thumbs-down-button. Otherwise you just leave it. Questions can be closed by administrators and mods, but that's only when they break the rules or intentions of the site.