Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Server
Category:
query-performance
Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why.