Post reply

Lock Manager Deadlock search

  • October 12, 2005 at 10:01 am

    #152581

    We have three servers (dev, test, prod) all with same RAM, CPU(Intel EMT64), RAID, same databases, Windows Server 2003 x64 Enterprise, SQL Server 2000 SP4.

    I see the following repeated over and over in the SQL (error) log on our test server and am curious why it shows up:

    Starting deadlock search 34450                                                                                                                                                                                                 0

    2005-10-12 09:49:51.31 spid4     Target Resource Owner:                                                                                                                                                                                                         0

    2005-10-12 09:49:51.31 spid4      ResType:ExchangeId Stype:'AND' SPID:73 ECID:0 Ec0xBBA39370) Value:0x800ee67c                                                                                                                                                0

    2005-10-12 09:49:51.31 spid4      Node:1  ResType:ExchangeId Stype:'AND' SPID:73 ECID:0 Ec0xBBA39370) Value:0x800ee67c                                                                                                                                        0

    2005-10-12 09:49:51.31 spid4                                                                                                                                                                                                                                    0

    2005-10-12 09:49:51.31 spid4     End deadlock search 34450 ... a deadlock was not found.    

    Thanks,

    JL

     

     

  • October 12, 2005 at 4:04 pm

    #596951

    Check the SQL server startup configuration and see if trace flags -T1204 or -T3605 have been set.

    SQL = Scarcely Qualifies as a Language

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

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