---
title: "What is lock escalation?"  
description: "What is lock escalation?"  
author: "Anonymous User"  
published: 2011-01-14  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/319/what-is-lock-escalation  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is lock escalation?

When the number of row, page locks held per tablespace

exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock

is escalated to a tablespace lock.

## Answers

### Answer by Anonymous User

When the number of row, page locks held per tablespace

exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock

is escalated to a tablespace lock.


---

Original Source: https://www.mindstick.com/interview/319/what-is-lock-escalation

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.