Performance Tuning with Optimistic Concurrency - Torsten Strauss
Details
Before the summer holidays, we will have the honor of listening to a session delivered by an international speaker, a performance tuning expert.
As in the last few months, the session will be online. All you have to do is sit back, relax and join us. The link for the session will be sent the day before.
Performance Tuning with Optimistic Concurrency - Torsten Strauss
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 the speaker
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 was recognized as a Microsoft Data Platform MVP in July 2018.
