September 14, 2005 at 6:04 am
Short of restarting SQL Server how do I find the initial size of TEMPDB
September 14, 2005 at 6:22 am
I know it's early but (my upfront way of saying this may be crazy) but...
1. I know that tempdb is re-created everytime that SQL is restarted.
2. Doesn't it use model as a reference so it would be the same size?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
September 14, 2005 at 6:45 am
Nope, it doesn't inherit its size from MODEL.
Its default initial size is 8MB where as MODEL is 2MB.
If I do the following
1. Restart SQL Server
2. ALTER DATABASE TempdB MODIFY FILE (NAME=tempdev , SIZE=16MB)
3. Perform some action that causes TempDB to grow beyond 16Mb (a large sort will do it)
4. Restart the MSSQLSERVER service
TempDB resizes to 16Mb. Clearly it is getting that setting from somewhere but I don't know where!
September 14, 2005 at 9:37 am
The initial specifications for tempdb data and log are retained in table master.dbo.sysaltfiles.
select dbid, name, size as SizePages
, Size * 8 / 1024 as SizeMb
from sysaltfiles where dbid = 2
go
SQL = Scarcely Qualifies as a Language
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply