SQLServer

Introduction to Latches in SQL Server

In today’s blog posting I want to talk about a more advanced, low-level synchronization object used by SQL Server: Latches. A latch is a lightweight synchronization object used by the Storage Engine of SQL Server to protect internal memory structures that can’t be accessed in a true multi-threaded fashion. In the first part of the …

Introduction to Latches in SQL Server + read more

SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium

I’m very happy to announce today that I also run my famous SQL Server Performance Tuning & Troubleshooting Workshop from November 24 – 28 in Antwerpen/Belgium. Here’s the outline of the workshop: “Are you an SQL Server DBA or developer and you have encountered performance related problems with SQL Server? Yesterday your SQL Server was …

SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium + read more