Viewing 2 posts - 1 through 3 (of 3 total)
GilaMonster (1/7/2015)
In short, if a single session is holding a lot of locks on a single object (>4000) or lock memory is taking up a...
January 7, 2015 at 6:21 am
#1768411
Plan regression due to data volume changes
Lack of lock memory, resulting an a lock escalation
etc
Could be a number of things, hard to say without any details (code, plan,...
January 7, 2015 at 4:11 am
#1768389