Groups | Blog | Home
all groups > sql server replication > december 2005 >

sql server replication : Optimisation


GC
12/28/2005 1:27:03 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
12/28/2005 9:57:30 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button