SQL Friday #11: Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”

Online Microsoft Data Platform Lunch Sessions

SQL Friday #11: Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”

2020-06-30 Past SQL Friday Sessions 0
Time:12:00 CEST
How to attend:Already finished
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”

The default transaction isolation level of SQL Server is set to read committed, which eliminates certain read phenomena, but can also affect concurrency and overall read performance.

SQL Server also offers two optimistic transaction isolation levels where a transaction does not acquire a lock when reading data, which reduces the probability of blocks and therefore leads to significantly better reading performance in a busy database.

In this session (level 300), you will learn how to increase the reading performance in a database simply by changing the transaction isolation level to snapshot isolation. You will also understand how SQL Server implements this function internally and what disadvantages it has.

About Torsten

Torsten Strauß (MCT, MCSE Data Platform, MCSE Data Management and Analytics) has been working with Microsoft SQL Server since the turn of the millennium.

He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as CEO of inside-sqlserver.

Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups and has been recognized as a Microsoft Data Platform MVP since July 2018.