Stored Procedure Performance

Hello,

(SQL 2005)

Given that a stored procedure and T-SQL code in query analyzer are exactly the same, why would the stored procedure run much slower

When I mean much slower I mean 3 sec for the code in query analyzer as opposed to 2:33 sec for the stored procedure.

Exact same code!

Profiler also gives more reads and writes for stored procedure, and a lot of BatchStarted and BatchCompleted directives between the 'start' and 'end' of the stored procedure.

Any help is greatly appreciated.

-Tim

Also posted this question in the T-SQL forum. Will copy any valued input to both posts.

Answer this question

Stored Procedure Performance

ygermain

I responded in the T-SQL group. Let's keep things in a single thread there so that we can all benefit from whatever input people give.

--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html bID=457
--

<Timothy1170@discussions.microsoft.com> wrote in message news:d77f98c2-1d8a-4461-9032-a3cbeda13115@discussions.microsoft.com...

Hello,

(SQL 2005)

Given that a stored procedure and T-SQL code in query analyzer are exactly the same, why would the stored procedure run much slower

When I mean much slower I mean 3 sec for the code in query analyzer as opposed to 2:33 sec for the stored procedure.

Exact same code!

Profiler also gives more reads and writes for stored procedure, and a lot of BatchStarted and BatchCompleted directives between the 'start' and 'end' of the stored procedure.

Any help is greatly appreciated.

-Tim

Also posted this question in the T-SQL forum. Will copy any valued input to both posts.
Stored Procedure Performance

Answer this question