http://www.sqlservercentral.com/blogs/livingforsqlserver/2012/09/08/my-session-on-locking-internals-part-1-in-cssug-meet/

Printed 2014/07/28 12:43AM

My Session on Locking Internals Part 1 in CSSUG Meet

By Ramkumar (LivingForSQLServer), 2012/09/08

Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server devotees irrespective of bad weather in Chennai.

CSSUG meet started with my presentation on SQL Server Locking Internals Part 1.

Vidhyasagar gave session on ColumnStore Index and FileTable. Todays topic for Mathi is T-SQL 2012 New Features.

In today’s session, I have covered some pre-requisite topics such as ACID properties, Data Consistency Issues and locking basics.

Idea is to execute some basic & intermediate level DDL/DML operations and observe the behavior of locks. Once this is covered, I plan to focus more on Lock Manager.

You can download my presentation file here.

http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/Locking/Locking%20InternalsPart%201.zip

Eager to hear your comments about my slides. This will help me to correct my mistakes and improve in coming sessions.

 

Reference:

1. Paul Randal
2. Book: Professional SQL Server 2008 Internals and Performance Tuning (Wrox Publishers)

 

CSSUG

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.