November 2020 – Meeting

Session: Matters of Concurrency

Speaker: Louis Davidson (Bio)

OLTP databases can be constantly written to and even reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, and even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits

This will be a virtual meeting. Please register at https://www.meetup.com/Hampton-Roads-SQL-Server-User-Group/events/274077440/

This entry was posted in Meetings. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *