November 4, 2015 at 9:29 am
I understand. I will try to create a subscriver thropugh my machine.
Tell me one thing please:
I already run the query over the distribution database Which produced this results:
namecommandObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages
DF__MSsubscri__nosyn__08EA5793Rebuild149575571284.543381735269472991.141663241539948333
DF__MSsubscri__nosyn__08EA5793Rebuild149575571153.157042633567218521.000539956803461853
MSmerge_historyRebuild933578364147.49687108886115732.788830715532291598
DF__MSsubscri__nosyn__08EA5793Rebuild149575571140.07064063560161522962.40001050585702365512
MSmerge_articlehistoryReOrg757577737118.29059829059835143.414396887159531755
MSmerge_historyReOrg933578364213.351443807224196664.1129733085040439756
MSmerge_historyReOrg933578364110.1303584975031920754.66726038555525429738
MSmerge_historyReOrg93357836434.1849850656106347016.3384386300787129797
DF__MSpublica__allow__014935CBReOrg2157511513.2347688033339937813.33068783068785039
IHsyscolumnsReOrg1809910512.8319697923222213611.68382352941181589
DF__MSpublica__allow__014935CBReOrg2157511512.6181649675625627515.69454545454554316
DF__MSmerge_a__delet__300424B4ReOrg80557790812.388663967611342719.114391143911442470
DF__MSmerge_s__schem__267ABA7AReOrg64557733811.451666116793143259.326153846153853031
IHpublishersReOrg142958013111.11855176981382100413.534860557768913589
UIPropertiesReOrg49810081520.08984725965858042556.51113
As you can see, the first 4 have big percentfragmentation :
namecommandObjectIDIndexIDPercentFragmentTotalFragsPagesPerFragNumPages
DF__MSsubscri__nosyn__08EA5793Rebuild149575571284.543381735269472991.141663241539948333
DF__MSsubscri__nosyn__08EA5793Rebuild149575571153.157042633567218521.000539956803461853
MSmerge_historyRebuild933578364147.49687108886115732.788830715532291598
DF__MSsubscri__nosyn__08EA5793Rebuild149575571140.07064063560161522962.40001050585702365512
In this case, because its about the distribution database. Should be this what is causing the impact?
November 4, 2015 at 9:39 am
"Set up a subscriber on your machine and subscribe to that publication."
Unfortunately I cannot , because I just have the client tools on my machine. So I cannot create a subscriber to subscribe to the publications...
So, based on this, what else can we do to see what is causing problems (it is taking more time to sincronize than usual)?
Can I have a look at the most expensive i/o querys ?
Can I have a look at the log of the publisher?
What is your adevice based on the fact that I cannot create a subscriber or have access to one of it merge logs?
November 4, 2015 at 9:47 am
Also, the sincronization started to loose performance on day 23 of october.
The logs of the SQL Server that have the Database publication and the distribution database cannot help?`
Thanks
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply