Blocking Is Not Bad

Published On: 2013-07-24By:

When dealing with SQL Server databases we have to deal with locking, and blocking within our application databases.  All to often we talk about blocking as being a bad thing.  How ever in reality blocking isn’t a bad thing.  The SQL Server uses blocking to ensure that only one person is accessing some part of the database at a time.  Specifically blocking is used to ensure that when someone is writing data that no one else can read that specific data.

While this presents as a royal pain in that users queries run slower than expected, the reality is that we don’t want users accessing incorrect data, and we don’t want to allow two users to change the same bit of data. Because of this we have locking, which then leads to blocking within the database.

All of this is done to ensure that data integrity is maintained while the users are using the application so that they can ensure that the data within the database is accurate and correct.

Without locking and blocking we wouldn’t have data that we could trust.

Denny


Contact the Author | Contact DCAC

One response to “Blocking Is Not Bad”

  1. jdanton says:

    Without locking we would have a bad NoSQL database. 

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via