Got it! Thanks!

That create statement was just misleading. 🙂

thanks.

But does that mean that with every call the sp is getting created, compiled and then executed?

Thanks for the info - my query was why do activities that are in sleeping state consume CPU and that too it is growing every second.