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.


more ▼

asked Jan 13, 2011 at 12:27 AM in Default

avatar image

13 1 1 3

There was a blocking error on the Server. Overlooked going through the basic checks.

Jan 13, 2011 at 04:36 AM Tshokologo

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

Jan 13, 2011 at 04:58 AM Scot Hauder

Thanks for suggestion, now i need to close this post but cant see where to do that on this site?

Jan 13, 2011 at 10:30 PM Tshokologo

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.

Jan 13, 2011 at 10:39 PM Magnus Ahlkvist
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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?

more ▼

answered Jan 13, 2011 at 01:14 AM

avatar image

Kev Riley ♦♦
64.1k 48 61 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 13, 2011 at 12:27 AM

Seen: 2050 times

Last Updated: Jan 13, 2011 at 12:27 AM

Copyright 2016 Redgate Software. Privacy Policy