October 29, 2008 at 11:24 pm
Hello -
Can someone help me on the below issue :
There is SQL2005 instance on a Development box and TEMPDB is placed on T drive - 30GB. Its grown to the tune of 30GB, consuming all the space on T drive and I have service request for space issue on T drive. There is no activity running on tempdb now but I am unable to shrink tempdb using dbcc shrinkdb at file level. I restarted the instance twice to resolve the issue but again tempdb grows to this volume after any heavy activity on tempdb. Almost no free space is available on T but users are able to run their development activity witout any issue. I noticed that internally lot of free is space is available in tempdb but not able to release it. When I execute sp_spaceused on tempdb, below output is there :
database_name database_size unallocated space
-------------- ---------------- ------------------
tempdb 30645.25 MB 30255.32 MB
reserved data index_size unused
------------- ----------- ------------- -------------
1336 KB 576 KB 640 KB 120 KB
which shows lot of unallocated space inside tempdb. Anyone having any idea how to release unallocated space to OS.
Thnx in advance.
Sunil
A.M.
MIS Deptt.
JCT Mills Ltd.
PHAGWARA
October 30, 2008 at 1:36 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic594096-146-1.aspx
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply