DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Deadlocks

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    Deadlocks

    Hi, how to find the machine name causing deadlock? I mean any Data Dictionary object to view this information.

    I have checked the trace file but not able to locate.



    thanks,
    Last edited by iris; 12-26-2010 at 08:59 AM.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    did you check the alert log? It gives the good information about dead locks but not sure about machine name.

    Find the SQL which is causing dead lock then you can find from which machine it is executed.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width