We have a VB application that seems to be generating a bunch of ##Lockinfo entries in the the tempdb. Also, while the spid is sleeping the locks don't seem to go away. What would cause an application to create what seem as presistant locks on this this resource?
We have had such problem on one of the heavily used database and when I was looking from Enterprise Manager, later it found to be problem with EM display that is not scalable. I would suggest to monitor the events using SP_WHO2 for more information. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Would this mean that the locks aren't really there? quote:Originally posted by satya We have had such problem on one of the heavily used database and when I was looking from Enterprise Manager, later it found to be problem with EM display that is not scalable. I would suggest to monitor the events using SP_WHO2 for more information. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Yes and for final confirmation check with SP_WHO2. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks for the info quote:Originally posted by satya Yes and for final confirmation check with SP_WHO2. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
If the process is deadlocked then you will see an error message in SQL Server error log too. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
See if this tool by SQL Server MVP Erland Sommarskog will help you:http://www.sommarskog.se/sqlutil/aba_lockinfo.html -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Frank That is a valueable link about lockinfo. Thanks. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Are you telling me, you didn't know that link? <br />Wow, amazing [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
