When you have one bad query (maybe you are missing a very important index), the performance of your whole database can go down. Transaction Isolation Levels – What?Įverytime when I’m on customer side, and troubleshooting crazy SQL Server problems (or performing SQL Server Health Checks), the root cause sometimes lies in the locking/blocking behavior of the database. So let’s get started by first laying out the foundation about Transaction Isolation Levels in SQL Server. Key Range Locks are specific to Serializable!?.I mainly want to talk about the following topics: In todays blog posting I want to talk about myths & misconceptions about the various Transaction Isolation Levels that exists in SQL Server.
