Very Computer

Hi all,

We set up a replication to have transactional replication
on 585 tables. We have an excellent server - an IBM
Nefinity x440 with 4 CPUs and 8GB of memory.

Are there any concerns with replicating so many tables?
How much impact will it have if we use the x440 server as
the production server as well as the distributor?

Thanks, Anna

irrespective of the hardware resource on your production server, for these
many tables you definitely want to have a separate distribution server.
There is a lot of history info to be managed. Also for every combination of
publication\subscriber there will be a distribution agent (for transactional
replication). These agents will take up resources and they run on
distribution server. Also you might want to consider using pull subscription
if you can. In that case the distribution agent will physically run on the
subscriber so that subscriber resources will be used.

The only way to know if a particular hardware is enough for you topology is
to do a test.

rgill

Quote:> Hi all,

> We set up a replication to have transactional replication
> on 585 tables. We have an excellent server - an IBM
> Nefinity x440 with 4 CPUs and 8GB of memory.

> Are there any concerns with replicating so many tables?
> How much impact will it have if we use the x440 server as
> the production server as well as the distributor?

> Thanks, Anna

Transactional replication performance mainly depends on the amount of data
and volume of transactions. Please take a look at the performance
whitepaper mentioned in Q323046

Thanks
Gopal Ashok
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.