July 30, 2007 at 1:21 pm
Trying to take advantage of SS 2005 Replication parallelism. I set up my publication with the option: @SubscriptionStreams = 4... here is the script to do so:
exec sp_addsubscription @publication = N'MySubscription', @subscriber = N'MyClusterSQLServer', @destination_db = N'MyDB', @subscription_type = N'Push', @sync_type = N'automatic', @article = N'all', @update_mode = N'read only', @subscriber_type = 0,@SubscriptionStreams = 4
Question, is this parameter visible anywhere once the publication is setup? If I need to alter the streams to 2, where do I find this parameter setting?
February 17, 2011 at 1:53 pm
Has anyone answered this question? I'd like to know the answer.
February 18, 2011 at 9:34 am
ok, I am messing around with the same stuff. I am wanting to alter ALL publications, so I am looking to find where all publications are listed and do a loop thru them setting the subscriptionstream. So...in answer to your question, in searching I found that that code is in the distribution agent part of the replication job. Now...I have seen it, but can't for the life of me find it again!!! There is a place where the jobs is broke down, and it is in like 4 pieces. one is the logreader, one is the distribution agent. it is in there!! Now, help me find it again!! LOL.
Do you know where you can find the table (?) that holds all the publications where you can set the subscriptionstream #?? There is a table in the distribution database called dbo.MSdistribution_agents and there is a column in there that has subscriptionstream info..............
Hope I helped...this is a confusing subject!! :w00t:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply