march, 2020

thu05mar9:00 AM10:00 AMI will speak at SQL Server ConferenceImprove performance with optimistic concurrency in Microsoft SQL Server9:00 AM - 10:00 AM CET darmstadtium Kongresscenter, Schlossgraben 1, 64283 Darmstadt, Germany



The default transaction isolation level of SQL Server is set to read committed, which eliminates particular 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 much 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.

Speaker for this event

  • Torsten Strauß

    Torsten Strauß

    MVP | MCSE | MCT

    Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. Torsten is the founder of and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups. Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.


    MVP | MCSE | MCT


(Thursday) 9:00 AM - 10:00 AM CET


darmstadtium Kongresscenter

Schlossgraben 1, 64283 Darmstadt, Germany