db

Can anyone guide me to a good site that can help me
with "predicting database growth".. thanxsPredicting database growth is going to be specific to what data you are goin
g to
be storing and more of a business domain question. If you know the type of d
ata
you are going to be storing and the types of queries you will need indexes f
or
etc, it should be fairly easy to get a rough estimate. For a working system
with
no projected fluctuations the past full database backups can be a good
predictor. If you have an idea of the type and amount of data then post it a
nd
I'm sure we can help, otherwise that isn't going to be a SQL Server question
.
If you are having problems with transaction log files, or databases shrinkin
g
that may be another problem altogehter.
cs wrote:
> Can anyone guide me to a good site that can help me
> with "predicting database growth".. thanxs|||cs,
These articles might help:
Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips
http://msdn.microsoft.com/library/d...r />
geeng.asp
SQL Server 2000 Operations Guide: Capacity and Storage Management
http://www.microsoft.com/technet/pr...in/sqlops6.mspx
SQL Server Capacity Planning
http://www.nesql.org/downloads/SQL%...%20Planning.ppt
PERFORMANCE MANAGEMENT AND CAPACITY PLANNING FOR MICROSOFT SQL SERVER
http://www.metron.co.uk/reference/t...ents/tech18.pdf
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
cs wrote:

> Can anyone guide me to a good site that can help me
> with "predicting database growth".. thanxs