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