Re: maxlocks

Gareth Williams wrote:
> Can anyone tell me if there's an easy way to trace transactions that have
> forced to a table level lock?
>
> The errlog mentions that we've gone to table level but doesn't show the
> offending sql. It would be really handy if there were some trace level.

This might be useful if a table level lock is taken at immediately, but
I'm not so certain about an escalation The preceding SQL might use up
(for example) 499 locks out of a limit of 500, and then a simple
statement locking just one page (or row) then forces escalation. It
might not even be on the same table as the other 499 locks...

John Dennis

.