none
distrib.exe --- Many instances running RRS feed

  • Question

  • How many instances of distrib.exe should be running???

    Yesterday I created multiple publications in SQL 2005.  without counting, it looks like each publication has its own distrib.exe.... it this the way it is supposed to work???

    Each instance it holding 8k of ram (not a problem right now) but I have many more publications to create...

    Please let me know if this is the way SQL server works now??

    Thursday, February 15, 2007 1:45 PM

Answers

  • Hi William,

    I am guessing you were used to different behavior on SQL2000 where only one instance of distrib.exe is used to service multiple publications\subscriptions to the same subscriber database. The new behavior in SQL2005 is actually the result of a change in the default value of the 'independent_agent' publication property from 0 (false) to 1 (true). So, you can get the same behavior as SQL2000 by changing the 'independent_agent' property from 1 to 0 via sp_changepublication. I am also a bit curious to know why you are creating many publications. If your goal is to have finer granularity for subscription re-initialization, you can actually perform article level reinitialization using sp_reinitsubscription.

    -Raymond 

    Thursday, February 15, 2007 5:16 PM

All replies

  • Hi William,

    I am guessing you were used to different behavior on SQL2000 where only one instance of distrib.exe is used to service multiple publications\subscriptions to the same subscriber database. The new behavior in SQL2005 is actually the result of a change in the default value of the 'independent_agent' publication property from 0 (false) to 1 (true). So, you can get the same behavior as SQL2000 by changing the 'independent_agent' property from 1 to 0 via sp_changepublication. I am also a bit curious to know why you are creating many publications. If your goal is to have finer granularity for subscription re-initialization, you can actually perform article level reinitialization using sp_reinitsubscription.

    -Raymond 

    Thursday, February 15, 2007 5:16 PM
  • Thanks for the explanation. I just wanted to make sure it was normal...

    The reason for the multiple publications is not for the purpose of the subscriptions but rather the publications them selves. We have about 200 table that are changing several times a year based (data lenghts or additional columns). The table are bundles together based on when they are anticipated to change.

    This is the explanation I was given when I was hired. I think it is just to make it easier to see what is what without opening the publications.

    Thursday, February 15, 2007 6:44 PM
  • I have SQL Server 2005 std edition SP1(2gb for sql server ) installed on Windows 2003 Std edition (4gb ram).Configured Transactional
    Replication past two months working fine, Now
    1.Distrib.exe application err is coming.

    Distrib.exe Application Error , Application failed to initialize properly(0xx0000142)click ok to terminate the application

    Due to which my job is failing (Distributor to Subscriber). (detected non logged agent shut down)
    There is only one publication and no cluster environment.

    My Distributor and Publisher are on one server and subscriber on Second server.

     

    Please help on this issue...

     

     

    Sunday, April 6, 2008 3:21 PM