We are using SQL 2008 Transactional replication to replicate data from our production database to our reporting database.
We recently created a new 'Global' database that we would like to have replicated to our various production databases around the world. The number of tables in this database is small (less than 30) and the maximum number of rows in any given table might be a couple thousand. We would not be adding tables and data to this Global database very often.
Our DBA said that the "fixed overhead of replication is disproportional to the amount of data that would be actually replicated". I know a little about transactional replication but not enough to refute this argument. Is there really a great deal of 'fixed overhead' with replication, such that if we're not replicating much data, there is still significant resource usage?