Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

snapshot publication - time out expired Expand / Collapse
Posted Thursday, November 6, 2008 5:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 1, 2016 9:51 PM
Points: 1,184, Visits: 3,465
Hi Friends,

I configured merge replication in one the sql server 2000. when completion publication after that automatically snapshot agent is running and creating article, while running snapshot agent it is automatically turned off (time out expired), so article was not created. Becuse all tables contain 20Laks recored. still snapshot publication not yet available.

After that... I creted new replication agent profile, and create new parameter & value as follows

-BcpBatch size 100000
-History Verbel - 2
-Logintime out - 15
-MaxBcpThreads -1
-Query time out - 1000

It was taking too long time for creating snapshot publication .

Anybody give me tips, how to reduce the time for creating snapshot publication .

Post #598024
Posted Friday, November 7, 2008 5:55 AM



Group: General Forum Members
Last Login: Thursday, March 31, 2016 8:57 AM
Points: 177, Visits: 788
Hi Ananda,

Make sure your snapshot goes onto a fast disk because it is mainly IO intensive. You can increase the -MaxBCPThreads to a number equal to the number of processors on your machine.

If your tables doesn't have uniqifiers, you might want to add them yourself before you generate the snapshot rather than them being created during Snapshot (see, "Improving Performance While Generating and Applying Snapshots" for details).

Having said this, it is odd that you get a time out because the job is diveded into many steps. Is there anything in the Snapshot history that reveals where it is timing out? Next time you attempt, increase the HistoryVerboseLevel to 3.


Post #598836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse