SQL Server Lock Escalation clarity required
0
votes
1
answer
220
views
I want to know whether Enabling the Trace Flag 1211 globally prevents the Lock Escalation even in the event of the Huge Memory Pressure.
I have 2 Questions regarding this:-
1. After Enabling Trace Flag do we still need to alter each and every Table in the User Database to Disable Page Locks.
2. Suppose if the answer is Yes then we would still need to disable Page Locks at each and every Non Clustered Indexes on the above Tables to prevent Page locks / Lock Escalation.
Asked by Jeetendra Pardeshi
(27 rep)
Aug 18, 2020, 07:40 AM
Last activity: Aug 18, 2020, 05:42 PM
Last activity: Aug 18, 2020, 05:42 PM