1
kudos
spam Kudos Remove

Geek City: What do you intend with that lock?

published 971 days, 7 hours, 31 minutes ago posted by sasa 981 days, 5 hours, 28 minutes ago
Friday, September 25, 2009 1:46:41 PM GMT Tuesday, September 15, 2009 3:49:32 PM GMT

Way back in the olden days, prior to SQL Server 7, I already knew that the lock manager was one of the most complex and resource intensive parts of SQL Server. Keeping track of every lock held, who was waiting for that lock, who could be granted the lock, and who was next in line for the data if the lock was released was a lot for SQL Server to keep track of. I admit, I was worried about the promised feature of row-level locking, thinking that it was going to be orders of magnitude more expensive. Withou...

category: Management | clicked: 0 | | source: sqlblog.com | show counter code
tags: Locking, Metadata

No comments yet, be the first one to post comment.

To post your comment please login or signup