June 25, 2010 at 3:14 pm
Hi friends i am very new to SQL server Envi, i am Oracle DBA .
Now i am working on SQL Server as, I have a query here
We are working out this Merge Replication Processes in Our servers.
SO in the part of that process i need to improve the process speed and maintain the Replication,
I found some parameters are very critical in this replication process, which are directly effecting the Merge Replication Process, So i need to tune them
replmerg.exe is the main application with consists all these parameters in it....
-DownloadGenerationsPerBatch
–ParallelUploadDownload
-SrcThreads
-DestThreads
-MakeGenerationInterval
-DownloadGenerationsPerBatch
-UploadGenerationsPerBatch
These are some parameters i need to fix around.
I want to set them Manually or Through script any way is ok.
Can any one help me out with the Synatax or Manual process which we can workout with.
ITs a bit urgent.
I hope we have Good team here to look after....
@JayMunnangi
June 29, 2010 at 6:14 pm
There is no simple way to resolve merge replication issues.
What version of SQL are you using?
How much data are you pushing to your replica.
Is it a continious push, or scheduled. Does the data have to be commited on the subscriber prior to a commit ont he publisher????
June 29, 2010 at 11:45 pm
Version MS SQL SERVER 2008 Enterprise.
its a continues PUSH of About 80000+,
We are doing Merger Replication,...
And found the manual one time process to Modify the abouve Parameters from AGENT PROFILE...
but ineed script to run.
And i am facing Heavy Deadlocks..
like ??????????????????????????????????????????????????????? continues... From sys.merge_------90 Stored procedure.
@JayMunnangi
June 30, 2010 at 12:33 am
I estimate that the 80,000 refers to the number of transactions delivered, how many per minute. Are both databases being utilised by users at the same time? If not then you could disable check constraints and perhaps indexes on the replica to improve throughput. It is hard to analyse this without any real details, merge replication has to be dealt with carefully there are many things that can cause issues.
June 30, 2010 at 12:43 am
Yaa i can understand its becomming more and more complicated day to day for me to handle and i am very new to this Database. 🙂
You are correct the total count of transactions delivered. no users are connected we are doing this is test LAB. Resources are not being shared to any Users.
How to disable the Check Constraints? If there is any script for that i need to include the script with the existing scripts it runs every time of the replication and disable the check constraints.
I dnt think we have check Constraints, if we have them during replication it will pause at the count given, its not happening .
And about the indexes in the replication, we presently disabling them. you want us to enable them? i think during the BCP there might be Long time intervals for insertion or Updating might happen?
@JayMunnangi
July 1, 2010 at 4:20 am
Seeing that this is in a lab I am surprised by your issue. It could be a case that the database has certain components that don't work well with merge repilcatiion. I suggest that you disable check constraints this is easy. Disable any triggers for replication and drop all your indexes. Then crank up the number of transactions slowly to discover where you encounter the bottleneck.
July 1, 2010 at 4:41 am
Hi
i am now strucked with the following error:
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
what shall be done now?
@JayMunnangi
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply