Did You Know…Locking is Normal in SQL Server

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight finding about it in a line or two.

Yes, Locking is a normal behavior in SQL Server and it happens many times in a day. This is what promotes the consistency of tables affected by the queries, specially the concurrent ones.

Advertisements