We have a stored procedure which executes in less than 1 second during the day. The same procedure exceeds 30 seconds at the end of the day which is also the peak time for our system.
Below are some information about the stored procedure: Statistics for our data are calculated early in the morning. Auto update statistics is disabled for our database. In the stored procedure, we perform 30 left joins using the WITH (NOLOCK) hint. All tables are joined using the same primary key.
What might possibly make the procedure to take more time during peak processing periods ?
Thank you for your help
By Shah 1 asked Nov 04, 2015 at 03:09 PM