Disable parallelism for replication agents

Is there a way to disable parallelism for all the distribution agents
participating in trans replication using SQL 2KWhy do you want to do that? Is there a sepcific issue, if so, I'd be
interested in details.
Anyway, distribution agents by default apply commands to subscribers, using
stored procedures. You could edit these stored procedure and specify the
degree of parallelism. Search BOL for MAXDOP.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
Is there a way to disable parallelism for all the distribution agents
participating in trans replication using SQL 2K|||If by parallelism you mean multiple distribution agents for different
publications on the same publishing server and database going to the same
subscriber, subscribing database - there is the independent_agent option
which by default is false.'
Does your distribution agent say multiple publications? If so you do not
have an independent agent.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
> Is there a way to disable parallelism for all the distribution agents
> participating in trans replication using SQL 2K
>|||Well we do not use Stored Procedures to apply commands to subscribers...Our
sp_addarticle values for @.ins_cmd ,@.del_cmd and @.upd_cmd = SQL
Not too sure why it was implemented this way but it is. And in this case,
cant seem to use the MaxDop option
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23htMaGMkDHA.2964@.tk2msftngp13.phx.gbl...
> Why do you want to do that? Is there a sepcific issue, if so, I'd be
> interested in details.
> Anyway, distribution agents by default apply commands to subscribers,
using
> stored procedures. You could edit these stored procedure and specify the
> degree of parallelism. Search BOL for MAXDOP.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
> Is there a way to disable parallelism for all the distribution agents
> participating in trans replication using SQL 2K
>
>|||By parallelism, I mean parallel queries. I think my previous post "Spid
being blocked by itself + parallelism" gives you an example
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%23ZKaDEOkDHA.3024@.tk2msftngp13.phx.gbl...
> If by parallelism you mean multiple distribution agents for different
> publications on the same publishing server and database going to the same
> subscriber, subscribing database - there is the independent_agent option
> which by default is false.'
> Does your distribution agent say multiple publications? If so you do not
> have an independent agent.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
> > Is there a way to disable parallelism for all the distribution agents
> > participating in trans replication using SQL 2K
> >
> >
>|||As Vyas was asking, I too would be interested in why you wanted to disable
parallelism in this case.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23SDJjXOkDHA.964@.TK2MSFTNGP10.phx.gbl...
> Well we do not use Stored Procedures to apply commands to
subscribers...Our
> sp_addarticle values for @.ins_cmd ,@.del_cmd and @.upd_cmd = SQL
> Not too sure why it was implemented this way but it is. And in this case,
> cant seem to use the MaxDop option
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23htMaGMkDHA.2964@.tk2msftngp13.phx.gbl...
> > Why do you want to do that? Is there a sepcific issue, if so, I'd be
> > interested in details.
> >
> > Anyway, distribution agents by default apply commands to subscribers,
> using
> > stored procedures. You could edit these stored procedure and specify the
> > degree of parallelism. Search BOL for MAXDOP.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > What hardware is your SQL Server running on?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
> > Is there a way to disable parallelism for all the distribution agents
> > participating in trans replication using SQL 2K
> >
> >
> >
> >
>|||I think my previous post "Spid being blocked by itself + parallelism" gives
you an example
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:ev0F3ATkDHA.744@.tk2msftngp13.phx.gbl...
> As Vyas was asking, I too would be interested in why you wanted to disable
> parallelism in this case.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23SDJjXOkDHA.964@.TK2MSFTNGP10.phx.gbl...
> > Well we do not use Stored Procedures to apply commands to
> subscribers...Our
> > sp_addarticle values for @.ins_cmd ,@.del_cmd and @.upd_cmd = SQL
> > Not too sure why it was implemented this way but it is. And in this
case,
> > cant seem to use the MaxDop option
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > news:%23htMaGMkDHA.2964@.tk2msftngp13.phx.gbl...
> > > Why do you want to do that? Is there a sepcific issue, if so, I'd be
> > > interested in details.
> > >
> > > Anyway, distribution agents by default apply commands to subscribers,
> > using
> > > stored procedures. You could edit these stored procedure and specify
the
> > > degree of parallelism. Search BOL for MAXDOP.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > What hardware is your SQL Server running on?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > >
> > >
> > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > news:OeEoeuHkDHA.2488@.TK2MSFTNGP12.phx.gbl...
> > > Is there a way to disable parallelism for all the distribution agents
> > > participating in trans replication using SQL 2K
> > >
> > >
> > >
> > >
> >
> >
>