SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


snapshot publication - time out expired


snapshot publication - time out expired

Author
Message
SQL Galaxy
SQL Galaxy
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2614 Visits: 3465
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
Elisabeth Rédei
Elisabeth Rédei
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 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 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search