A couple of months back I published my version of SQL Server’s Lock Compatibility Matrix under the post “Fancy a decent Compatibility Matrix?” since the one provided by MSDN is really very poorly designed and difficult for the average Joe to understand.This is one reason I believe that lock compatibility is a very misunderstood subject.
One thing that has bothered me about my version from the very beginning was the use of green and red to respectively indicate compatible or incompatible locks. The reason this has bothered me from the offset is because I was aware that those two colours could be a very big problem for colour blind DBAs. However, for me they really DID look great together and “told the story” of the compatibility between the locks without even needing words -for every non colour blind person understands and sees clearly the concept of GREEN -> GO (lock grant), RED -> STOP (lock wait).
Well the time has finally come to redress that issue and provide a matrix that is (hopefully) colour blind friendly. I have made the following changes :-
- Lightened the green so that it wasn’t so garish and made it slightly easier on the eye.
- Substituted the garish red for a deep blue. The reason I chose blue was for the “coldness” to hopefully still “tell the story” through colours.
- Minor changes to the Legends (for purely indulgent reasons).
- Changed the legend descriptions for green and red to “compatible” and “incompatible” since I believe they are better than “No Conflict” and “Conflict”.
I also have several MAJOR changes to the chart scheduled at some point in the future such as changing the cell sizes to squares -which should overcome the perceived distortion that the eye interprets when the chart is viewed at the wrong sizes. In order to accommodate that change I also need to make better use of the white space and I know how I will do it, but as everything in life it will take some time!
Without further ado, the Compatibility Matrix 1.2 can be downloaded via here. Enjoy!
p.s. Your comments or requests are very welcome…