"Brandon" <Brandon@discussions.microsoft.com> wrote in message
news:CD91CFF4-55DB-440A-8FE9-93CEFD428523@microsoft.com...
> Does anybody know the best way to query the system tables to count
> reinitializations that have occurred? We are beginning to have some
> performance issues with our replication setup, and we are trying to find
> some
> trends (we have been archiving off the data from the system tables, so we
> have months worth of replication data that would otherwise have been
> cleaned
> up after the retention period).
>
> We currently have roughly 400 subscribers syncing a couple-dozen tables
> from
> a SQL 2K5 server through a filtered merge publication, and an unfiltered
> download-only publication. Each device gets maybe 4000 rows tops, and
> syncs
> at least once an hour if not more frequently. Early on a reinit on both
> subscriptons would complete in 30 seconds, but these days we'll push 10 to
> 20
> minutes, and cause all kinds of timeouts in the other pieces of code that
> access this database...