Why are you trying to control the locking manually? Do you have any special
locking requirements? I would leave it to the RDBMS to handle. By deafault
SQL Server runs under READ COMMITTED isolation level. If this is not
suitable for your environment, you could switch to a suitable isolation
level. Any isolation stricter than READ COMMITTED will result in reduction
of concurrency while guranteeting better data accuracy.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"Vadym Stetsyak" <net> wrote in message
Where can I get info about how to build the sql logic/statements while under
Under multiuser mode I mean that data in the tables is modified by multiple
users and all the activity is performed in the transaction bounds. I am
using rowlock to synchronize the access to the table.
Everything works quite fine under low load, but when the number of clients
increases - locks can be observed and all clients begin to wait.
So, where can I get the info how to build multiuser systems, synchronize
access to the resources on the basis of the MS SQL Server???