Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mistryvipulh
Starting Member
4 Posts |
 Posted - 2010-11-21 : 08:11:25
|
| hello frndscan anybody explain me Intent Locking in detail. I understood that intent locking is to establish locking hierarchy, but i am not able to understand the 3 types of intent locks (1. Intent Shared, 2. Intent Exclusive and 3. Shared With Intent Exclusive). Can anybody explain me with example how these 3 types of locks works.I google on internet and i just found the following few lines: 1. IS locks indicate that the transaction will read some (but not all) resources in the table or page by placing shared locks.2. IX locks indicate that the transaction will modify some (but not all) resources in the table or page by placing exclusive locks.3. SIX locks indicates that the transaction will read all resources, and modify some(but not all) of them. This will be accomplished by placing the shared locks on the resources read and exclusive locks on the rows modified. Only one SIX lock is allowed per resource at one time; therefore, SIX locks prevent other connections from modifying any data in the resource (page or table), although they do allow reading the data in the same resource.what does that mean?Thanks in adv.Waiting for your response. Its urget |
|
|
|
|
|
Intent Locking In Sql Server