How to avoid precompile

[bheemsen]

Hi Gurus,

I found that whenever my procedure is called, it is precompiled. Is there any way I can tell SQL Server not to precompile a particular stored procedure ?

I appreciate your responses.

thanx..
-Bheemsen

 

[chiph]

Not that I know of. It has to be run through the precompiler in order for it to be stored in the procedure cache. You could dump the cache, but that's like setting fire to your dog because it has fleas (high temperature being a sure way to kill fleas).

When we are forced to dump cache on our production servers (because of a cluster failover or a reboot), the app slows down noticeably for about half a day until the cache fills back up.

Chip H.

 

[topher0303]

If you put WITH RECOMPILE in your sproc statement, it will not cache it. It will be recompiled each execution.

Chris.