Community

Performance Impact: The Potential Cost of Read_Committed_Snapshot

(Linchi Shea) In response to my previous blog post–Performance Impact: Setting a Database to Read Only, Shailesh Khanal mentioned that he observed significant performance degradation from READ COMMITTED SNAPSHOT OFF to ON for a read-only workload. This is counter intuitive since there is nothing in

Read More - Register for Free Membership