Results 1 to 2 of 2

Thread: Limit lock time

  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Unanswered: Limit lock time

    Sometimes we have problems because of locks taking too much time in our db systems. I'm thinking about how to find lock numbers and how to limit lock times. Do anyone have any idea ? I'm a newbie in a big firm i need your answers

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    hi,
    Locks are held on rows/pages/objects depedning on various scenarios. long lock duration could be because of bad code or if the database design is not right. etc etc

Posting Permissions

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