December 20th, 2004, 10:17 AM
|
|
Contributing User
|
|
Join Date: Jul 2004
Posts: 65
Time spent in forums: 37 m 32 sec
Reputation Power: 5
|
|
|
Capacity Planning
Hi all,
I was just wondering how you all go about doing your capacity planning on databases. I'm about to work this out and so far I've been told as a rough guide to do:
(total col length x num rows) + (total index col length x num index rows) + 10% contingency.
How does this sound? And most importantly, how do I size for the system created tables like sysfiles etc, and also views and stored procs? Any definitive methods?
Many many thanks,
Paula
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
