Some log information from SQL Server log:

2015-11-13 16:38:02.51 spid97 Replication-Replication Merge Subsystem: agent 0043007B-0045-0045-4500-320036003800 failed. The reconciler process was stopped because the Subscriber that initiated...

I also run the sp_who2 and I see same lines with

56 SUSPENDED ...

Also, In the waiting category logging is above all others with this values:

wait time 13000

average waiter count 14.7

Recent wait time = wait time

It sounds like a log issue or a...

I want to test merge replication. I would like to create one. I only have one computer so can I create the merge replicaton (configure the distribuition and subscribers) all...

I mean using having the publisher database and the subscriver database on the same instance?

How can I add figures like you just did?

thanks

no, from 5 to 5 seconds

thank you

When a user transaction is committed (either explicitly via a COMMIT statement, or implicitly), SQL Server writes all changes from the Log Cache out to the log files on disk....

If I add an additional transaction log (on other disk) to the database that would devide the i/0 between logs . which would help, correct?

I belive that 77% is a...

I am trying to see why some data is taking more time to be distributed.

For instance, this result:

WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S

WRITELOG1428099.931381452.4146647.5233103900276.980.00430.00420.0001

The log write percentage is almost on 77% ? is this normal ?

I'm trying to see if from the values below something neeeds to be changed because it is becoming a bootleneck

WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S

WRITELOG1428058.061381411.6746646.3933102989176.980.00430.00420.0001

PAGELATCH_EX95329.6363675.3731654.262689788955.140.00040.00020.0001

SOS_SCHEDULER_YIELD83276.24345.7482930.502574107034.490.00030.00000.0003

LCK_M_S41394.0641261.49132.571363242.230.30360.30270.0010

BACKUPIO26762.2326667.6594.5831221101.440.00860.00850.0000

BACKUPBUFFER23140.8622858.88281.9846286451.250.00500.00490.0001

ASYNC_IO_COMPLETION22127.6122127.540.076611.1933.476033.47590.0001

IO_COMPLETION20302.4820198.53103.9481644431.090.00250.00250.0000

OLEDB16436.2716436.270.0011282011590.890.00000.00000.0000

LCK_M_IX14001.6213989.1712.44451520.750.31010.30980.0003

Do you see any values , that I should be concerned...

Have better perfomance on the server