db

Can anyone guide me to a good site that can help me
with "predicting database growth".. thanxs
Predicting database growth is going to be specific to what data you are going to
be storing and more of a business domain question. If you know the type of data
you are going to be storing and the types of queries you will need indexes for
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 and
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 shrinking
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/de...storageeng.asp
SQL Server 2000 Operations Guide: Capacity and Storage Management
http://www.microsoft.com/technet/pro...n/sqlops6.mspx
SQL Server Capacity Planning
http://www.nesql.org/downloads/SQL%2...20Planning.ppt
PERFORMANCE MANAGEMENT AND CAPACITY PLANNING FOR MICROSOFT SQL SERVER
http://www.metron.co.uk/reference/te...nts/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

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 going to
be storing and more of a business domain question. If you know the type of data
you are going to be storing and the types of queries you will need indexes for
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 and
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 shrinking
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/default.asp?url=/library/en-us/dnsql7/html/storageeng.asp
SQL Server 2000 Operations Guide: Capacity and Storage Management
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx
SQL Server Capacity Planning
http://www.nesql.org/downloads/SQL%20Server%207%20Capacity%20Planning.ppt
PERFORMANCE MANAGEMENT AND CAPACITY PLANNING FOR MICROSOFT SQL SERVER
http://www.metron.co.uk/reference/technical/documents/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

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