TempDB Transaction log not releasing space
1
vote
1
answer
2366
views
Every time I complete a transaction in tempdb, the temp log grows, however the log doesn't seem to release the space once the transaction has completed.The log usage percent is 43.4% but seems to increase in around 4% increments.
When I look for open transactions (
sys.dm_exec_sessions
), there are none. Yet the log_reuse_wait_desc
in sys.databases
shows 'ACTIVE_TRANSACTION'. When I query the sys.dm_tran_active_transactions
DMV, it shows only work table.
I'm unsure of how I can release this space from the tempdb transaction log.
I've just run a manual checkpoint and that seems to free up the space so I'm not sure as to why the space isn't being freed up on it's own
Asked by Krishnp92
(19 rep)
Aug 8, 2019, 12:02 PM
Last activity: Aug 8, 2019, 01:56 PM
Last activity: Aug 8, 2019, 01:56 PM