snapshot publication - time out expired

  • 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 .

    Thanks

  • 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 http://msdn.microsoft.com/en-us/library/aa237151(SQL.80).aspx, "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.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply