Home > Archive > MS SQL Server Replication > December 2005 > Optimisation









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Optimisation
GC

2005-12-28, 8:24 pm

Hi,

I read that we can optimise from 10 to 15 % the performance of a replication
by changing the default value of the HistoryVerboseLevel and the
OutputVerboseLevel of the Agent Profiles

For exemple for the Distribution Agent we have to use
distrib -HistoryVerboseLevel 1
distrib -OutputVerboseLevel 0

The default value are 2 for both

The distrib program to executable is in
C:\Program Files\Microsoft SQL Server\80\COM

2 questions

01- On which server I have to execute this command on the Distributor or
on the
Publisher

02- Also when i go on the Distributor and view the propreties of the Agent
profile
I dont see the OutputVerboseLevel. Is that normal

Thanks in advance !

















Hilary Cotter

2005-12-29, 3:24 am

With a remote publisher/distributor its on the distributor, with a local
publisher/distributor its on the publisher.

Basically you do it wherever your distribution agents run.

Its normal for the OutputVerboseLevel parameter not to be used.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"GC" <GC@discussions.microsoft.com> wrote in message
news:9B8F89FB-1106-48F2-9ED6- AC2BC752333B@microso
ft.com...
> Hi,
>
> I read that we can optimise from 10 to 15 % the performance of a
> replication
> by changing the default value of the HistoryVerboseLevel and the
> OutputVerboseLevel of the Agent Profiles
>
> For exemple for the Distribution Agent we have to use
> distrib -HistoryVerboseLevel 1
> distrib -OutputVerboseLevel 0
>
> The default value are 2 for both
>
> The distrib program to executable is in
> C:\Program Files\Microsoft SQL Server\80\COM
>
> 2 questions
>
> 01- On which server I have to execute this command on the Distributor or
> on the
> Publisher
>
> 02- Also when i go on the Distributor and view the propreties of the
> Agent
> profile
> I dont see the OutputVerboseLevel. Is that normal
>
> Thanks in advance !
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com