Toby White (4/2/2010)
Parameter sniffing is the process whereby the optimizer uses the initial values of the parameters to generate an optimal execution plan. One of the problems can occur when the plan created with the initial parameter values is reused with atypical parameter values later. This would not be occurring if the procedure is recompiled every time it is executed.
Exactly. But I read your comment as saying that if the problem were parameter sniffing, then recompiling the procedure each time it was called would not help:
It could be parameter sniffing, but recompiling the whole procedure shouldn't have a positive effect if it is.
Did I misunderstand you?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi