General Question on sp_recompile
5
votes
3
answers
1223
views
For couple of scenarios, not many a times but few we have seen doing sp_recompile on a stored proc improving the performance.
Being a DBA i understand few of caveats involved when doing sp_recompile and why it would have worked in improving with performance.
There has been a constant debate within our management to provide Application/DEV DBA's the access to do sp recompile when they see performance issues like above. Just so that less of DBA involvement is there and APP devs can run on their during perf issues
I am very hesitant as i think it can bring some unwanted behaviors where it can sometime even worsen performance of other procs.
I am looking for general guidance and experience from your experts why this can be a bad idea under possible different circumstances or when it can be ideal. Your inputs might help me design and may be explain the approach in different way.
FYI- Above is being thought not across just one app but across few other as automation when seeing issues like parameter sniffing.
Asked by BeginnerDBA
(2230 rep)
Jan 19, 2021, 08:02 PM
Last activity: Jan 21, 2021, 07:07 AM
Last activity: Jan 21, 2021, 07:07 AM