This refers to SQL 7.0. Having run out of memory for locks once again (im currently inspecting each and every query to avoid this, but im in it for the long haul; theres thousands), I am struggling to gain enough diagnostic info from client tools to help me concentrate my efforts on the worst queries. As soon as the lock error occurred, I ran select lock_cnt = count(*), tran_cnt = @@trancount from master..syslocks which shows me that 74 locks were active. This doesnt seem particularly high, does this refer only to table locks? How can I get more information about the sort of lock allocations currently active, and how much memory is currently allocated to locks. Ive checked BOL, this site, and several other web sources but I didnt find my answer.