Latches Archives - SolarWinds

SQL Server Latch and Spinlock Extended Events

Learn which extended events are available for latches and spinlocks, and which you might want to collect.

How Inefficient SQL Statements in Oracle Cause Contention for Cache Buffers Chains Latches

Inefficient SQL statements are the main cause of Oracle cache buffers chains latch contentions and should be considered when performance tuning.

SQL Server Tempdb and Latch Contention

Use of SQL Server tempdb as temporary storage makes it likely to contain a disproportionate amount of creation and destruction of many small objects, which can lead to latch contention.

SQL Server Latch Waits

Some SQL Server latches can come into contention with one another. This is intended and necessary as part of the need to serialize access. However, as with locking, this does raise the prospect of blocking, and consequently latch waiting.

SQL Server Latch Types

There are hundreds of different types of SQL Server latches. Latch waits will occasionally show up in sys.dm_os_wait_stats, but you have to actively search for them.

SQL Server Contention Indicators

Higher than normal wait stats does not in and of itself indicate a contention problem. You should look for the proportion of wait stats compared to others, and compare this to the throughput being achieved.