SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


blocking


blocking

Author
Message
madhu.dba444
madhu.dba444
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 50
wt type of blocking we will get in sqlserver
Steven Devaney
Steven Devaney
Valued Member
Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)Valued Member (70 reputation)

Group: General Forum Members
Points: 70 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: http://blogs.technet.com/b/josebda/archive/2009/03/19/sql-server-2008-locking.aspx
Here is Microsoft's Understanding And Resolving Blocking Problems article: http://support.microsoft.com/kb/224453

I hope this helps get you started.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search