We have SQL 2008 instances on Windows 2008 OS, one of our production db has 4 publications and configured with 1 distributor and around 130 subscriptions configured on the 4 publications. Subscriptions are scheduled to run every 1 minute (as per App team request). On the replication monitor when trying to connect the publisher takes long time (around 10+ minutes) to refresh (I mean to list all the publications), every time takes the same time.
Is this delay expected because of the 130 subscriptions or something wrong in the settings?
Below is the settings.
4 Publications
Pub1 - 60 Subscriptions
Pub2 - 6 Subscriptions
Pub3 - 60 Subscriptions
Pub4 - 8 Subscriptions
1 Distributor serving for all the above subscriptions.
Please guide.