Latches

Esat Erkec
Measuring disk latency with Perfmon for SQL Server troubleshooting

SQL Server troubleshooting: Disk I/O problems

August 17, 2020 by

In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting. The storage subsystem is one of the significant performance factors for the databases. Detecting and identifying I/O problems in SQL Server can be a tough task for the database administrators (DBAs). Generally, the underlying reasons for the I/O problems can be:

Read more »
Bhavesh Patel

How to identify and resolve Hot latches in SQL Server

November 7, 2017 by

Description

In SQL Server, internal latch architecture protects memory during SQL operations. It ensures the consistency of memory structures with read and write operation on pages. Rudimentarily, it has two classes, buffer latches, and non-buffer latches which perform lightweight synchronization in the SQL Engine.

Read more »