Database size discrepancy - replicated sites
Hoping someone can point me in the right direction here. Here's a high level view of the environment I'm dealing with:
- Large environment with 10000+ clients.
- Single domain
- Two sites with replication enabled.
- Two SEPM servers. One primary and a standby (standby does not service clients unless there is a failure).
- Single SQL database
- One primary SEPM server.
- Single SQL database.
The two primary SEPM servers are load balanced for clients, and are servicing roughly half each.
Here's my concern/issue. I've noticed the database for Site 1 (which has two SEPMs) is around 50GB, while the second site the database is around 90GB. Looking at the tables I can see that there are some differences, but the size difference seems to be spread amongst the whole database, so there's not any one table that appears to be bloated.
A couple of things I've noted so far:
- Content is being replicated
- Auto-replicate is enabled.
Are these two things likely to cause issues in terms of DB size? I know they can cause problems with replication itself but I'm not having any problems with replication.
Any other ideas?
I'm yet to log a case but I will if need be. Just after some advice first so I can attempt to self diagnose.