Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

blocking Expand / Collapse
Posted Wednesday, December 28, 2011 1:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 6, 2012 11:06 PM
Points: 2, Visits: 50
wt type of blocking we will get in sqlserver
Post #1227538
Posted Tuesday, May 29, 2012 7:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 11:00 AM
Points: 46, Visits: 50
I am guessing at the general nature of your question that this is a relatively new topic to you.

Types of blocking are documented throught SQL Server help, MS's knowledge base and so on. It is a necessary part of the process when handling multiple users or processes updating potentially the same information and a fundemental of relational databases.
A basic lock will stop one person changing data that is currently being changed by another. In a transaction you might want to select the data and lock the data while you are making changes to it, preventing anyone else from changing it or even reading it until you have made the changes.
Schema locks stop people changing the structure of the table. There are many kinds of blocks - some exclusive, some share.
Please do consider that blocking is a process trying to get something that is locked by something else.
This Microsoft TechNet blog gives some good information of the different types of locks on SQL Server 2008:
Here is Microsoft's Understanding And Resolving Blocking Problems article:

I hope this helps get you started.
Post #1307765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse