DF215: Locking hint is used.

The topic describes the DF215 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

Locking hint is used.

Description

Locking hints should be used with caution. Please review the query.

Additional information

The rule is applied to:

  • Holdlock
  • Nowait
  • Paglock
  • Readcommitted
  • Readcommittedlock
  • Readpast
  • Readuncommitted
  • Repeatableread
  • Rowlock
  • Serializable
  • Snapshot
  • Tablock
  • Tablockx
  • Updlock
  • Xlock

Noncompliant code example

SELECT id FROM dbo.DemoTable WITH(TABLOCKX)
GO

Compliant solution

SELECT id FROM dbo.DemoTable
GO