1 / 6

Locking Internals By Amit R S Bansal Director, Principal Consultant & Trainer

Locking Internals By Amit R S Bansal Director, Principal Consultant & Trainer www.PeoplewareIndia.com | www.amitbansal.net MVP, MCT, MCTS , MCITP etc .. www.facebook.com/groups/theSQLGeeks Follow me on twitter now @ A_Bansal http :// www.facebook.com/amit.r.bansal. Amit R S Bansal.

althea-mcdowell
Download Presentation

Locking Internals By Amit R S Bansal Director, Principal Consultant & Trainer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Locking Internals By Amit R S Bansal Director, Principal Consultant & Trainer www.PeoplewareIndia.com | www.amitbansal.net MVP, MCT, MCTS, MCITP etc.. www.facebook.com/groups/theSQLGeeks Follow me on twitter now @A_Bansal http://www.facebook.com/amit.r.bansal

  2. Amit R S Bansal Technical Director, eDominer Systems & Peopleware India Corporate Trainer/Consultant & Evangelist Conducted more than 450+ workshops on SQL Server & BI for top notch IT companies world wide Microsoft MVP for SQL Server Speaker at TechED India, TechED US & TechEDEurope Speaking at SQLBITs this March in London Technical Reviewer/SME – MSL courses & certifications on SQL Server Founder & President – SQLServerGeeks.com

  3. Locking Myths debunked • Lock escalation • Row/Page -> Table (default) or • Row/Page -> Partition (if table is partitioned and partition-level locking is enabled) • Never from Row -> Page • & Never from Partition -> Table • Update Locks • TRAN A is locking rec1. TranB wants to update rec1, rec2 & rec3. • TRANB will wait for an U lock on rec1, but will not lock rec2 & rec3 (thus increasing concurrency) • PAGE locks • Mysterious (watch the demo) 

  4. Continue your learning… Be a member - www.SQLServerGeeks.com www.FaceBook.com/SQLServerGeeks Twitter @SQLServerGeeks Presentation & Scripts uploaded on www.SQLServerGeeks.com/files

  5. Connect with Amit Bansal • www.AmitBansal.net • LinkedIN, FB, Twitter, GuestBook • Twitter: @A_Bansal • Join my network • Personal Site – http://www.amitbansal.net • LinkedIn – http://www.linkedin.com/in/AmitBansal2010 • Forum – www.FaceBook.com/groups/theSQLGeeks • FaceBook – http://www.facebook.com/people/Amit.R.Bansal • Twitter – http://www.twitter.com/A_Bansal • Blog – www.SQLServerGeeks.com

  6. Thank you  for suggestions, please email at admin@SQLServerGeeks.com

More Related