tempdb: DBCC SHRINKFILE: Page could not be moved because it is a work table page.

If you dont mind losing all your cached query plans try the following

DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.

DBCC FREESYSTEMCACHE (‘ALL’)

I have not needed to follow up with the following command but apparently it could help

DBCC FREEPROCCACHE

After killing all user sessions and issueing freesystemcache all I was able to shrink tempdb

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: