Hi:
Is there a limit on the number of subscribers for Transactional replication?. My question is how many maximum number of subscribers can we have in transactional replication?. How do I retrieve this information throug T-SQL (any DMVs or system tables?). Please let me know.
I am looking to know for both SQL 2005 as well as SQL 2000 and also if anyone can tell me if anything has changed in SQL 2005 for transactional replication that would be great.
Can anyone please let me know?.
Thank you
AK
There is no hard-coded limit, just what your hardware and workload can spare. we've tested 500 concurrent, but the hardware and workload will be much different that what you have, and is no indication or guarantee that you can achieve the same.|||Hi there,You can check the following article for new replication features and improvements.
http://msdn2.microsoft.com/en-us/library/ms170959.aspx
One of the performance enhancement feature is multi-stream subscription for tran replication.
Regards,
Gary
No comments:
Post a Comment