Maximize SQL Server Performance with Read Committed Snapshot Isolation

Data Engineers in Toronto May 2026 Semimonthly Meeting

Topic: Maximize SQL Server Performance with Read Committed Snapshot Isolation

Abstract:
Are your read operations frequently blocked by write operations? Do you want to retrieve data without relying on NOLOCK?

Then it's time to switch to Read Committed Snapshot Isolation (RCSI).

In this session, I’ll explain what RCSI is, how it works, and how it differs from the default Read Committed Isolation level. I’ll demonstrate how version store comes into play with this isolation level and when it can overwhelm TempDB if not managed properly. Finally, I’ll discuss how to manage the implications of enabling RCSI.

By the end of this session, you'll have a clear understanding of RCSI and when to implement it in your environment for improved concurrency and performance.

Speaker: Haripriya Naidu, Lead SQL Server Database Administrator

Speaker Profile:
Haripriya Naidu has been working as a SQL Server Database Administrator for 11 years in Boston, MA. She is passionate about databases and enjoys diving into SQL Server engine internals and optimizing performance. She is an AWS Certified Solutions Associate and won "Rookie of the Year" Award at work in 2024 for outstanding performance and "Bookworm of the Year" Award at work in 2025 for continuously learning and sharing knowledge with the team.
She recently started her speaking journey with New Stars of Data and spoke at SQL Saturdays Boston, Albany and San Diego and PASS Summit 2024.

The meeting is over Microsoft Teams, and the joining link is https://teams.microsoft.com/l/meetup-join/19%3ameeting_NzZkYWIyOTAtODk1MC00MjVmLWJlNjUtNTRiODZmODA2Zjdh%40thread.v2/0?context=%7b%22Tid%22%3a%22bd9727e8-f539-4c76-983c-6c30130c0bee%22%2c%22Oid%22%3a%229e8d5a64-e773-4ca2-90f6-9a266129171e%22%7d

See you at the meeting!