Optimistic Concurrency Internals

Interested in Optimistic concurrency but not really sure how it works? Then this session is for you.  Optimistic concurrency was introduced in SQL 2005 but it is rarely spoken about or well understood.  However, you can buck that trend by coming along to this session where you will learn about how you can be Optimistic DBA. Now there's an oxymoron if ever there was one....

Session will cover the following

  • Architecture of Optimistic Concurrency
  • Limitations and restrictions
  • Optimistic Isolation Levels
  • Row Versioning and the Version Store
  • Impacts in TempDB
  • Taking out the trash - Garbage collection
  • Monitoring Row Versioning
Presented by James Rowland-Jones at SQLBits V
Tags DBA
  • Downloads
    Slide deck available Slide Deck 293 KB
    Video available WMV Video 229 MB
  • SpeakerBIO
    James Rowland-Jones is a Principal Consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server Parallel Data Warehouse and Hadoop ecosystems. James is a keen advocate for the SQL Server community; both internationally and in the UK. He currently serves on the Board of Directors for PASS and sits on the organising committee for SQLBits - Europe's largest event for the Microsoft Data Platform. James has been awarded Microsoft’s MVP accreditation since 2008 for his services to the community.


    You can find James on twitter @jrowlandjones or www.linkedin.com
  • Video