FIX: Big PAGELATCH_EX contentions when you remove temporary objects in SQL Server

Applies to: SQL Server 2017 on Windows

Symptoms


Assume that you remove temporary objects such as temporary tables, table variables, or table-valued parameters in SQL Server. In this case, very large PAGELATCH_EX contentions may occur on the sys.sysobjvalues system base table.

Resolution


This fix is included in Cumulative Update 5 for SQL Server 2017.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.