Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Disables lock escalation for the specified table.
Syntax
server public static void disableLockEscalation(TableId _tableId)
Run On
Server
Parameters
- _tableId
Type: TableId Extended Data Type
The table for which lock escalation should be disabled.
Remarks
This method is provided to avoid the lock escalation issues that are exhibited by preprocessing reports tables that are populated using set-based inserts. It should be used sparingly because it can have adverse effects on performance elsewhere in the system when it is under memory pressure.