Stewart "Arturius" Campbell (4/4/2014)
Interesting question, thanks.
I have never found the need to have more than one distributor per instance of SQL server, but good to know that it is possible
I have seen deadlocks in the distribution database. This is where I think multiple distribution dbs would be most helpful - a means to help reduce activity in any one distribution db and reduce the chances for deadlocks.
Otherwise, one distribution db is usually sufficient enough.
I have given a name to my pain...MCM SQL Server, MVP
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events