I've created a stored procedure and tried to compare the
execution plans by passing different parameters to it. The
execution plan in all the cases is displayed as same. But
how can i make sure that SQL Server is using the same
execution plan from memory each time i execute my stored
procedure. I want to make sure its not recreating the
execution plan each time i call the stored procedure.
Appreciate if anyone can help me to trace that.
Lots of thanks in advance.Look at masters syscacheobjects for your proc
select * from master.syscacheobjects where objid = object_id('myproc')
If you are plan sharing, you should see 2 entries, 1 executable plan and
1compiled plan...
"Sudhakar Koolla" <anonymous@.discussions.microsoft.com> wrote in message
news:093801c3b81d$492771b0$a301280a@.phx.gbl...
> I've created a stored procedure and tried to compare the
> execution plans by passing different parameters to it. The
> execution plan in all the cases is displayed as same. But
> how can i make sure that SQL Server is using the same
> execution plan from memory each time i execute my stored
> procedure. I want to make sure its not recreating the
> execution plan each time i call the stored procedure.
> Appreciate if anyone can help me to trace that.
> Lots of thanks in advance.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment