SQL Friday #11: Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”
| Date: | 2020-08-14 |
| Time: | 12:00 CEST |
| How to attend: | Already finished |
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.
