Bob Pusateri
bobpusateri.com
Bob Pusateri is a Microsoft Certified Master and Microsoft Data Platform MVP who has been working with SQL Server for over 15 years. His interests involve performance tuning, Very Large Databases, and cloud architecture.
SQLBits 2024
Maximizing Database Performance With Isolation Levels
How does a database handle multiple processes all trying to read and write at the same time? The answer is transaction isolation levels, and Azure SQL Database and SQL Server offer several to choose from depending on your workload's needs. Attend this session to understand how they work, why they matter, and how proper concurrency settings can result in great performance improvements!
Databases have long been able to process queries from multiple users concurrently, but managing processes that can lock and block each other is no simple feat! This session will explain the isolation levels supported by Azure SQL Database and SQL Server, how they work, and how they differ. Multiple demonstrations will also show how changing isolation levels can affect not only query performance, but also determine which rows are (or are not) returned in the result set. Attendees will learn how to choose the optimal isolation level for a workload, and will see how simple it can be to improve performance with the proper isolation setting.
Whether in the cloud or on premises, understanding database isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address. Attend this session and gain senior-level skills on how to maximize your database's ability to handle concurrent operations!
Whether in the cloud or on premises, understanding database isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address. Attend this session and gain senior-level skills on how to maximize your database's ability to handle concurrent operations!