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 Latch waits are one of the possible causes of slowness in SQL Server which can limit the throughput (tps) of OLTP application. Whenever we experience slowness in performance of… Continue reading Troubleshooting Non-Buffer Latch Contention: LATCH_XX
Tag: sql performance
What Perfmon counters should I monitor and what each of them mean?
Off Late, I am not able to update this blog as frequently as I would have liked to as I was some of personal work and lot of professional work. However most customers ask me this question on what performance counters do we need to monitor in order to troubleshoot performance issues with SQL Server… Continue reading What Perfmon counters should I monitor and what each of them mean?