sql server programming: 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.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
Hi there!!!

Where can I get info about how to build the sql logic/statements while under
multiuser mode.

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???
--
Vadym Stetsyak
PDS

Hi there!!!

Where can I get info about how to build the sql logic/statements while under
multiuser mode.

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???
--
Vadym Stetsyak
PDS