Thread: what is the impact of Database size on Performemce

I need some information to understand what is the impact of Database size on
the performemce.


Few questions :

1. Is there any impact?
2. Does one very large table impact the performence of the the whole DB,
meaning the overall performence and access the other tables.
3. What are the ways to reduce the impact of the DB size  on the DB
performence


I will apreciate help in regards .


Thanks Avner

> 1. Is there any impact?
> 2. Does one very large table impact the performence of the the whole DB,
> meaning the overall performence and access the other tables.
> 3. What are the ways to reduce the impact of the DB size  on the DB
> performence

I've run into 2 problems w/ very large DB.
A) Backups.  I have a 50G DB.  I backup to file then delete
yesterday's backup file (I have another process which transfers the
backup file to tape).  So I have a 50G backup file and I need another
50G freespace, to run my backup process.

B) Reindexing.  On any given day maybe 5% (max) of new data is added
to my DB.  But DBCC reindex has to work on all the indexes.  So DBCC
reindex takes 3 hours a night.  Yuck.

Maybe there is a better way.  But I try to keep each database as small
as possible.