August 25, 2008 at 9:49 pm
Carl Federl (8/25/2008)
"could you post a copy of the code that fixed your parameter sniffing problem?"This application is running under SQL Server 2000 and the analysis consisted of running a trace to determine what stored procedures were being run early in the morning with nontypical parameters. The solution was to schedule a job that executed sp_recompile on each of those procedures before most of the staff arrived.
Since the application was a package, we could not change the stored procedure code nor change the sp to recompile on each execution.
Roger that. Thanks for the interesting feedback, Carl.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply