Merge Replication (Timeouts)

  • In terms of Indexes. I used this query:

    SELECT object_id AS ObjectID,

    index_id AS IndexID,

    avg_fragmentation_in_percent AS PercentFragment,

    fragment_count AS TotalFrags,

    avg_fragment_size_in_pages AS PagesPerFrag,

    page_count AS NumPages

    FROM sys.dm_db_index_physical_stats(DB_ID('BMB1_Market'),

    NULL, NULL, NULL , 'DETAILED')

    WHERE avg_fragmentation_in_percent > 0

    ORDER BY ObjectID, IndexID

    and the results were:

    ObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages

    153918910.0153824855020074152042.769078947368465009

    153918911.9047619047619335105

    5167080077.777777777777891.2222222222222211

    9871202128.571428571428652.814

    9871202250212

    9871202350212

    98712021350212

    98712021750212

    98712021850212

    22395249500.2590673575129533710.4324324324324386

    2530711607581.1259

    25307116250212

    37167194077.7777777777778919

    59967390121.42857142857147214

    59967390850212

    599673901050212

    599673901150212

    101167422080101.111

    10796756110.3822629969418968163.51308

    10796756142.5974025974026107.777

    10796756150.650759219088937592.2461

    107967561533.3333333333333326

    107967561153.84615384615385107.878

    107967561181.41843971631206187.83333333333333141

    107967561211.41843971631206168.8125141

    133167536075414

    13787165810.03677822728944475543.82719

    151760810045.45454545454551310.1538461538462132

    17406380610.10365916865346784611.4030732860529647

    17406380650.058445353594389213712.48905109489051711

    174063806100.23337222870478412114.16528925619831714

    1740638061028.571428571428632.333333333333337

    175443799142.857142857142951.47

    175443799250212

    175443799750212

    175443799850212

    18239581910.030175015087507517918.51396648044693314

    210919923150212

    217307800060515

    233872000350.066874721355327735812.53072625698324486

    233872000352.32558139534884136.6153846153846286

    25957977916.25103.232

    259579779215.789473684210582.37519

    259579779319.04761904761982.62521

    281308028077.7777777777778919

    28744419815031.333333333333334

    287444198550212

    293168106080101.414

    295112242166.6666666666667313

    322920322150212

    325168220050212

    339580064123.076923076923181.62513

    339580064228.571428571428651.47

    33958006432531.333333333333334

    339580064414.285714285714361.166666666666677

    376492520166.6666666666667313

    377872513255.555555555555671.285714285714299

    398064604129.411764705882472.4285714285714317

    421168562080101.818

    42116856222041.255

    433540728145.454545454545571.5714285714285711

    503112983077.7777777777778919

    509448805033.3333333333333313

    51144499610.082426640290141829620.49324324324326066

    51144499630.1351351351351353620.5555555555556740

    51144499637531.333333333333334

    511444996100.2744739249771275218.61093

    514921006157.142857142857161.166666666666677

    514921006233.333333333333321.53

    526493175166.6666666666667616

    529541070114.285714285714351.47

    529541070350212

    529541070433.333333333333321.53

    549169018071.4285714285714717

    55387314020.366972477064223515.5714285714286545

    553873140210021.53

    553873140290.5108556832694766130.5783

    553873140320.2372479240806644210.75843

    5538731403242.857142857142932.333333333333337

    625541412150212

    657485187076.9230769230769123.0833333333333337

    657485187240515

    65958120415051.26

    659581204225414

    659581204350414

    659581204450212

    66101753610.0117069.7643610785463116658

    66101753613.8461538461538577.4285714285714352

    66101753670.18548574078367737511.50133333333334313

    71039770011.137980085348516111.5245901639344703

    71039770031.6260162601626717.5714285714286123

    71806574410.12828736369467616818.55952380952383118

    733140486056.252912.1034482758621351

    73754181110.073152889539136863210.81487341772156835

    73754181120.12033694344163722311.17937219730942493

    737541811214.28571428571433721

    754921861250212

    767380036150414

    788600481322.222222222222271.285714285714299

    802789217450212

    807114066228.571428571428651.47

    819581774166.6666666666667313

    819581774250212

    929542495262.561.333333333333338

    929542495328.57142857142867321

    92954249545061.333333333333338

    929542495575818

    929542495613.333333333333362.515

    929542495715.384615384615492.8888888888888926

    952494572250212

    979582344166.6666666666667313

    979582344250212

    99471342510.2851711026615974027.850746268656723156

    99471342530.829875518672199460.25241

    99471342560.992063492063492677.52238805970149504

    994713425610021.53

    998398726241.176470588235391.8888888888888917

    998398726821.052631578947453.819

    99839872695061.6666666666666710

    9983987261036.363636363636461.8333333333333311

    9983987261133.333333333333372.5714285714285718

    100187473650.101832993890025196.4982

    1038494999142.8571428571429717

    1038494999250212

    1038494999350212

    1042922887220.44052863436123417010.68235294117651816

    1042922887223033.3333333333333310

    1059582629116.666666666666772.5714285714285718

    105958262923061.6666666666666710

    105958262935081.2510

    106449497110.0233894680566693449113.327989311957259856

    106449497114.0816326530612214798

    106449497131.095590249246785073.023651

    1081310878076.9230769230769132.6153846153846234

    1081310878226.666666666666772.1428571428571415

    1098591102144.444444444444471.285714285714299

    1098591102566.6666666666667313

    1098591102666.6666666666667313

    1098591102766.6666666666667313

    110901913210.0110363094581172165710.936632468316218122

    110901913212.7027027027027514.874

    110901913220.1162565394303435589.249103942652335161

    1109019132211.764705882352953.417

    112639918232531.333333333333334

    1126399182866.6666666666667313

    115049539810.1573976915005254149.207729468599033812

    1152927095066.6666666666667313

    1154790471033.3333333333333313

    1183447390150212

    1207059152218.181818181818233.6666666666666711

    1207059152318.181818181818233.6666666666666711

    1218923514073.5708792617278574610.849982596588962344

    121892351430.06545726575649911599.2269197584124310694

    1218923514314.28571428571437535

    1218923514120.293010918512121203615.924361493123832422

    1218923514121.520912547528522013.15263

    121892351412100414

    1218923514130.19413287316652362222.360128617363313908

    1221171412093.3333333333333305.36666666666667161

    1241875591217.241379310344883.62529

    1241875591615.789473684210544.7519

    1241875591727.77777777777786318

    1241875591827.777777777777882.2518

    1241875591927.77777777777786318

    125649565567.1428571428571439.3333333333333328

    127944773210.038011973771738123558.9367303609341821046

    1279447732111.764705882352956.834

    127944773220.01693193362682026359.30078740157485906

    131006785310.10306090899721711648.335910652920969703

    1310067853112.54416

    131701987310.01415267910215440078.8168205640129835329

    131701987312.75862068965517197.63157894736842145

    131701987320.10883214734198412189.8070607553366211945

    131701987325.2631578947368449.538

    135154411910.276837896031994107.929268292682933251

    139144813129.0909090909090973.1428571428571422

    1391448131433.33333333333339218

    13914481311045.454545454545561.8333333333333311

    1391448131118.333333333333334624

    13914481311236.363636363636452.211

    142902027210.230718523401456279.677830940988846068

    142902027212033.3333333333333310

    1459584054117.647058823529472.4285714285714317

    145958405422071.4285714285714310

    1459584054333.333333333333341.56

    145958405444071.4285714285714310

    146240037910.071994240460763110513.22857142857141389

    1521544604250212

    152154460436041.255

    152154460446041.255

    1521544604566.6666666666667313

    1521544604666.6666666666667313

    1521544604750212

    154659269810.050417343566186818209.8082417582417617851

    1551448701115.789473684210572.7142857142857119

    155144870124041.255

    1551448701950212

    15514487011066.6666666666667313

    15514487011166.6666666666667313

    155660321710.1852995676343423708.751351351351353238

    155660321780.50251256281407366.3333333333333199

    155954486010.1460706982179388338.218487394957986846

    15595448601254312

    156397274888.8235294117647156.834

    1563972748911.764705882352956.834

    1602272588050212

    162302560910.02409638554216879079.151047409040798300

    162935296910.24289831206257724509.9142857142857124290

    1629352969149.5652173913044363.19444444444444115

    162935296920.19127773527161424610.62601626016262614

    162935296923042.510

    1629352969490.06468305304010356723.07462686567161546

    1664928919050414

    1670401120133.333333333333371.285714285714299

    1670401120566.6666666666667313

    1672168848077.777777777777891.2222222222222211

    1672649018085.7142857142857142.8571428571428640

    167264901822071.4285714285714310

    1682792352113.33333333333333515

    168849719412571.7142857142857112

    16884971941066.6666666666667313

    172187730112531.333333333333334

    17218773011050212

    173302135575041.56

    1754537100113.333333333333383.7530

    1754537100216.666666666666751.26

    175453710032531.333333333333334

    175453710042531.333333333333334

    1754537100514.285714285714351.47

    1754537100614.285714285714361.166666666666677

    1754537100811.111111111111161.59

    1754537100928.571428571428651.47

    17545371001128.5714285714286717

    1784169247068.660968660968748511.47216494845365564

    178416924721.0230179028133488.14583333333333391

    178416924732.77777777777778468.60869565217391396

    17841692473100212

    1789353539121.428571428571462.3333333333333314

    1789353539250212

    17893535391850212

    17893535392150212

    17893535392250212

    17893535392550212

    1829021697814.814814814814873.8571428571428627

    182902169797.4074074074074173.8571428571428627

    1834537385150212

    183621910410.3130870381966194067.866995073891633194

    183944972713061.6666666666666710

    1839449727675414

    1839449727775414

    1839449727837.551.68

    1842792922250414

    185197377410.2556999786916685977.860971524288114693

    1851973774140.74074074074079327

    185197377420.3378378378378381897.830687830687831480

    1851973774250326

    1852789624085.714285714285715345

    1852789624244.444444444444471.285714285714299

    1884789738077.777777777777891.2222222222222211

    1884789738266.6666666666667313

    1888929717050212

    1896169646072.7272727272727102.727

    1916789852066.6666666666667919

    192154602910.1345895020188432827.904255319148942229

    192154602920.09784735812133071297.922480620155041022

    192154602960.375939849624063913.6410256410256532

    192640203211.0054246165357328267.5668789808917221384

    1926402032188.3211678832117711.92957746478873137

    192640203220.1433121019108287368.532608695652176280

    1926402032214.285714285714354.221

    196607019013071.4285714285714310

    1980790080050414

    199735428010.0194325689856199256310.039016777214225730

    19973542801598.8888888888888980

    199735428020.13812154696132613410.80597014925371448

    199735428026031.666666666666675

    199735428030.1598295151838041979.527918781725891877

    1997354280342.857142857142932.333333333333337

    1997354280470.06056935190793463788.735449735449743302

    19973542804823.076923076923143.2513

    1997354280500.3109452736318416624.36363636363641608

    199735428050505210

    2054402488250212

    2054402488366.6666666666667313

    20544024881750212

    205787849810.1594896331738443259.646153846153853135

    205787849820.3421727972626188613.5930232558141169

    205787849826031.666666666666675

    2058594522133.333333333333341.56

    2066793720166.6666666666667313

    2074538240113.333333333333393.3333333333333330

    207453824021692.7777777777777825

    2076790422066.6666666666667616

    207807058922531.333333333333334

    2087062287144.444444444444471.285714285714299

    208706228722041.255

    2087062287333.333333333333351.26

    2088650500094.2857142857143355.88571428571429206

    210226984412.46913580246914126.7581

    212057413808.058608058608062490.95833333333332183

    2120650614083.3333333333333122.2527

    212065061422531.333333333333334

    2145129316084.369114877589522459.4307349665924321172

  • I added the name of the objects to the prior query and I got:

    (No column name)ObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages

    machine553873140210021.53

    ticket_994713425610021.53

    audit_p121892351412100414

    poc_res17841692473100212

    MSmerge2088650500094.2857142857143355.88571428571429206

    MSmerge1221171412093.3333333333333305.36666666666667161

    machine1926402032188.3211678832117711.92957746478873137

    MSmerge1852789624085.714285714285715345

    MSmerge1672649018085.7142857142857142.8571428571428640

    ticket_2145129316084.369114877589522459.4311804008908721173

    MSmerge2120650614083.3333333333333122.2527

    MSmerge101167422080101.111

    MSmerge293168106080101.414

    MSmerge421168562080101.818

    force_s503112983077.7777777777778919

    MSmerge281308028077.7777777777778919

    MSmerge37167194077.7777777777778919

    MSmerge5167080077.777777777777891.2222222222222211

    poc_res1672168848077.777777777777891.2222222222222211

    MSmerge1884789738077.777777777777891.2222222222222211

    MSmerge1081310878076.9230769230769132.6153846153846234

    MSmerge657485187076.9230769230769123.0833333333333337

    user_pl929542495575818

    MSmerge2530711607581.1259

    MSmerge133167536075414

    operato51144499637531.333333333333334

    audit_p1839449727675414

    audit_p1839449727775414

    audit_p1218923514073.5708792617278574610.849982596588962344

    poc_res1896169646072.7272727272727102.727

    MSmerge549169018071.4285714285714717

    poc_res1784169247068.660968660968748511.47216494845365564

    It seems that indexes are very fragmentated according to the percentFrangemt column. A lot of the columns that are very frragmentated are MSmerge... which I believe are created by the snapshot agent , should they also see their indexes rebuild?

  • I'm trying to show that indexes are very fragmentated. Including the ones from MSMerge... Tables. Shouldn't does be rebuid? or it's better to just defrag?

  • I don't think that index fragmentation is your problem. MsMerge% tables are based on GUIDs and will always be fragemented.

    I would rather try to trace a sync process with a server-side trace and try to see if something performs very badly.

    I reiterate my opinion that a test subscriber is the way to go here.

    -- Gianluca Sartori

  • MS recommendations is to filter out anything with a page count less than 1000

    Then reorg anything less than 30% fragmented and rebuild anything greater than 30% fragmented.

    SELECT

    case when avg_fragmentation_in_percent < 30 then 'ReOrg' ELSE 'Rebuild' end as command,

    object_id AS ObjectID,

    index_id AS IndexID,

    avg_fragmentation_in_percent AS PercentFragment,

    fragment_count AS TotalFrags,

    avg_fragment_size_in_pages AS PagesPerFrag,

    page_count AS NumPages

    FROM sys.dm_db_index_physical_stats(DB_ID('BMB1_Market'),

    NULL, NULL, NULL , 'DETAILED')

    WHERE avg_fragmentation_in_percent > 0 and page_count > 1000 and index_id <> 0

    ORDER BY ObjectID, IndexID

  • So, because most of the tables are above 30% in terms of indexing I should rebuid all the indexes, correct? Even from the msmerge tables?

    Another question, if I rebuid the indexes will I need to also update the entre statistics of the database?

    Also, how can I measure I/O performance to see what is happening? Without the profiler because I can t use the tool.

    Thank you

  • How can I do that trace on the server if I cannot use profiler. Any idea?

    De

  • It depends, run the query filter out small page tables (page_count > 1000) filter out all heaps (index_id <> 0) what are you left with?

    That details what in Microsoft's eyes is a candidate for maintenance. Are any of the issues you are facing related to the tables / indexes left?

    As for profiler, use a server side trace is you cant run profiler or extended events, theres a whole stairway on server side tracing in the stairways secion

  • When I run your query:

    SELECT

    case when avg_fragmentation_in_percent < 30 then 'ReOrg' ELSE 'Rebuild' end as command,

    object_id AS ObjectID,

    index_id AS IndexID,

    avg_fragmentation_in_percent AS PercentFragment,

    fragment_count AS TotalFrags,

    avg_fragment_size_in_pages AS PagesPerFrag,

    page_count AS NumPages

    FROM sys.dm_db_index_physical_stats(DB_ID('BMB1_Market'),

    NULL, NULL, NULL , 'DETAILED')

    WHERE avg_fragmentation_in_percent > 0 --and page_count > 1000 and index_id <> 0

    ORDER BY ObjectID, IndexID

    I get the following result:

    commandObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages

    ReOrg153918910.0153791735232149152142.75016436554965023

    ReOrg10796756110.458015267175573101311310

    ReOrg13787165810.03677822728944475543.82719

    ReOrg17406380610.10361620557455284611.40780141843979651

    ReOrg17406380650.058445353594389213712.48905109489051711

    ReOrg174063806100.29154518950437312214.05737704918031715

    ReOrg18239581910.030175015087507517918.51396648044693314

    ReOrg23387200010.02027163997567472613.58953168044089866

    ReOrg233872000350.066874721355327735812.53072625698324486

    ReOrg51144499610.082426640290141829620.49324324324326066

    ReOrg511444996100.2744739249771275218.61093

    ReOrg66101753610.0117069.7643610785463116658

    ReOrg66101753670.1853997682502937511.50666666666674315

    ReOrg71806574410.12828736369467616818.55952380952383118

    ReOrg73754181110.073152889539136863210.81487341772156835

    ReOrg73754181120.12033694344163722311.17937219730942493

    ReOrg99471342510.2850807728856514027.853233830845773157

    ReOrg1042922887220.44052863436123417010.68235294117651816

    ReOrg106449497110.0250195986856371450313.31401288030259953

    ReOrg106449497131.284855112083115764.17543859649123658

    ReOrg110901913210.0110363094581172165710.936632468316218122

    ReOrg110901913220.1162565394303435589.249103942652335161

    ReOrg115049539810.2097535395909814169.168269230769233814

    ReOrg120705915210.3213555360794624357.868965517241383423

    ReOrg120705915237.068311195445923895.419023136246792108

    ReOrg120705915240.9314140558848431567.570512820512821181

    ReOrg121892351430.074801309022907911609.219827586206910695

    ReOrg1218923514120.326817537152371204815.836914062532434

    ReOrg1218923514130.22281319629123862622.225239616613413913

    ReOrg127944773210.038010167719865123558.9371549893842921047

    ReOrg127944773220.01693193362682026359.30078740157485906

    ReOrg131006785310.10305028854080811648.336769759450179704

    ReOrg131006785320.05379236148466924378.508009153318083718

    ReOrg131701987310.01415267910215440078.8168205640129835329

    ReOrg131701987320.10880482089052612189.8095238095238111948

    ReOrg135154411910.2759889604415824127.915048543689323261

    ReOrg142902027210.2306805074971166279.679425837320576069

    ReOrg146240037910.071994240460763110513.22857142857141389

    ReOrg154659269810.050406048725847118219.8050521691378417855

    ReOrg155660321710.2161160852114853718.730458221024263239

    ReOrg155954486010.160256410256418358.220359281437136864

    ReOrg162302560910.02409638554216879079.151047409040798300

    ReOrg162935296910.2428883125437424509.9146938775510224291

    ReOrg162935296920.22944550669216124710.5870445344132615

    ReOrg1629352969490.06468305304010356723.07462686567161546

    ReOrg168279235212.543380080817696156.840650406504074207

    ReOrg183621910410.3123048094940664077.867321867321873202

    ReOrg185197377410.2556999786916685977.860971524288114693

    ReOrg185197377420.3378378378378381897.830687830687831480

    ReOrg192154602910.1345895020188432827.904255319148942229

    ReOrg192154602920.09784735812133071297.922480620155041022

    ReOrg192640203211.1494789963085828587.4881035689293221401

    ReOrg192640203220.1432892851456777368.533967391304356281

    ReOrg199735428010.0194325689856199256310.039016777214225730

    ReOrg199735428020.2070393374741213510.73333333333331449

    ReOrg199735428030.2129925452609161989.484848484848481878

    ReOrg1997354280470.06056935190793463788.735449735449743302

    ReOrg1997354280500.3109452736318416624.36363636363641608

    ReOrg205787849810.1594896331738443259.646153846153853135

    ReOrg205787849820.3421727972626188613.5930232558141169

    So the major frangmentation (100%) that was returned by my previos query does not apper. I believe that this is due to the page_count > 1000

    So, maybe I will not need to ask to rebuid all the database indexes as I think it would be good.

  • Sorry I didn't understud your question.

    What are page_counts >1000

  • Your answer, not question.

  • "That details what in Microsoft's eyes is a candidate for maintenance."

    You are saying that because this query :

    SELECT

    case when avg_fragmentation_in_percent < 30 then 'ReOrg' ELSE 'Rebuild' end as command,

    object_id AS ObjectID,

    index_id AS IndexID,

    avg_fragmentation_in_percent AS PercentFragment,

    fragment_count AS TotalFrags,

    avg_fragment_size_in_pages AS PagesPerFrag,

    page_count AS NumPages

    FROM sys.dm_db_index_physical_stats(DB_ID('BMB1_Market'),

    NULL, NULL, NULL , 'DETAILED')

    WHERE avg_fragmentation_in_percent > 0 and page_count > 1000 and index_id <> 0

    ORDER BY ObjectID, IndexID

    Did only return:

    commandObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages

    ReOrg120705915238.980355472404124284.995327102803742138

    ReOrg168279235213.379017013232516496.520801232665644232

    ReOrg106449497131.284855112083115764.17543859649123658

    ReOrg192640203211.1726780041113828647.4734636871508421404

    ReOrg120705915240.9220452640402351587.550632911392411193

    ReOrg1997354280500.6207324643078837122.69014084507041611

    ReOrg10796756110.458015267175573101311310

    ReOrg1042922887220.44052863436123417010.68235294117651816

    ReOrg205787849820.3421727972626188613.5930232558141169

    ReOrg185197377420.3378378378378381897.830687830687831480

    ReOrg1218923514120.33603600826217205115.815212091662632437

    ReOrg120705915210.3182870370370374397.872437357630983456

    ReOrg183621910410.3123048094940664077.867321867321873202

    ReOrg174063806100.29154518950437312214.05737704918031715

    ReOrg99471342510.2849905003166564027.855721393034833158

    ReOrg135154411910.2758197977321484127.919902912621363263

    ReOrg511444996100.2744739249771275218.61093

    ReOrg185197377410.2556999786916685977.860971524288114693

    ReOrg162935296910.25521755238134424539.9033836119037924293

    ReOrg115049539810.2359108781127134179.148681055155883815

    ReOrg142902027210.2306425041186166279.681020733652316070

    ReOrg1218923514130.22998418858703562722.191387559808613914

    ReOrg162935296920.22944550669216124710.5870445344132615

    ReOrg155660321710.2161160852114853718.730458221024263239

    ReOrg199735428030.2129925452609161989.484848484848481878

    ReOrg199735428020.2070393374741213510.73333333333331449

    ReOrg66101753670.1853997682502937511.50666666666674315

    ReOrg71806574410.16030779095864116918.45562130177523119

    ReOrg155954486010.1601397583345478358.226347305389226869

    ReOrg205787849810.1594896331738443259.646153846153853135

    ReOrg192640203220.1432892851456777368.533967391304356281

    ReOrg192154602910.1345895020188432827.904255319148942229

    ReOrg73754181120.12033694344163722311.17937219730942493

    ReOrg110901913220.1162565394303435589.249103942652335161

    ReOrg131701987320.10879571512260412189.8103448275862111949

    ReOrg17406380610.10360547036883584711.39551357733189652

    ReOrg131006785310.10303967027305511648.337628865979389705

    ReOrg192154602920.09784735812133071297.922480620155041022

    ReOrg51144499610.082426640290141829620.49324324324326066

    ReOrg121892351430.074801309022907911609.219827586206910695

    ReOrg73754181110.073152889539136863210.81487341772156835

    ReOrg146240037910.071994240460763110513.22857142857141389

    ReOrg233872000350.066874721355327735812.53072625698324486

    ReOrg1629352969490.06468305304010356723.07462686567161546

    ReOrg1997354280470.06056935190793463788.735449735449743302

    ReOrg17406380650.058445353594389213712.48905109489051711

    ReOrg131006785320.05379236148466924378.508009153318083718

    ReOrg154659269810.050406048725847118219.8050521691378417855

    ReOrg127944773210.038010167719865123558.9371549893842921047

    ReOrg13787165810.03677822728944475543.82719

    ReOrg18239581910.030175015087507517918.51396648044693314

    ReOrg199735428010.0272045392716956256510.031578947368425731

    ReOrg106449497110.0250195986856371450313.31401288030259953

    ReOrg162302560910.02409638554216879079.151047409040798300

    ReOrg23387200010.02027163997567472613.58953168044089866

    ReOrg127944773220.01693193362682026359.30078740157485906

    ReOrg153918910.0153779910192532152242.725361366622965028

    ReOrg131701987310.01415267910215440078.8168205640129835329

    ReOrg110901913210.0110363094581172165710.936632468316218122

    ReOrg66101753610.0117069.7643610785463116658

    It means that from the big tables (page_count >1000) I don't have any one above 10% so my problem should not be the indexes, correct?

  • What should be the next step to investigate? maybe lock and block?

  • Or should I look at I/O Stats?

  • I'm sorry to say that and I mean no offense, however: you're doing it wrong.

    1) Set up a subscriber on your machine and subscribe to that publication.

    2) Start the merge agent and try to reproduce the condition.

    3) Inspect the logs and nail down the root cause.

    4) Fix it.

    4) Everybody happy.

    Also, you cannot spit thousands of numbers at us, unformatted and unreadable: nobody will take the time to read them. Really.

    If you have some numbers to share, format them and share just the relevant parts of your findings.

    Please understand that I'm writing this uniquely to help you get the best help here.

    -- Gianluca Sartori

Viewing 15 posts - 16 through 30 (of 32 total)

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