Viewing 2 posts - 1 through 2 (of 2 total)
:blush:
Sorry - not much useful in our resolution.
This issue was related to a service broker job that was running on the server very frequently. Most of the time it caused...
October 20, 2016 at 11:48 pm
#1907854
Thanks for suggestions.
We have created some versions of the SP's to mitigate the parameter sniffing - testing already.
Will look into blocking as well - has been investigated before...
September 2, 2016 at 2:59 am
#1898943