November 24, 2005 at 1:56 am
Hello,
tempdev in my tempdb has an initial size of 15160576 KB with only 3 MB being used. Templog is empty. A restart of the server or a database shrink don't help. Does anyone know a solution?
November 24, 2005 at 2:44 am
It sounds like someone set the initial size of TEMPDB to 15GB so if you reboot it will get built at that level.
You can check this by running the following in SQL Query Analyser.
select name ,(size*8)/1024 from sysaltfiles where dbid=2
You can change the initial setting by running
ALTER DATABASE TempDB MODIFY FILE (Name=TempDev, SIZE=1024MB)
You should make sure that no-one is logged on and that your size is greater than the current usage of TEMPDB.
There is a thread somewhere that recommends that TEMPDB should have a file per CPU.
In my production environment TEMPDB consists of 4 x 4GB data files.
Then try restarting your server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply