SQL Server Performance

What is ObjectID 0 (zero)?

Discussion in 'T-SQL Performance Tuning for Developers' started by Nazgul, May 12, 2003.

  1. Nazgul New Member

    I have been running SQL Profiler on one of my SQL Server 2000
    databases to determine where we may have slow stored procedures. One
    thing I have noticed is that periodically there are Lock:Timeout
    events recorded, but sometimes the ObjectId is listed as 0 (zero).
    What does this mean? What is ObjectId 0? There are no records in sysobjects with id 0.

    Thanks

    Bryan Goossen
    NNC Group
    Nazgul, May 12, 2003
    #2

  2. satya Moderator

    satya, May 12, 2003
    #2

  3. Nazgul New Member

    Thanks, but the article mentioned does not answer my question. It simply says what the column means, which is "ID of the object on which the lock was timed out.". My problem is that the ObjectID that is reported has a value of 0 (zero), and there is no such object with an ID of zero.
    Nazgul, May 12, 2003
    #2

  4. Chappy New Member

    have you checked ObjectName and ObjectType profiler columns also ? I very much expect they will be blank also, but its worth checking.
    Chappy, May 12, 2003
    #2

  5. Nazgul New Member

    I have now checked ObjectName and ObjectType also, and you are right, they are both blank.
    Nazgul, May 13, 2003
    #2

Share This Page