Hi all,

Thanks so much for the quick responses and avenues to explore.

We went straight in and added OPTION (RECOMPILE) to the main SELECT within the sproc and saw immediate performance...

Hi Usman,

The debugging we put in wrote the sproc's execution duration to a logging table every time the sproc was accessed (usually in the order of < 10 per...

Hi Usman,

Thanks for your reply.

We stripped the SQL Job so that it only contained the disable and re-enable trigger SQL commands and the problem still remained and therefore we've ruled...