The following tips may help avoid deadlocks with multiple users:
Make sure Adaptive Server is using the same number of connections as the Enhanced Full-Text Search. 100 is the default.
sp_configure "user connections", 100
Make sure the vesaux, vesauxcol and text_events tables (in the model, or in each of your new databases) are using row-level locking.
For existing tables: alter table table_name lock datarows
For new tables: create table ... lock datarows
For large batches of commands, try to break them into smaller transactions.
If deadlocks still occur, increase the number of locks available to Adaptive Server, and adjust the row lock promotion settings. See the System Administration Guide.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
