March 11, 2009 at 10:33 pm
March 12, 2009 at 2:21 am
You can find some info here: http://msdn.microsoft.com/en-us/library/ms178028(SQL.90).aspx - however they are not listing the "default sizes". Try to monitor the system databases sizes after a fresh install.
March 12, 2009 at 4:00 am
Hi
There sizes is only some MBs but it will depend on the things you are doin'. Especially the tempdb may become huge while working with the server.
Why does this sizes matter to you?
Greets
Flo
March 12, 2009 at 5:37 am
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2009 at 5:51 am
Grant Fritchey (3/12/2009)
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
Is this true for the system databases also? Does any "model" exist when the system databases are created? I'm sorry if I'm missing something...
March 12, 2009 at 5:56 am
I think these system db (master, msdb, model, and resourcedb) are all pre-packaged by Microsoft so they don't get created from scratch. The model db is used as a template for all user databases that get created and the system database tempdb. Because tempdb get recreated everytime you restart SQL Server. Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:00 am
dmoldovan (3/12/2009)
Grant Fritchey (3/12/2009)
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.Is this true for the system databases also? Does any "model" exist when the system databases are created? I'm sorry if I'm missing something...
Mohit is right about tempdb, but the other three system databases... I don't know. I suspect not. You shouldn't normally need to "create" master or msdb or the other one whose name escapes me at the moment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply