Reducing locking in Maximo with Row Versioning
Starting with SQL Server 2005, row versioning can reduce or eliminate locking in Maximo.
Database locks are seen in the database.
Resolving the problem
Performance can be improved and locks minimized. This prevents the read
lock from blocking other transactions.
There are some space considerations in tempdb which should be discussed with DBA.
alter database [MX} set single_user with rollback after 120 seconds;
alter database [MX} set read_committed_snapshot on;
alter database [MX} set multi_user;
|Systems and Asset Management||Maximo Asset Management Essentials|
More support for:
Maximo Asset Management
Software version: 6.2, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5, 7.6
Operating system(s): Windows
Reference #: 1440598
Modified date: 2010-07-12