SQL Server locking and blocking
Each DBMS allowing concurrent multi-user access needs to think about consistency (ACID).Locking is the key answer, so it is a good thing. At the same time it can be annoying. Locking leads to blocking which very often results in bad performance.In this session we will have a look at how locking works, how it affects query performance, how to view locking and blocking information and how to influence SQL Server’s default behavior using locking hints and isolation levels. We will introduce key concepts with slides but spend most of the times looking at demo’s.
Sorry, there are no downloads available for this session.
Peter ter Braake, SQL Server MVP and MCT, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQL Saturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
The video is not available to view online.