October 28, 2008 at 12:41 am
Hi,
my tempdb is not getting free after server restart also.Here are the details.
Before restart
Tot Size unallocated
tempdb 15000.00 MB 5499.19 MB
After restart
tempdb 15000.00 MB 5499.19 MB
Even after increasing the size by 2000 MB it is showing 17000 Mb in total size and unallocated size as 5499.19.
any help is appreciated.
Rgds,
Gopi
October 28, 2008 at 2:35 am
I suggest the first thing to check is to see if anyone has created something large in Model, which will then be automatically created in tempdb. Crerating a new empty db would be an easy way to check for that. Alternatively are there any startup scripts that are creating anything in tempdb at servioce start time?
Mike John
October 28, 2008 at 11:15 pm
Hi,
Nothing large has been created in model .It's a Production Server.and there are also no start up scripts .
thanks for your response.and hope the response again.
October 30, 2008 at 8:11 am
Hi,
Maybe I am missing something obvious here but it sounds like someone changed the initial file size for tempdb. In SSMS, right-click tempdb in Object Explorer and choose Properties.
Check the Initial size on the Files page, it sounds like it has been set to 15 MB - probably because someone spotted that your tempdb needs more space than the default 8 MB.
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
October 31, 2008 at 4:45 pm
When using sp_spaceused, database_size includes the log file size but the free space in the log file is not included in unallocated_space.
My guess is you have a 9500MB log file and a 5500MB datafile for tempdb.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply