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 |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2004-06-28 : 22:35:00
|
| Dear All, When several records are inserted into a table, what kind of lock is applied to the table? Will lock in insert action promoted to table lock? Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-28 : 22:53:15
|
| It depends on the size of the insert and available memory. You might want to check out the seminars at http://www.microsoft.com/seminar/default.mspx. They have a really good seminar on locking.Basically, SQL Server will try to apply row locks. When memory becomes tight due to too many row locks or it decides it's more efficient to escalate, page locks will be created. Eventually, it will escalate it to a full table lock.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Lock in Insert action