replication server space estimates 
Author Message
 replication server space estimates

Hi,

We are setting up a simple replication system (one primary database and
one warm standby.)  The docs mention as minimum sizes 10MB for the RSSD
and 10MB for the log and 20MB for the stable queues.

How reliable are these estimates?  They seem kind of small.  Does the
rep server really not use that mush disk?  Anybody know some simple
guidelines for estimatating replication space requirements based on
aprimary database size?

Thanks,

Alan Hobesh



Tue, 29 Feb 2000 03:00:00 GMT
 replication server space estimates

Quote:

>Hi,
>We are setting up a simple replication system (one primary database and
>one warm standby.)  The docs mention as minimum sizes 10MB for the RSSD
>and 10MB for the log and 20MB for the stable queues.
>How reliable are these estimates?  They seem kind of small.  Does the
>rep server really not use that mush disk?  Anybody know some simple
>guidelines for estimatating replication space requirements based on
>aprimary database size?
>Thanks,
>Alan Hobesh

Hi:

These figures are the bare minimum requirements for R/S install to
work. Realistically, the RSSD should be at least 50MB for data  and
20MB for log. Depending on the level of transactions on the database
and how much downtime you can tolerate, stable device(s) should be
large enough to keep the replicated transactions in those queues
in case the standby DB is down. I would allocate at least 100 MB
for stable devices to start with.

Good luck



Tue, 29 Feb 2000 03:00:00 GMT
 replication server space estimates

Hi,

The minimum size is for small configuration. If you don't have that many
rep definitions and subscriptions, perhaps a small RSSD is good enough.

20MB for the stable queue is indeed small, but then again the size of the
stable queue depends on the transaction volume, network traffic, etc. The
size of the database has very little to do with the stable queue size
though.

 There is a section in one of the rep server doc (design guide?) which
talks about sizing the stable queue and explains all the different factors
you need to consider.

For me, I normally just give the stable queue a reasonable size to start
with (say 100MB) and monitor the growth. You can also estimate how fast
your primary database transaction log fills up by bringing down the DSI to
the replicated database.

Raymond



Quote:
> Hi,

> We are setting up a simple replication system (one primary database and
> one warm standby.)  The docs mention as minimum sizes 10MB for the RSSD
> and 10MB for the log and 20MB for the stable queues.

> How reliable are these estimates?  They seem kind of small.  Does the
> rep server really not use that mush disk?  Anybody know some simple
> guidelines for estimatating replication space requirements based on
> aprimary database size?

> Thanks,

> Alan Hobesh



Wed, 01 Mar 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Estimating Disk Space for Cube

2. Estimating Space Requirements for Processing a Cube

3. How to estimate the space that will be use by a table in SQL2000

4. Estimate table space (MS 6.5)

5. Estimating disk space needed...how???

6. Estimate space

7. Estimating how much disk space 10K rows will occupy

8. Estimating the space consumption of image data

9. Estimating space requirements for tables/indexes

10. Disk Space Estimate

11. Estimating space req'd for disk dumps?

12. How to estimate disk space requirements?


 
Powered by phpBB® Forum Software