Thank you so much Grant. You are always helpful and informative. Looking into your suggestions now.
Capture the wait statistics when the procedure is run in order to understand what is causing it run slow.
What do you recommend to capture the wait stats?