-
sql server replication with multiple distribution dbs (load balancer)
Hi
I Have an instance (sql server 2000 sp3a) with 80 database and for 40 of these databases and I have transactional replication setup to another server.
Publisher server acts as the distributer so I have a distribution database on that instance.
Problem: now I have to replication all 80 database and Before I start setting them up as publication, I know that I will have locking problem on distribution db (on MSrepl_commands and MSrepl_transactions) due to number of transactions . log reader and distributer agents will block each other.
I am wondering if I can have more than one distribution database for the same instance so I can spread the load between to different databases.
What is the best practice in this scenario?
Many Thanks
-
No you can't, unless use multiple distributors.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|