Lock Escalation in SQL server

Question

Hi Friends

I want to know about Lock Escalation in SQL server ?

Answer 1

Hi Manish,


Please refer the below links

http://strictlysql.blogspot.in/2010/11/lock-escalation-sql-server-2008.html

http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx

http://aboutsqlserver.com/2012/01/11/locking-in-microsoft-sql-server-part-12-lock-escalation/



Thanks