Lock_escalation

• yujinagata72

  Ten Centuries

  Points: 1072

  More actions

  August 17, 2016 at 10:04 pm

  #320625

  Hi,

  Is there any way to find out what tables have been disabled for lock escalation in the database?

  Thanks,

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  August 17, 2016 at 10:27 pm

  #1896071

  yujinagata72 (8/17/2016)

  ---

  Hi,

  Is there any way to find out what tables have been disabled for lock escalation in the database?

  Thanks,

  sys.tables has this information:

  https://msdn.microsoft.com/en-us/library/ms187406.aspx

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service