Behold! A Wild Latch-Convoy Problem Appears!
The "Last Page Insert Contention" in SQL Server, also known as "Latch Convoy Problem", also known as "PageLatchEx Contention" is one of...
top of page
Eitan Blumin
- Aug 30, 2022
- 3 min
What is not contained in contained Availability Groups
Contained Availability Groups is a new feature in SQL 2022 to synchronize server-level objects between replicas. But... What does it not do?
Guy Glantser
- Jun 25, 2022
- 2 min
How to Identify and Fix Tempdb Contention
Here is all you need to know about the two types of contention in tempdb...
Guy Glantser
- Mar 2, 2022
- 11 min
Five Reasons to Upgrade Your SQL Server
If you are using an old version of SQL Server, then you have some good reasons to upgrade. Here are five of them...
Guy Glantser
- Jan 4, 2022
- 3 min
The Complete Guide to Temporary Tables and Table Variables - Part 2
In this blog post I am going to focus on a performance comparison between temporary tables and table variables...
Guy Glantser
- Apr 8, 2021
- 5 min
The Complete Guide to Temporary Tables and Table Variables - Part 1
A lot has been said and written about table variables vs. temporary tables in SQL Server. Here is the complete guide...
bottom of page