october, 2020
Abstract
Abstract
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.
MVP | MCSE | MCT
Organizer
PASS SQL Saturdaycommunityteam@pass.org