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
James is a SQL Server Consultant and Microsoft MVP. His focus and passion is to architect and deliver highly scalable database systems that are creative,simple and elegant in their design. He has worked for some of the worlds largest institutions and been responsible for project delivery across EMEA. James has worked on both OLTP and BI/data warehouse engagements and latterly has been spending a lot of time working on SQL Server reference architectures and appliances including Fast Track and PDW.
James is a keen advocate for the SQL Server community both internationally and here in the UK. He is a member of the SQLBits Organising Committee and co-founder of SQLSocial.com. Recently James was appointed as a Board Advisor to PASS. He is charged with providing an international perspective to the board across a wide variety of matters but primarily to assist the PASS community grow internationally.
You can find James on twitter @jrowlandjones
- Session Files Explorer
The network name cannot be found.