Diagnose and resolve latch contention on SQL Server

This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.

As the number of CPU cores on servers continues to increase, the associated increase in concurrency can introduce contention points on data structures that must be accessed in a serial fashion within the database engine. This is especially true for high throughput/high concurrency transaction processing (OLTP) workloads. There are a number of tools, techniques, and ways to approach these challenges as well as practices that can be followed in designing applications which may help to avoid them altogether. This article will discuss a particular type of contention on data structures that use spinlocks to serialize access to these data structures.

Link to PDF : Diagnose and resolve latch contention on SQL Server

Related Posts:

2008R2Internals

SQL Server 2008 R2, like its predecessors, is more than a database engine. It is a
collectio

Deeper insights across data with SQL Server 2016

The growing volume, velocity, diversity, and locations of enterprise data make it increasingly ch

Microsoft SQL Server 2019

Microsoft SQL Server 2019 powers your organization by providing a data hub that you can use to ac