x

SSIS EXEC PROC SLOWER THAN SSMS

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,
more ▼

asked Jan 13 '11 at 12:27 AM in Default

Tshokologo gravatar image

Tshokologo
13 1 1 1

There was a blocking error on the Server. Overlooked going through the basic checks.
Jan 13 '11 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 '11 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 '11 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 '11 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 '11 at 01:14 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x899
x123

asked: Jan 13 '11 at 12:27 AM

Seen: 1484 times

Last Updated: Jan 13 '11 at 12:27 AM