Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Question Unanswered: How to detect Deadlocks

    How does Sybase detect deadlocks?
    Is there any special daemons running in background to see processes contending for resources or simply just some timeout mechanism?

  2. #2
    Join Date
    Jan 2004
    Location
    Munich/Germany
    Posts
    12
    Sybase has an internal function: see the following

    3 0 sleeping 0 0 0 0 master DEADLOCK TUNE 512

  3. #3
    Join Date
    Oct 2003
    Posts
    41
    Use sp_monitorconfig

    In ASE 12.5.0.3 it tells the statistics about number of locks used
    ====================
    Rajesh

Posting Permissions

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