Community

SQL SERVER – How to Know Transaction Isolation Level for Each Session?

(Pinal Dave) During recent, Comprehensive Database Performance Health Check, I had a very interesting scenario. I was hired by a customer to identify their system’s unexpected performance bottlenecks. I do these for a living so I am usually pretty comfortable.