what is SQL server latch? does is it slow down the performance of sql server

Antony Maxwin 276 Reputation points

what is sql server latch, does it slow down the performance of sql server?
i am attaching screenshot from one sql server and in this server the latch is high, does it affect the performance of server. how latch became high?134657-sql.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,864 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,906 Reputation points Microsoft Vendor

    Hi AntonyMaxwin-4065,

    Latches are lightweight synchronization primitives that are used by the SQL Server engine to guarantee consistency of in-memory structures including: index, data pages, and internal structures, such as non-leaf pages in a B-Tree. Latch contention occurs when multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. Please refer to this doc to diagnose and resolve latch contention, which might be helpful.
    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful