-
Notifications
You must be signed in to change notification settings - Fork 9.1k
Expand file tree
/
Copy pathSQL2019_LatchWaits.htm
More file actions
122 lines (122 loc) · 34.1 KB
/
SQL2019_LatchWaits.htm
File metadata and controls
122 lines (122 loc) · 34.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;" />
<META NAME="GENERATOR" Content="Microsoft System Monitor" />
</HEAD>
<BODY>
<OBJECT ID="DISystemMonitor1" WIDTH="100%" HEIGHT="100%"
CLASSID="CLSID:C4D2D8E0-D1DD-11CE-940F-008029004347">
<PARAM NAME="_Version" VALUE="458755"/>
<PARAM NAME="_ExtentX" VALUE="48736"/>
<PARAM NAME="_ExtentY" VALUE="26670"/>
<PARAM NAME="DisplayType" VALUE="1"/>
<PARAM NAME="ReportValueType" VALUE="0"/>
<PARAM NAME="MaximumScale" VALUE="150"/>
<PARAM NAME="MinimumScale" VALUE="0"/>
<PARAM NAME="ShowLegend" VALUE="1"/>
<PARAM NAME="ShowToolbar" VALUE="1"/>
<PARAM NAME="ShowScaleLabels" VALUE="1"/>
<PARAM NAME="ShowHorizontalGrid" VALUE="0"/>
<PARAM NAME="ShowVerticalGrid" VALUE="0"/>
<PARAM NAME="ShowValueBar" VALUE="1"/>
<PARAM NAME="ManualUpdate" VALUE="1"/>
<PARAM NAME="Highlight" VALUE="1"/>
<PARAM NAME="ReadOnly" VALUE="0"/>
<PARAM NAME="MonitorDuplicateInstances" VALUE="1"/>
<PARAM NAME="UpdateInterval" VALUE="1"/>
<PARAM NAME="DisplayFilter" VALUE="1"/>
<PARAM NAME="BackColorCtl" VALUE="-2147483633"/>
<PARAM NAME="ForeColor" VALUE="-1"/>
<PARAM NAME="BackColor" VALUE="-1"/>
<PARAM NAME="GridColor" VALUE="8421504"/>
<PARAM NAME="TimeBarColor" VALUE="255"/>
<PARAM NAME="BorderStyle" VALUE="0"/>
<PARAM NAME="TimeAxisLabels" VALUE="1"/>
<PARAM NAME="Tooltip" VALUE="1"/>
<PARAM NAME="NextCounterColor" VALUE="8"/>
<PARAM NAME="NextCounterWidth" VALUE="1"/>
<PARAM NAME="NextCounterLineStyle" VALUE="0"/>
<PARAM NAME="MaximumSamples" VALUE="180"/>
<PARAM NAME="GraphTitle" VALUE=""/>
<PARAM NAME="YAxisLabel" VALUE=""/>
<PARAM NAME="DigitGrouping" VALUE="1"/>
<PARAM NAME="WrapTimeLine" VALUE="1"/>
<PARAM NAME="DataSourceType" VALUE="1"/>
<PARAM NAME="SqlDsnName" VALUE=""/>
<PARAM NAME="SqlLogSetName" VALUE=""/>
<PARAM NAME="LogFileCount" VALUE="0"/>
<PARAM NAME="AmbientFont" VALUE="-1"/>
<PARAM NAME="LegendColumnWidths" VALUE=" 7.97579757975798E-02 7.97579757975798E-02 0.114961496149615 0.11001100110011 0.1001100110011 0.15951595159516 0.16006600660066"/>
<PARAM NAME="LegendSortDirection" VALUE="0"/>
<PARAM NAME="LegendSortColumn" VALUE="-2"/>
<PARAM NAME="CounterCount" VALUE="5"/>
<PARAM NAME="MaximumSamples" VALUE="180"/>
<PARAM NAME="SampleCount" VALUE="157"/>
<PARAM NAME="SamplesSoFar" VALUE="157"/>
<PARAM NAME="SampleIndex" VALUE="157"/>
<PARAM NAME="StepNumber" VALUE="156"/>
<PARAM NAME="TimeStamps" VALUE="132102666220000000 132102666230000000 132102666240000000 132102666778210000 132102666788210000 132102666798210000 132102666808210000 132102666818210000 132102666828210000 132102666838210000 132102666848210000 132102666858210000 132102666868210000 132102666878210000 132102666888210000 132102666898210000 132102666908210000 132102666918210000 132102666928210000 132102666938210000 132102666948210000 132102666958210000 132102666968210000 132102666978210000 132102666988210000 132102666998210000 132102667008210000 132102667018210000 132102667028210000 132102667038210000 132102667048210000 132102667058210000 132102667068210000 132102667078210000 132102667088210000 132102667098210000 132102667108210000 132102667118210000 132102667128210000 132102667138210000 132102667148210000 132102667158210000 132102667168210000 132102667178210000 132102667188210000 132102667198210000 132102667208210000 132102667218210000 132102667228210000 132102667238210000 132102667248210000 132102667258210000 132102667268210000 132102667278210000 132102667288210000 132102667298210000 132102667308210000 132102667318210000 132102667328210000 132102667338210000 132102667348210000 132102667358210000 132102667368210000 132102667378210000 132102667388210000 132102667398210000 132102667408210000 132102667418210000 132102667428210000 132102667438210000 132102667448210000 132102667458210000 132102667468210000 132102667478210000 132102667488210000 132102667498210000 132102667508210000 132102667518210000 132102667528210000 132102667538210000 132102667548210000 132102667558210000 132102667568210000 132102667578210000 132102667588210000 132102667598210000 132102667608210000 132102667618210000 132102667628210000 132102667638210000 132102667648210000 132102667658210000 132102667668210000 132102667756000000 132102667766000000 132102667776000000 132102667786000000 132102667796000000 132102667806000000 132102667816000000 132102667826000000 132102667836000000 132102667846000000 132102667856000000 132102667866000000 132102667876000000 132102667886000000 132102667896000000 132102667906000000 132102667916000000 132102667926000000 132102667936000000 132102667946000000 132102667956000000 132102667966000000 132102667976000000 132102667986000000 132102667996000000 132102668006000000 132102668016000000 132102668026000000 132102668036000000 132102668046000000 132102668056000000 132102668066000000 132102668076000000 132102668086000000 132102668096000000 132102668106000000 132102668116000000 132102668126000000 132102668136000000 132102668146000000 132102668156000000 132102668166000000 132102668176000000 132102668186000000 132102668196000000 132102668206000000 132102668216000000 132102668226000000 132102668236000000 132102668246000000 132102668256000000 132102668266000000 132102668276000000 132102668286000000 132102668296000000 132102668306000000 132102668316000000 132102668326000000 132102668336000000 132102668346000000 132102668356000000 132102668366000000 132102668376000000 132102668386000000 132102668396000000 132102668406000000 132102668416000000 132102668426000000 132102668436000000 132102668446000000 132102668456000000 132102668466000000 132102668476000000 132102668486000000 132102668496000000 132102668506000000 132102668516000000 132102668526000000 132102668536000000 132102668546000000 132102668556000000 132102668566000000 132102668576000000 132102668586000000 132102668596000000 132102668606000000 132102668616000000"/>
<PARAM NAME="Counter00001.Path" VALUE="\SQLServer:Access Methods\Page Splits/sec"/>
<PARAM NAME="Counter00001.Color" VALUE="16711935"/>
<PARAM NAME="Counter00001.Width" VALUE="2"/>
<PARAM NAME="Counter00001.LineStyle" VALUE="0"/>
<PARAM NAME="Counter00001.ScaleFactor" VALUE="-1"/>
<PARAM NAME="Counter00001.Show" VALUE="1"/>
<PARAM NAME="Counter00001.Selected" VALUE="0"/>
<PARAM NAME="Counter00001.Minimum" VALUE="0"/>
<PARAM NAME="Counter00001.Maximum" VALUE="712.830773974258"/>
<PARAM NAME="Counter00001.Average" VALUE="260.844459008815"/>
<PARAM NAME="Counter00001.StatisticStatus" VALUE="0"/>
<PARAM NAME="Counter00001.Data" VALUE="0 0 0 0 0.992715848192304 20.9982298492237 137.996053312875 186.82813679696 216.995594989422 354.008248392188 350.989470315891 298.705655447122 330.002178014375 303.695241824829 371.001298504545 368.640096673618 324.999545000637 342.979455530614 350.674994415176 315.663124313732 342.005608891986 329.671317696257 339.001762809167 352.64161033142 305.696138038789 391.999608000392 316.00856383208 321.993399135318 319.678722883502 306.999815800111 337.648170606228 370.020573143867 314.994235605488 358.002148012888 344.6664662606 341.992954945128 384.754152248538 329.685776486431 352.000035200003 334.998492506784 254.757165469874 239.005712236522 275.693373829627 336.014515827084 379.61723194503 337.681600019342 367.983440745166 308.693066483995 325.99494707832 276.783002126333 297.638577475372 311.727861576843 260.957463933379 30.9696683068603 2.03055559757678 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 204.587469825843 579.022118644932 574.14020503807 585.773364285358 542.482580115086 555.55877522072 494.501542445215 496.948317374993 476.008044535953 505.52162488637 533.954026558313 583.431504342169 605.350519427706 513.490463413155 524.623058332588 609.836929605024 573.411794181529 521.010576514703 537.505226439063 444.960532000812 673.399596919387 579.942063787828 551.971739046961 593.4468481928 545.015805458358 487.554424011895 588.977206582105 539.90853949341 552.489334108483 498.028288006759 525.387282579093 424.612668323955 549.930928675358 603.564286941257 712.830773974258 569.606800425666 476.390791455886 601.033417458011 535.9542295088 511.979367231501 442.586181919905 554.006094067035 584.973091237803 456.985833439163 506.494316074831 647.48414937819 513.893932292375 585.471904342283 547.973642467797 648.942373917196 554.492306843854 517.504592853262 476.537520336513 489.97765701884 497.989193634498 470.544136840229 631.327131543201 525.94658159173 634.99873000254 563.464877405928 574.992237604792 545.575534527123 605.135913526178 559.306236544191 479.045358409761 516.560097421036 617.997466210389 524.494439809468 552.976000841563 518.483227766885 495.979912813531 588.393836669463 470.630978249954 521.909292165022 553.459049125385 707.221843805261 268.742168763289 3.04811665508213 0 0 0 0 0 0 0 -1"/>
<PARAM NAME="Counter00002.Path" VALUE="\SQLServer:SQL Statistics\Batch Requests/sec"/>
<PARAM NAME="Counter00002.Color" VALUE="16711680"/>
<PARAM NAME="Counter00002.Width" VALUE="2"/>
<PARAM NAME="Counter00002.LineStyle" VALUE="0"/>
<PARAM NAME="Counter00002.ScaleFactor" VALUE="-1"/>
<PARAM NAME="Counter00002.Show" VALUE="-1"/>
<PARAM NAME="Counter00002.Selected" VALUE="1"/>
<PARAM NAME="Counter00002.Minimum" VALUE="0"/>
<PARAM NAME="Counter00002.Maximum" VALUE="1448.99855100145"/>
<PARAM NAME="Counter00002.Average" VALUE="592.536414310531"/>
<PARAM NAME="Counter00002.StatisticStatus" VALUE="0"/>
<PARAM NAME="Counter00002.Data" VALUE="0 1.99916275064003 0 0 29.7814754457691 251.978758190685 1205.96550938643 1316.78868608767 1248.97464581469 1332.03103632315 1423.95728128156 1383.63656452931 1351.00891665885 1413.58147099386 1390.00486501703 1422.6111047784 1422.99800780279 1414.91524657673 1414.68886635866 1393.51284309385 1375.02255036983 1438.5657499473 1380.00717603732 1346.63141848939 1405.6028307862 1448.99855100145 1407.03813073334 1419.97089059674 1370.62252436302 1401.9991588005 1357.58539601735 1336.07428573029 1383.97467326348 1376.00825604954 1316.72580443904 1318.97282915972 1424.30099104142 1391.67359589575 1395.00013950001 1397.99370902831 1049.99914081897 1017.02430688093 983.905700080371 1368.05910015313 1421.56663436257 1368.70944386538 1362.93866775995 1415.59247640071 1407.97817633827 1355.93694543478 1331.38330125728 1338.83120036208 1172.80883216036 567.444245106343 3.04583339636516 0 2.00007180257771 0 0 0 0 1.99999180003362 0 0.682790335594409 0 0 0 0 2.02043937080689 0 0 601.786557585285 781.02983533971 829.202491248363 859.667394684996 864.175749170441 923.266741553858 714.2800057542 695.927623527153 687.011610496217 839.20585949516 772.933450429918 904.119026420656 867.06972089645 935.072127927458 823.408381078195 841.774909389229 812.166879215301 834.01693054369 794.268875500102 807.92833675653 937.164424199384 819.918090182791 856.956123846459 877.182378305182 901.026129757763 738.325244558998 841.967415861006 817.861454269647 793.266783512 704.039989471402 798.751265197615 663.39485121672 830.895639507678 999.278620763671 1048.75102650631 863.403992224168 764.022967429252 841.046762199978 830.929038660099 754.969574726138 799.252698726691 914.010054110595 808.962787711765 726.977463698625 869.13225835326 949.243737514322 762.842549297825 811.268236051082 898.956760179835 877.922040522801 889.185861425279 820.214808363953 710.310643520463 720.96712389915 787.982900771053 755.268296074763 950.986438653683 767.462848660418 992.998014003972 850.192572114263 938.98732367113 788.954955134018 892.200388207191 876.912278010356 771.462629272386 838.286115544003 876.996404314742 829.200733413063 824.96419655387 788.214386720755 885.964118453203 825.149930541556 766.399066491964 817.857856304574 824.19443236181 1090.79979298778 1022.01947451615 94.491616307546 1.96933140509531 0 0 0 0.442108813058975 0 1.98012881331969 -1"/>
<PARAM NAME="Counter00003.Path" VALUE="\SQLServer:Wait Statistics(Average wait time (ms))\Page latch waits"/>
<PARAM NAME="Counter00003.Color" VALUE="65280"/>
<PARAM NAME="Counter00003.Width" VALUE="2"/>
<PARAM NAME="Counter00003.LineStyle" VALUE="0"/>
<PARAM NAME="Counter00003.ScaleFactor" VALUE="0"/>
<PARAM NAME="Counter00003.Show" VALUE="-1"/>
<PARAM NAME="Counter00003.Selected" VALUE="0"/>
<PARAM NAME="Counter00003.Minimum" VALUE="0"/>
<PARAM NAME="Counter00003.Maximum" VALUE="68"/>
<PARAM NAME="Counter00003.Average" VALUE="30.9363057324841"/>
<PARAM NAME="Counter00003.StatisticStatus" VALUE="0"/>
<PARAM NAME="Counter00003.Data" VALUE="0 4 4 4 4 4 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 3 3 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 23 23 23 23 55 55 55 55 55 68 68 68 68 68 54 54 54 54 54 56 56 56 56 56 59 59 59 59 59 68 68 68 68 68 54 54 54 54 54 62 62 62 62 62 59 59 59 59 59 57 57 57 57 57 67 67 67 67 67 55 55 55 55 55 57 57 57 57 57 59 59 59 59 59 57 57 57 57 57 30 30 30 30 30 0 0 0 0 0 0 0 0 0"/>
<PARAM NAME="Counter00004.Path" VALUE="\SQLServer:Wait Statistics(Waits in progress)\Page latch waits"/>
<PARAM NAME="Counter00004.Color" VALUE="16776960"/>
<PARAM NAME="Counter00004.Width" VALUE="2"/>
<PARAM NAME="Counter00004.LineStyle" VALUE="0"/>
<PARAM NAME="Counter00004.ScaleFactor" VALUE="-1"/>
<PARAM NAME="Counter00004.Show" VALUE="-1"/>
<PARAM NAME="Counter00004.Selected" VALUE="0"/>
<PARAM NAME="Counter00004.Minimum" VALUE="0"/>
<PARAM NAME="Counter00004.Maximum" VALUE="220"/>
<PARAM NAME="Counter00004.Average" VALUE="86.0509554140127"/>
<PARAM NAME="Counter00004.StatisticStatus" VALUE="0"/>
<PARAM NAME="Counter00004.Data" VALUE="0 0 0 0 0 0 6 6 6 6 6 11 11 11 11 11 14 14 14 14 14 13 13 13 13 13 7 7 7 7 7 7 7 7 7 7 9 9 9 9 9 7 7 7 7 7 7 7 7 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 91 91 91 91 91 220 220 220 220 220 204 204 204 204 204 205 205 205 205 205 175 175 175 175 175 198 198 198 198 198 215 215 215 215 215 211 211 211 211 211 203 203 203 203 203 166 166 166 166 166 134 134 134 134 134 198 198 198 198 198 187 187 187 187 187 106 106 106 106 106 104 104 104 104 104 4 4 4 4 4 0 0 0 0 0 0 0 0 0"/>
<PARAM NAME="Counter00005.Path" VALUE="\Processor Information(_Total)\% Processor Time"/>
<PARAM NAME="Counter00005.Color" VALUE="8388736"/>
<PARAM NAME="Counter00005.Width" VALUE="2"/>
<PARAM NAME="Counter00005.LineStyle" VALUE="0"/>
<PARAM NAME="Counter00005.ScaleFactor" VALUE="0"/>
<PARAM NAME="Counter00005.Show" VALUE="-1"/>
<PARAM NAME="Counter00005.Selected" VALUE="0"/>
<PARAM NAME="Counter00005.Minimum" VALUE="0"/>
<PARAM NAME="Counter00005.Maximum" VALUE="99.4146522548485"/>
<PARAM NAME="Counter00005.Average" VALUE="45.7601196285334"/>
<PARAM NAME="Counter00005.StatisticStatus" VALUE="0"/>
<PARAM NAME="Counter00005.Data" VALUE="3.60210614135154 0 0.587421188682169 8.79992256064277E-04 3.62154275533085 19.7282697878535 74.2190799957761 82.2445349795077 86.1329930444918 78.32058749648 84.5705136692196 82.2444977306414 76.3675604822762 85.1712611323557 81.4455593522844 84.9761236461566 88.8673514234044 82.6174264030009 79.7080273595231 81.4640887317059 82.0314817938849 90.2442625620247 80.2736864420763 79.9031680423571 85.1712596509813 89.062643279373 83.593959997312 83.7892788447356 80.8787207346166 83.5939665596414 81.2689614303441 79.2971636288583 76.7581121445421 79.8830695084033 81.4640228009938 78.5159594478407 89.8875029961537 80.8787326347004 85.156439997568 83.0080342939473 81.0738489427153 80.6643171645817 72.6839075436121 79.4924730038725 86.1468294086385 80.2933870336445 85.3517665400918 83.8054472679096 83.5939780437052 77.561777481189 85.3663780056315 86.5370819748349 81.640854997056 88.8784250150498 19.5058908678226 0 0.589648006129373 2.39999424000992E-04 0.391825258914369 1.75963727074676 3.70978451741421 0.198643365311602 1.34512665436803 1.15812457824856 0.58723236597924 1.58938101930138 3.65214103486881 0.394056405054022 0.761745717945594 0.191371655057615 3.73827294634088E-03 46.3913453131425 78.7112210118826 74.6097787825616 75.5862671440203 76.1958931046788 77.1715560823111 65.4645811336806 67.9692464766796 68.1644834123706 69.952270273845 70.5082494270835 70.9278261533242 79.3178479068681 70.5376465253638 75.0251322094576 77.3441940537965 71.122967781199 73.2425672798014 72.2936162182579 68.7504906172973 71.5131474184779 73.0472546431605 75.3909546830163 70.3425193019626 71.2894332373679 70.9277767804508 68.7504999920001 70.3129423371592 74.0496291142978 64.6489349149112 76.5787095936938 71.9034028500589 73.8285330405912 79.1226607268034 74.2191573373141 73.2692255053239 71.1228350805069 66.9927741300657 73.2425431984298 71.8753656202469 74.0496757777887 74.8050402099411 71.6800764789293 72.8519174954561 75.8057442645066 74.2447730812787 73.8284942525322 71.7082844369196 74.2191650714423 66.211396146152 70.1473669825073 76.1959554106976 66.0499197660604 74.6097710095265 71.0941517912901 72.4887786049297 76.000863925103 75.2451662352023 74.2191006202316 75.2203696401829 76.5628304640905 71.8721409412697 69.1410828837567 74.880337862527 77.9299901521339 70.3425400411923 75.9768819097824 73.6593955720491 74.6097786264756 70.7326244413007 74.4145203044426 74.63505200984 77.9519915605365 72.8519455023739 73.6595087219594 75.610629359899 99.4146522548485 46.2280851200438 2.50008393838715 0 0.546293586637725 0.977837385897717 4.28476612125553 4.32308590677014 1.92444324716887 -1"/>
<PARAM NAME="Selected: %s" VALUE="\SQLServer:SQL Statistics\Batch Requests/sec"/>
</OBJECT>
</BODY>
</HTML>