Optimisation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GC - 28 Dec 2005 21:27 GMT

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 !

Reply to this Message

Hilary Cotter - 29 Dec 2005 02:57 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 24 lines]
>
> Thanks in advance !

Reply to this Message