This post is based on Tara’s recent blog post over on Brent Ozar’s site:
and another:
Basically, a query is killing your tempDB. It would be great if we could just kill that SPID but this will also work. The code is:
|
1 |
DBCC FREEPROCCACHE; |
You can also try:
|
1 |
DBCC FREESYSTEMCACHE ('ALL'); |
and also:
|
1 2 |
DBCC SHRINKFILE (N'tempdev', NOTRUNCATE) -- Move (defragment sort of) allocated pages from EOF to BOF DBCC SHRINKFILE (N'tempdev' , 0, TRUNCATEONLY) -- Drop unallocated pages from EOF |
Views – 2299