The deadlock is caused by different orderings of lock acquisition
muchanon
A later slide says that a perfect workload is where the locks are acquired in primary key order, but while this can fix deadlock problems, we still see a falloff in performance for high enough number of cores because thrashing is not eliminated.
The deadlock is caused by different orderings of lock acquisition
A later slide says that a perfect workload is where the locks are acquired in primary key order, but while this can fix deadlock problems, we still see a falloff in performance for high enough number of cores because thrashing is not eliminated.