SQL Server Performance

##LockInfo ?

Discussion in 'Performance Tuning for DBAs' started by JLDominguez, Jul 18, 2005.

  1. JLDominguez New Member

    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?
  2. satya Moderator

    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.
  3. JLDominguez New Member

    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.
  4. satya Moderator

  5. JLDominguez New Member

    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.
  6. satya Moderator

    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.
  7. FrankKalis Moderator

  8. satya Moderator

    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.
  9. FrankKalis Moderator

    Are you telling me, you didn't know that link? <br />Wow, amazing [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<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 />

Share This Page