TempDB won't shrink!! |
|
I have a lot of tempdb issues at my current shop. Small drives with RCSI enabled and lots of open snapshot transactions means lots of version store bloat.
This works great.
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE ('ALL')
DBCC SHRINKFILE(TEMPDEV,1024)
Please check the Microsoft documentation to see what you are clearing. It can, cause some issues.
https://msdn.microsoft.com/en-us/library/ms178529.aspx
This works great.
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE ('ALL')
DBCC SHRINKFILE(TEMPDEV,1024)
Please check the Microsoft documentation to see what you are clearing. It can, cause some issues.
https://msdn.microsoft.com/en-us/library/ms178529.aspx