Post reply

Page lock, dead lock

  • November 3, 2008 at 4:37 pm

    #195644

    I've got a page lock on my application, but i don't know how to read it.

    i've attached xml file from sql server profiler.

    Any ideas will be great.

    Thanks in advance.

    ps. it is sql server 2005 and connections are about 50.

  • November 4, 2008 at 1:01 am

    #893460

    Is the deadlock happening frequently? If so, please enable traceflag 1222 (DBCC TRACEON (1222,-1) ). That will write a very detailed deadlock graph into the error log. Please post the deadlock graph (from 1222) here.

    In the meantime... If you look at the page log in the deadlock graph, it lists an associated object. Take that number and use it in the following query.

    SELECT OBJECT_NAME(object_id)

    FROM sys.partitions

    WHERE partition_id = < associated object id >

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

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