Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Locking in Database make all clients hold

    We are using SQL2000 with SP3, Windows 2000 Svr Std with SP4

    Sometimes, we found all clients had no response. Later, we found that the all clients are waiting response from sql server.

    Then in querry analyzer, we use this script:

    select * FROM master..sysprocesses where status='sleeping' AND waittype=0x000 AND open_tran > 0

    and then we found out one computer is locking and after request that computer logout the program, then, all clients can run again.

    However, I have no idea why this case happen and I am still searching what's the meaning the about select statement.

    Can anyone help me?

    Ivan

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Try Using Enterprise Manager to look at Current Activity

    This should show you who's locking at a glance & provides a lot of usefull info

    Sounds like your getting Deadlocks

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

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