Archive for April, 2015

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

April 18, 2015

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

Changing SSIS package program name

April 15, 2015

If you want to change the Program name for an ssis package you can do so in the connection string properties of the connection manager.

Open the connection manager, go to the ‘All’ page and update the Application Name property.

You might want to do this so to help assign the package to a resource workload group.