Article - CS324428
Disable table lock escalation in SQL Server for Windchill PDMLink
Modified: 08-Aug-2023
Applies To
- Windchill PDMLink 10.0 to 13.0
- SQL Server 2012, 2014, 2016, 2017, 2019
Description
- Table lock escalation is enabled by default
- SQL Server can choose to escalate row locks to a table lock
- Table lock can result in an operation blocking other unrelated operations
- Windchill performance is low due to row locks escalated to a table lock
This is a printer-friendly version of Article 324428 and may be out of date. For the latest version click CS324428