Multiple Users

The following tips will help avoid deadlocks with multiple users:

  1. Make sure the ASE is using the same number of connections as the Full-Text Search. 100 is the default.

    sp_configure “user connections”, 100
  2. 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

  3. For large batches of commands, try to break them into smaller transactions.

  4. If deadlocks still occur, increase the number of locks available to the ASE, and tweak the row lock promotion settings. See the ASE System Administration Guide to assist with setting locks.