october, 2020

sat10oct1:00 PM2:00 PMI will speak at SQL Saturday SofiaPerformance Tuning with Optimistic Concurrency in Microsoft SQL Server1:00 PM - 2:00 PM CEST SQL Saturday Sofia



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, 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 inside-sqlserver.com 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.

    URL https://inside-sqlserver.com/

    MVP | MCSE | MCT


PASS SQL Saturdaycommunityteam@pass.org


(Saturday) 1:00 PM - 2:00 PM CEST