Viewing 15 posts - 241 through 255 (of 771 total)
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?
November 4, 2015 at 3:59 am
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...
November 4, 2015 at 3:58 am
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...
November 4, 2015 at 3:09 am
which produced this results:
creation_timelast_execution_timetotal_physical_readstotal_logical_readstotal_logical_writesexecution_counttotal_worker_timetotal_elapsed_timeavg_elapsed_time
2015-11-03 14:23:54.7232015-11-03 14:23:54.967075765014640266878393468783934
2015-11-03 14:14:42.6702015-11-03 14:14:42.9576408660119701116489371164893711
2015-11-03 14:14:36.0372015-11-03 14:14:36.263347987013760215814432558144325
2015-11-03 14:55:17.5702015-11-03 19:26:45.70716319418756729515517511501418972985137945970
2015-11-04 07:28:40.0772015-11-04 07:35:29.41701221560219171095429110527145552
2015-11-04 07:28:36.0502015-11-04 07:35:26.13321121740360277404434938382424691912
2015-11-04 08:19:46.7932015-11-04 08:19:47.28013355606498301190050862420738424207384
2015-10-12 06:25:47.6502015-11-04 07:29:34.6830160502517501045972829418389131
2015-11-03 04:45:02.5232015-11-04 04:45:03.77019232173173782164189403329590416647952
2015-11-03 08:15:29.7632015-11-04 02:32:40.3674807610063112233553352442739712213698
2015-11-03 08:17:04.4802015-11-04 02:34:03.057476243442402168589622406437612032188
2015-11-03 08:13:58.7402015-11-04 02:31:06.2733921419201612183300472331233311656166
2015-10-28 08:18:07.9272015-10-28 08:18:07.933101101670511189891113376481148565611485656
2015-11-04...
November 4, 2015 at 2:41 am
I also have used this query:
SELECT top 50 creation_time
,last_execution_time
,total_physical_reads
...
November 4, 2015 at 2:36 am
Results show:
ExecutionCountAvgExecutionTimeAvgWorkerTimeAvgExecutionTime_secAvgWorkerTime_secTotalWorkerTimeMaxLogicalReadsMaxLogicalWritesCreationDateTime
5379459703502300237.94597000035.0230020001751150141320964238822015-11-03 14:55:17.570
2122136981167766712.21369800011.677667000233553355033912015-11-03 08:15:29.763
211656166916502311.6561660009.16502300018330047209652712015-11-03 08:13:58.740
212032188842948112.0321880008.429481000168589621721902015-11-03 08:17:04.480
3787278368877277.8727830006.88772700020663181799406802015-11-03 20:39:13.200
67708143465118647.0814340006.5118640004362949522042755302015-11-03 12:03:20.533
1602434460233446.0243440006.0233440006023344277612011452015-11-03 19:57:28.317
1580533257633285.8053320005.7633280005763328299370835532015-11-01 17:21:56.840
3556731855439835.5673180005.54398300016631951277070702015-11-03 19:41:05.813
2559081951687955.5908190005.168795000103375906675502015-11-03 08:15:26.550
155668447950281906.6844790005.028190000779369579205888885562015-11-03 12:39:40.740
3501328649696175.0132860004.96961700014908852276392642015-11-03 19:41:05.843
9729152847537167.2915280004.75371600042783444287597055412015-11-03 13:03:35.940
31528785046508785.2878500004.650878000144177246188306832982015-11-03 10:51:16.177
5393862532023833.9386250003.20238300016011916182342736052015-11-03 12:19:34.567
46358659631282653.5865960003.128265000143900231277596181692015-11-03 12:15:10.193
5294356827379562.9435680002.737956000136897839700402015-11-02 16:28:30.753
25295580924891022.9558090002.48910200062227559162926202015-11-03 10:43:55.950
214328353821674653.2835380002.16746500046383752433063240702015-11-03 13:03:36.320
1211312021131202.1131200002.113120000211312044657312015-11-04 01:28:40.567
2339269419791133.3926940001.9791130003958226423302015-11-03 08:16:12.137
2245414019496112.4541400001.9496110003899222221712592015-11-03 14:10:50.727
2209862017230982.0986200001.7230980003446197179146492015-11-03 14:10:50.760
608187274616502531.8727460001.650253000100335437840397038412015-11-03 13:03:16.353
455185298216087461.8529820001.60874600073197986899260146392015-11-03 09:49:13.683
2210812015925912.1081200001.59259100031851822812702015-11-03 08:16:49.437
10156868914301811.5686890001.430181000143018181468727852015-11-03 13:03:36.010
59161914313657901.6191430001.3657900008058161035193423172015-11-03 19:07:27.510
4136557813380761.3655780001.33807600053523054384102015-11-02...
November 4, 2015 at 2:06 am
I am using this query to see the long running querys:
SELECT TOP 100
ProcedureName = t.text,
ExecutionCount ...
November 4, 2015 at 1:34 am
They (stakeholders) told me to focus on the server performance and issues instead of the PDA side.
Maybe theys believe that the problem is related with that.
I'm thinking in measuring the...
November 4, 2015 at 12:59 am
spaghettidba (11/3/2015)
On the subscribers, path C:\Program Files\Microsoft SQL Server\100\COM\replmerge.log
The subscribers are the PDAs... I don't have access to them...
November 3, 2015 at 10:51 am
are you refering to:
TransferIN Threads Available1
TransferIN Threads Busy0
TransferOUT Threads Available1
TransferOUT Threads Busy0
Sync Threads Available2
Sync Threads Busy2
Max Threads Per Pool20
Sessions Since Restart399
Total Active Sessions6
Total TransferIN Requests Queued0
Total TransferOUT Requests Queued0
Total Sync...
November 3, 2015 at 10:50 am
Where can I find the agent log of the subscribers?
November 3, 2015 at 10:31 am
Thing is:
Since 23 of october the sincronization between the PDAs and the central database as became slower than usual.
Sincronization was taking in average 7 secunds and now is taking around...
November 3, 2015 at 10:18 am
It seems like your answer is based on the fact that I will create a column (identity) on an archical already publicated.
But the question is :
Suppose I create a...
November 3, 2015 at 3:17 am
Viewing 15 posts - 241 through 255 (of 771 total)