Tuesday, June 25, 2013

Taking the Optimistic Approach. Say goodbye to deadlocks!

“I've received a lot of support from fellow pessimists. I've considered starting a support group, but nobody thinks it will help.” --  https://twitter.com/raganwald/status/273118149073846272

The following caught my attention on SQL Server 2014 announcement:

“Taking the Optimistic Approach

The Hekaton team also found that multi-version concurrency control (MVCC) proved robust in scenarios with higher workloads and higher contention”

MVCC greatly reduces deadlocks. Let’s hope SQL Server team make MVCC turned on by default on SQL Server 2014 like what Entity Framework team did on its EF6’s code first’s database creation:

Default transaction isolation level is changed to READ_COMMITTED_SNAPSHOT for databases created using Code First, potentially allowing for more scalability and fewer deadlocks. -- http://entityframework.codeplex.com/wikipage?title=specs

Happy Computing! 

No comments:

Post a Comment