Guys, I am so thankful for your help.

I think parameter sniffing is definitely might be the root cause.

I am rewriting procedure now to use local variables.

Will let you know on the outcome results soon.