SQL Server Performance

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

Discussion in 'SQL Server 2005 General DBA Questions' started by carpi751, Oct 17, 2007.

  1. carpi751 New Member

    Hi,
    I tried to shrink tempdb but I got the following message :DBCC SHRINKFILE: Page 1:569904 could not be moved because it is a work table page.
    tempdb have a lot of free pages, but SQL2K5 doesn't use it when new objects are create; the tempdb keeps grow and run out of space.
    My solution is to stop/start the dataserver and execute SHRINKFILE again; but it's not a very serious solution! Do you have any idea ?
    Regards;
    Stephane
  2. techbabu303 New Member

    For tempdb or system database shrink operations are not recommended.
    Have you observed incease size through out the 24 hour monitor if yes then probabaly you can allocate more space to Tempdb using alter database.
    Regards
    Sat
  3. satya Moderator

Share This Page