August 22, 2011 at 12:57 pm
I tried this also.....
DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE
DBCC SHRINKFILE('tempdev', 1000, NOTRUNCATE )
DBCC SHRINKFILE('tempdev', 1000 )
DBCC SHRINKFILE: Page 1:3376992 could not be moved because it is a work table page
August 22, 2011 at 1:01 pm
ESAT ERKEC (8/22/2011)
I tried this also.....DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE
DBCC SHRINKFILE('tempdev', 1000, NOTRUNCATE )
DBCC SHRINKFILE('tempdev', 1000 )
DBCC SHRINKFILE: Page 1:3376992 could not be moved because it is a work table page
tempdb gets recreated at startup - hard to find a reason to shrink it, tempdb is the size it is because of user databases activity.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 22, 2011 at 1:05 pm
It is production database and suddenly grow and i can t restart server
August 22, 2011 at 1:24 pm
Shrinking TempDB while it is use is not recommended and can cause problems. To shrink TempDB properly you need to completely quiesce the server
http://support.microsoft.com/kb/307487
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2011 at 1:26 pm
Oke but why i can not shirink temp db or how can i find the problem because it is 30 gb about now
August 22, 2011 at 1:30 pm
GilaMonster (8/22/2011)
To shrink TempDB properly you need to completely quiesce the server
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply