Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-03-25 : 14:31:35
|
| Hi, Even though system databases don't occupy a lot of disk space or do not grow rapidly, they are considered in estimating the disk space required because when we add new users, objects, constraints or maintenance plans etc., the system tables have new rows in them. So in the process of estimating the projected growth for system tables in next 5 years when I will have atleast 10,000 users (currently 100), i did something like this. Q1. But is there any possibility that the system db like model will change in future due to any db server upgrade/version change or service pack application?I might want to add this to Misc/unknown requirements column!db intial 1 yr increase 5 yrs increase misc total(mdf+ldf) (unknown) increase-------------------------------------------------------------------master 12.25 5.47 27.35 (5.47*5) 5 32.35model 1.5 0 1.5 2? 3.5 ?msdb 14.25 20.05 100.25 (5*100.25) 15 115.25temp 8.5 ? ? ? ?-------------------------------------------------------------------Q2. Is this approach any good?Q3. Should I be doing any extra calculations as the number of users will grow drastically in next 5 yrs?Thanks,Sarat. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-25 : 14:37:48
|
| I don't ever calculate the estimated size of the system databases. These databases will remain rather small as compared to the user databases. Even if they occupy about 1GB of space, that really isn't a lot of space considering how big disks are these days. Everything that I have just said excludes tempdb. Tempdb can get pretty big sometimes, but it is pretty hard to estimate its potential size. The model database should not change with future upgrades, service packs, etc... When I say should not change, it will probably change with future upgrades, but it still most likely won't be bigger than 10MB.Tara |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-03-26 : 11:14:03
|
| I would agree with Tara on that. If your system dbs are larger than your user dbs, you are better off using MS Access.One thing though about tempdb. you must observe it regularly. say if it ends up being 3 GB after your nightly processes or monthly ones, don't shrink it or(restart the server to shrink it), make sure that it is logically big(increase its size.)This will give you a better performance boost.... |
|
|
|
|
|
|
|
|
System Databases Growth