On Microsoft SQL Server 2019, there is a lot of long temp tables TRUNCATE operations with time over 5..10 seconds.
Easy query like "TRUNCATE TABLE #tt22" can take over 15 seconds.
It's an intermittent problem, sometimes it disappears for a day after restarting the server .
What could be the reason?
UPD:
According to the latest performance measurements, long TRUNCATE operations are observed not only in temporary tables, but also in physical ones.
Asked by aqis
(21 rep)
Oct 3, 2022, 10:13 AM
Last activity: Apr 12, 2025, 03:13 AM
Last activity: Apr 12, 2025, 03:13 AM