Post reply

System Tables Locks

  • February 13, 2009 at 10:19 am

    #205520

    On one of the vendor applications in the LOCKS i am seeing

    object name syscolpars, syshobtcolums, sysprivs sysrowsetcolumns and MODE V.

    I am not sure why i am seeing these appear in the LOCKs or what to do .

    Anyone through me some light...

    All i see on research is dbcc check errors ...

  • February 13, 2009 at 10:27 am

    #943783

    Shall I understand you are seeing locks with lock mode=V ?

    In the affirmative case, which version of SQL Server are you running?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 13, 2009 at 11:05 am

    #943821

    Sorry Mode X Lock Type is KEY, STATUS GRANT

    SQL 2005

  • February 14, 2009 at 9:48 am

    #944094

    TRACEY (2/13/2009)

    Sorry Mode X Lock Type is KEY, STATUS GRANT

    SQL 2005

    If the DBID for those locks is "2"... don't worry about it... that's TempDB.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • March 3, 2009 at 8:08 am

    #952428

    Database id is not 2 it is the main db table.

    syscolpars, syshobtcolumns, sysprivs etc.

    Mode X

    Thanks

  • March 4, 2009 at 1:39 am

    #952940

    TRACEY (2/13/2009)

    Sorry Mode X Lock Type is KEY, STATUS GRANT

    SQL 2005

    KEY RANGE locks, are you updating or inserting any new rows?

    Do you face any problem with them or is it just that you want to know?

  • March 4, 2009 at 7:49 am

    #953207

    No problem i just wondered what they were it is key range locks...because i have the auto statistcis sync on ? is that why i see them.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply