Active locking is implemented differently for the SQL database type than it is for the c-tree or Pervasive.SQL database types. The SQL implementation of active locking tracks locks on a per-client basis.
We recommend that you rely on passive locking instead of active locking whenever possible. Using active locking with the SQL database type can cause performance degradation.
This portion of the documentation explains the implementation of active locking for applications using the SQL database type, and outlines the steps you need to take to prepare your SQL Server databases to accommodate the Dexterity locking scheme. Information about locking is divided into the following sections: