LATCH_EX:
https://www.sqlskills.com/help/waits/latch_ex/
This wait type occurs when a thread is waiting for access to a non-page data structure so that it can modify the data structure.
LATCH_SH:
https://www.sqlskills.com/help/waits/latch_sh/
This wait type occurs when a thread is waiting for access to a non-page data structure so that it can read the data structure.
如何查看阻塞类型: