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 |
|
Karthi
Starting Member
3 Posts |
 Posted - 2009-02-20 : 06:32:01
|
| Hi All,I want to know the cost of the below locks.1)ROW2)PAGE3)TABLEi mean which one will take more memory space?Inputs are welcome!RegardsKarthik M.C.ADB Developer |
|
|
Karthi
Starting Member
3 Posts |
Posted - 2009-02-20 : 06:33:13
|
| It should be useful if anybody explain it with example.RegardsKarthik M.C.ADB Developer |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 07:13:04
|
| SQL Server determines lock escalation from ROW lock to Table Lock unless you force it to use it. |
|
|
|
Karthi
Starting Member
3 Posts |
Posted - 2009-02-20 : 09:58:32
|
| My question is which one will occupy more memory space ?RegardsKarthik M.C.ADB Developer |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 13:42:26
|
| My answer is you can't definitely say which consumes more memory. SQL Server escalates lock to reduce overhead (When higher coarse-grained locks are acquired ,the memory reserved by lower grained locks are released). It also escalates when memory taken by lock goes beyond 40 % .Disadvantage is it can have serious blocking issue. |
|
|
|
|
|
|
Locks + Memory Space