OPERATIONAL DEFECT DATABASE
...
...
Assume that you are creating or dropping large number of temporary tables in Microsoft SQL Server 2016 or 2017. Certain application workload invalidates the cache of temporary tables. For example, you are creating temporary tables and then creating ALTER TABLE or CREATE INDEX which will invalidate thecache of temporary tables. In this situation, you may experience the following issues: Data Definition Language (DDL) contention in the tempdb on system catalog sysobjvalues and large number of sessions that are waiting on the PAGELATCH_EX, PAGELATCH_SH and PAGELATCH_UP wait type occur. This situation also affects the workload when the entries count is more than 4,000. However, this may vary, depending on the workload. See the following example: SELECT [name], [type], [entries_count], [entries_in_use_count] FROM sys.dm_os_memory_cache_counters WHERE [type] = N'CACHESTORE_TEMPTABLES' name type entries_count entries_in_use_count Temporary Tables & Table Variables CACHESTORE_TEMPTABLES <count> <count>
This issue is fixed in the following cumulative updates for SQL Server: Cumulative Update 5 for SQL Server 2017 Cumulative update 8 for SQL Server 2016 SP1
The included affected builds are considered potentially affected, based on their release chronology relative to the identified fix.
Click on a version to see all relevant bugs
Microsoft SQL Server Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
