Assertion: latch | /r/Causes | the contention
Facets:
Source sentences:
text: The key difference between LatchProf and other latch contention troubleshooting approaches are: 1) LatchProf shows you who is holding the latches (who is causing the contention) instead of just showing who's waiting for them 2) LatchProf shows you which actual sessions are holding the latches (not some system-wide ambiguous metrics), thus you can simply focus on the troublemaking sessions and see what are they doing 3) LatchProf shows you which SQL statement caused taking the taking of the latch, thus narrowing down the root cause even more Having established the basics, let's now dig a bit deeper with another example.