Longer execution times at the end of the day
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