Pahalı sorgular0x1F0DEF231B5DF11B
Demo modu

Sorgu 0x1F0DEF231B5DF11B

SQL-1 · DB-11· rag.usp_PlanChange_Detect · dönem 2026-09-12 → 2026-10-11 · 1.042 çalışma · Pahalı sorgulara dön

Ort. süre 0,8 ms
Ort. CPU 0,8 ms
Bekleme payı %0,3
Ort. mantıksal okuma 11
En büyük bellek izni –

Önceki dönemde çalışma yok; değişim hesaplanmadı.

Takip

Yeni

Bu sorgu henüz analiz edilmedi.

Bilinen sorgu, ertele:

Günlük trend

28.09.2026: 53 çalışma, ort. 0,8 ms29.09.2026: 107 çalışma, ort. 0,8 ms30.09.2026: 349 çalışma, ort. 0,8 ms1.10.2026: 49 çalışma, ort. 0,8 ms2.10.2026: 83 çalışma, ort. 0,8 ms3.10.2026: 1 çalışma, ort. 1,8 ms4.10.2026: 57 çalışma, ort. 1,1 ms5.10.2026: 211 çalışma, ort. 0,8 ms6.10.2026: 50 çalışma, ort. 0,8 ms7.10.2026: 49 çalışma, ort. 0,8 ms9.10.2026: 33 çalışma, ort. 1,0 ms max 349 çalışma max ort. süre 1,8 ms 28.09.2026 9.10.2026
Çalışma sayısı (sol ölçek)Ortalama süre (sağ ölçek)

Ne değişti, ne zaman

Dönemden 14 gün öncesinden itibaren: planlar, plan değişimleri, nesne tanımı, analizler, uygulanan öneriler.
  1. 9.10.2026 19:00 yeni plan plan 82566
  2. 9.10.2026 19:00 yeni plan plan 82541
  3. 9.10.2026 17:00 yeni plan plan 81581
  4. 9.10.2026 17:00 yeni plan plan 81546
  5. 9.10.2026 14:00 yeni plan plan 80967
  6. 9.10.2026 14:00 yeni plan plan 80538
  7. 9.10.2026 14:00 yeni plan plan 80503
  8. 9.10.2026 14:00 yeni plan plan 79617
  9. 9.10.2026 14:00 yeni plan plan 79601
  10. 9.10.2026 13:00 yeni plan plan 78696
  11. 9.10.2026 13:00 yeni plan plan 78658
  12. 8.10.2026 20:00 yeni plan plan 77616
  13. 8.10.2026 19:00 yeni plan plan 77194
  14. 8.10.2026 19:00 yeni plan plan 77172
  15. 8.10.2026 18:00 yeni plan plan 76288
  16. 8.10.2026 18:00 yeni plan plan 76266
  17. 8.10.2026 17:00 yeni plan plan 75362
  18. 8.10.2026 17:00 yeni plan plan 75329
  19. 8.10.2026 16:00 yeni plan plan 74454
  20. 8.10.2026 16:00 yeni plan plan 74430
  21. 8.10.2026 16:00 yeni plan plan 73591
  22. 8.10.2026 16:00 yeni plan plan 73555
  23. 8.10.2026 14:00 yeni plan plan 72602
  24. 8.10.2026 14:00 yeni plan plan 72575
  25. 8.10.2026 12:00 yeni plan plan 70782
  26. 8.10.2026 12:00 yeni plan plan 70814
  27. 8.10.2026 12:00 yeni plan plan 71663
  28. 8.10.2026 12:00 yeni plan plan 71698
  29. 8.10.2026 08:00 yeni plan plan 70237
  30. 7.10.2026 20:00 yeni plan plan 69814
  31. 7.10.2026 20:00 yeni plan plan 69774
  32. 7.10.2026 20:00 yeni plan plan 68922
  33. 7.10.2026 20:00 yeni plan plan 68903
  34. 7.10.2026 20:00 yeni plan plan 67339
  35. 7.10.2026 20:00 yeni plan plan 67307
  36. 7.10.2026 20:00 yeni plan plan 66818
  37. 7.10.2026 20:00 yeni plan plan 66392
  38. 7.10.2026 20:00 yeni plan plan 66369
  39. 7.10.2026 13:00 yeni plan plan 65354
  40. 7.10.2026 13:00 yeni plan plan 65325
  41. 6.10.2026 03:00 yeni plan plan 64560
  42. 6.10.2026 00:00 yeni plan plan 63994
  43. 6.10.2026 00:00 yeni plan plan 63958
  44. 5.10.2026 23:00 yeni plan plan 63067
  45. 5.10.2026 23:00 yeni plan plan 63051
  46. 5.10.2026 22:00 yeni plan plan 61469
  47. 5.10.2026 22:00 yeni plan plan 61438
  48. 5.10.2026 22:00 yeni plan plan 60589
  49. 5.10.2026 22:00 yeni plan plan 60553
  50. 5.10.2026 21:00 yeni plan plan 58033
  51. 5.10.2026 21:00 yeni plan plan 58072
  52. 5.10.2026 21:00 yeni plan plan 58895
  53. 5.10.2026 21:00 yeni plan plan 58923
  54. 5.10.2026 21:00 yeni plan plan 59716
  55. 5.10.2026 21:00 yeni plan plan 59734
  56. 5.10.2026 20:00 yeni plan plan 57176
  57. 5.10.2026 20:00 yeni plan plan 57137
  58. 5.10.2026 18:00 yeni plan plan 56321
  59. 5.10.2026 18:00 yeni plan plan 56291
  60. 5.10.2026 17:00 yeni plan plan 55483
  61. 5.10.2026 17:00 yeni plan plan 55443
  62. 5.10.2026 17:00 yeni plan plan 54658
  63. 5.10.2026 17:00 yeni plan plan 54622
  64. 5.10.2026 13:00 yeni plan plan 53771
  65. 5.10.2026 13:00 yeni plan plan 53750
  66. 5.10.2026 13:00 yeni plan plan 52951
  67. 5.10.2026 13:00 yeni plan plan 52931
  68. 5.10.2026 12:00 yeni plan plan 51440
  69. 5.10.2026 12:00 yeni plan plan 51404
  70. 5.10.2026 12:00 yeni plan plan 49901
  71. 5.10.2026 12:00 yeni plan plan 49870
  72. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  73. 5.10.2026 10:00 yeni plan plan 47291
  74. 5.10.2026 10:00 yeni plan plan 47306
  75. 5.10.2026 10:00 yeni plan plan 48094
  76. 5.10.2026 10:00 yeni plan plan 48116
  77. 5.10.2026 10:00 yeni plan plan 48976
  78. 5.10.2026 10:00 yeni plan plan 49009
  79. 5.10.2026 09:00 yeni plan plan 45632
  80. 5.10.2026 09:00 yeni plan plan 45597
  81. 5.10.2026 09:00 yeni plan plan 44792
  82. 5.10.2026 09:00 yeni plan plan 44393
  83. 5.10.2026 09:00 yeni plan plan 44362
  84. 5.10.2026 09:00 yeni plan plan 43607
  85. 5.10.2026 09:00 yeni plan plan 43576
  86. 5.10.2026 08:00 yeni plan plan 43237
  87. 5.10.2026 03:00 yeni plan plan 43045
  88. 5.10.2026 02:00 yeni plan plan 42651
  89. 5.10.2026 02:00 yeni plan plan 42627
  90. 5.10.2026 00:00 yeni plan plan 41846
  91. 5.10.2026 00:00 yeni plan plan 41820
  92. 4.10.2026 22:00 yeni plan plan 41404
  93. 4.10.2026 22:00 yeni plan plan 40996
  94. 4.10.2026 22:00 yeni plan plan 40978
  95. 4.10.2026 21:00 yeni plan plan 40570
  96. 4.10.2026 15:00 yeni plan plan 40423
  97. 4.10.2026 14:00 yeni plan plan 40408
  98. 4.10.2026 13:00 yeni plan plan 40030
  99. 4.10.2026 13:00 yeni plan plan 40004
  100. 4.10.2026 13:00 yeni plan plan 39281
  101. 4.10.2026 13:00 yeni plan plan 39258
  102. 4.10.2026 13:00 yeni plan plan 38866
  103. 4.10.2026 13:00 yeni plan plan 38504
  104. 4.10.2026 13:00 yeni plan plan 38487
  105. 4.10.2026 10:00 yeni plan plan 37996
  106. 4.10.2026 09:00 yeni plan plan 37820
  107. 4.10.2026 08:00 yeni plan plan 37474
  108. 4.10.2026 08:00 yeni plan plan 37440
  109. 3.10.2026 03:00 yeni plan plan 36991
  110. 2.10.2026 17:00 yeni plan plan 36539
  111. 2.10.2026 17:00 yeni plan plan 36521
  112. 2.10.2026 17:00 yeni plan plan 35827
  113. 2.10.2026 17:00 yeni plan plan 35806
  114. 2.10.2026 17:00 yeni plan plan 35077
  115. 2.10.2026 17:00 yeni plan plan 35060
  116. 2.10.2026 16:00 yeni plan plan 34132
  117. 2.10.2026 16:00 yeni plan plan 34116
  118. 2.10.2026 02:00 yeni plan plan 33711
  119. 2.10.2026 02:00 yeni plan plan 33671
  120. 2.10.2026 01:00 yeni plan plan 33010
  121. 2.10.2026 01:00 yeni plan plan 32973
  122. 2.10.2026 00:00 yeni plan plan 31785
  123. 2.10.2026 00:00 yeni plan plan 31751
  124. 1.10.2026 21:00 yeni plan plan 31120
  125. 1.10.2026 21:00 yeni plan plan 31092
  126. 1.10.2026 21:00 yeni plan plan 30703
  127. 1.10.2026 20:00 yeni plan plan 29617
  128. 1.10.2026 20:00 yeni plan plan 29657
  129. 1.10.2026 20:00 yeni plan plan 30267
  130. 1.10.2026 20:00 yeni plan plan 30283
  131. 1.10.2026 19:00 yeni plan plan 28913
  132. 1.10.2026 19:00 yeni plan plan 28892
  133. 1.10.2026 19:00 yeni plan plan 28240
  134. 1.10.2026 19:00 yeni plan plan 28213
  135. 1.10.2026 19:00 yeni plan plan 27572
  136. 1.10.2026 19:00 yeni plan plan 27542
  137. 30.09.2026 22:00 yeni plan plan 26867
  138. 30.09.2026 22:00 yeni plan plan 26841
  139. 30.09.2026 22:00 yeni plan plan 26211
  140. 30.09.2026 22:00 yeni plan plan 26195
  141. 30.09.2026 22:00 yeni plan plan 25537
  142. 30.09.2026 22:00 yeni plan plan 25515
  143. 30.09.2026 22:00 yeni plan plan 24577
  144. 30.09.2026 22:00 yeni plan plan 24565
  145. 30.09.2026 22:00 yeni plan plan 24311
  146. 30.09.2026 22:00 yeni plan plan 24271
  147. 30.09.2026 22:00 yeni plan plan 24071
  148. 30.09.2026 22:00 yeni plan plan 23779
  149. 30.09.2026 22:00 yeni plan plan 23741
  150. 30.09.2026 22:00 yeni plan plan 23117
  151. 30.09.2026 22:00 yeni plan plan 23095
  152. 30.09.2026 21:00 yeni plan plan 20457
  153. 30.09.2026 21:00 yeni plan plan 20497
  154. 30.09.2026 21:00 yeni plan plan 20757
  155. 30.09.2026 21:00 yeni plan plan 21124
  156. 30.09.2026 21:00 yeni plan plan 21141
  157. 30.09.2026 21:00 yeni plan plan 21774
  158. 30.09.2026 21:00 yeni plan plan 21790
  159. 30.09.2026 21:00 yeni plan plan 22417
  160. 30.09.2026 21:00 yeni plan plan 22448
  161. 30.09.2026 20:00 yeni plan plan 19796
  162. 30.09.2026 20:00 yeni plan plan 19760
  163. 30.09.2026 20:00 yeni plan plan 19355
  164. 30.09.2026 19:00 yeni plan plan 19067
  165. 30.09.2026 19:00 yeni plan plan 19041
  166. 30.09.2026 15:00 yeni plan plan 18406
  167. 30.09.2026 15:00 yeni plan plan 18372
  168. 30.09.2026 15:00 yeni plan plan 17764
  169. 30.09.2026 15:00 yeni plan plan 17740
  170. 30.09.2026 15:00 yeni plan plan 17104
  171. 30.09.2026 15:00 yeni plan plan 17088
  172. 30.09.2026 11:00 yeni plan plan 15573
  173. 30.09.2026 11:00 yeni plan plan 15562
  174. 30.09.2026 11:00 yeni plan plan 15243
  175. 30.09.2026 11:00 yeni plan plan 15229
  176. 30.09.2026 11:00 yeni plan plan 14623
  177. 30.09.2026 11:00 yeni plan plan 14591
  178. 30.09.2026 10:00 yeni plan plan 12889
  179. 30.09.2026 10:00 yeni plan plan 12904
  180. 30.09.2026 10:00 yeni plan plan 13985
  181. 30.09.2026 10:00 yeni plan plan 14023
  182. 30.09.2026 06:00 yeni plan plan 11986
  183. 30.09.2026 06:00 yeni plan plan 11975
  184. 30.09.2026 06:00 yeni plan plan 11234
  185. 30.09.2026 06:00 yeni plan plan 11200
  186. 30.09.2026 06:00 yeni plan plan 10656
  187. 30.09.2026 06:00 yeni plan plan 10637
  188. 30.09.2026 05:00 yeni plan plan 10110
  189. 30.09.2026 05:00 yeni plan plan 10074
  190. 30.09.2026 03:00 yeni plan plan 9492
  191. 30.09.2026 00:00 yeni plan plan 9052
  192. 30.09.2026 00:00 yeni plan plan 9038
  193. 29.09.2026 21:00 yeni plan plan 8611
  194. 29.09.2026 21:00 yeni plan plan 8582
  195. 29.09.2026 21:00 yeni plan plan 8192
  196. 29.09.2026 21:00 yeni plan plan 8154
  197. 29.09.2026 20:00 yeni plan plan 7690
  198. 29.09.2026 20:00 yeni plan plan 7674
  199. 29.09.2026 13:00 yeni plan plan 7031
  200. 28.09.2026 19:00 yeni plan plan 6578
  201. 28.09.2026 19:00 yeni plan plan 6568
  202. 28.09.2026 19:00 yeni plan plan 6483
  203. 28.09.2026 16:00 yeni plan plan 6111
  204. 28.09.2026 16:00 yeni plan plan 6075
  205. 28.09.2026 16:00 yeni plan plan 6035
  206. 28.09.2026 16:00 yeni plan plan 6002

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,80,8 1,112
2026-09-291070,80,8 1,010
2026-09-303490,80,8 1,010
2026-10-01490,80,8 2,210
2026-10-02830,80,8 1,010
2026-10-0311,81,8 1,842
2026-10-04571,11,1 2,220
2026-10-052110,80,8 1,710
2026-10-06500,80,8 2,012
2026-10-07490,80,8 1,511
2026-10-09331,01,0 3,211

Planlar

QDS, dönem içinde; ham veri 14 gün saklanır
PlanÇalışmaOrt. süre msOrt. CPU ms Ort. readsSon çalışma
1011020,60,67 30.09.2026 05:49 en iyi
1398560,70,711 30.09.2026 10:56
4000460,70,711 4.10.2026 13:45
3371120,70,77 2.10.2026 02:27
2686720,70,77 30.09.2026 22:56
3367160,70,711 2.10.2026 02:27
2961760,70,711 1.10.2026 20:57
2757220,70,77 1.10.2026 19:13
12904120,70,711 30.09.2026 10:52
5713760,70,711 5.10.2026 20:19
815460,70,711 29.09.2026 21:26
1904160,70,711 30.09.2026 19:36
1710460,70,711 30.09.2026 15:32
1065620,70,77 30.09.2026 06:32
5807220,70,77 5.10.2026 21:02
6535420,70,77 7.10.2026 13:55
858260,70,711 29.09.2026 21:50
6981420,70,77 7.10.2026 20:53
5629160,70,711 5.10.2026 18:28
5544360,70,711 5.10.2026 17:58
1063760,70,711 30.09.2026 06:32
3848720,70,77 4.10.2026 13:28
6636960,70,711 7.10.2026 20:12
7536220,70,77 8.10.2026 17:17
6055360,70,711 5.10.2026 22:04
11975120,70,711 30.09.2026 07:00
8256620,70,77 9.10.2026 19:25
4811620,70,77 5.10.2026 10:03
23741120,70,711 30.09.2026 22:19
2457740,70,77 30.09.2026 22:38
611160,70,77 28.09.2026 17:03
861120,70,77 29.09.2026 21:50
6305120,70,77 5.10.2026 23:04
1123440,70,77 30.09.2026 06:59
5632120,70,77 5.10.2026 18:28
24565120,70,711 30.09.2026 22:38
2377940,70,77 30.09.2026 22:19
1007460,70,611 30.09.2026 05:49
8053820,70,77 9.10.2026 14:29
2241760,70,711 30.09.2026 21:37
1840620,70,77 30.09.2026 15:51
4809460,70,711 5.10.2026 10:03
5295160,70,711 5.10.2026 13:19
4357660,70,711 5.10.2026 09:01
3028360,70,711 1.10.2026 20:58
11200120,70,711 30.09.2026 06:59
2311720,70,77 30.09.2026 22:15
2551560,70,711 30.09.2026 22:40
1776420,70,77 30.09.2026 15:42
6532560,70,711 7.10.2026 13:55
4436260,70,711 5.10.2026 09:09
7717260,70,711 8.10.2026 19:59
5375060,70,711 5.10.2026 13:58
2177420,70,77 30.09.2026 21:34
769020,70,77 29.09.2026 20:13
7719420,70,77 8.10.2026 19:59
4184620,70,77 5.10.2026 00:27
2309560,70,711 30.09.2026 22:15
7081420,70,77 8.10.2026 12:20
7960120,70,77 9.10.2026 14:27
4900920,70,77 5.10.2026 10:42
67307120,70,711 7.10.2026 20:50
3413270,70,711 2.10.2026 16:25
3506020,70,77 2.10.2026 17:24
1288940,70,77 30.09.2026 10:52
63958360,70,711 6.10.2026 05:50
1459160,70,711 30.09.2026 11:02
2112460,70,711 30.09.2026 21:32
1198640,70,77 30.09.2026 07:00
1522920,70,77 30.09.2026 11:08
819220,70,77 29.09.2026 21:26
6306760,70,711 5.10.2026 23:04
4439320,70,77 5.10.2026 09:09
3026720,70,77 1.10.2026 20:58
4897660,70,711 5.10.2026 10:42
3301020,70,77 2.10.2026 01:09
2889260,70,711 1.10.2026 19:31
4003020,70,77 4.10.2026 13:45
5803360,80,711 5.10.2026 21:02
36539180,80,811 2.10.2026 18:17
1708820,80,87 30.09.2026 15:32
5465820,80,87 5.10.2026 17:49
5462260,80,811 5.10.2026 17:49
5293120,80,87 5.10.2026 13:19
4729120,80,87 5.10.2026 10:00
1524360,80,811 30.09.2026 11:08
6075180,80,811 28.09.2026 17:03
6058920,80,87 5.10.2026 22:04
767460,80,811 29.09.2026 20:13
4990140,80,87 5.10.2026 12:33
6890360,80,811 7.10.2026 20:51
1837260,80,811 30.09.2026 15:51
2553720,80,87 30.09.2026 22:40
3109260,80,811 1.10.2026 21:13
4360720,80,87 5.10.2026 09:01
49870120,80,811 5.10.2026 12:33
5973420,80,87 5.10.2026 21:41
5548320,80,87 5.10.2026 17:58
4182060,80,811 5.10.2026 00:27
7532960,80,811 8.10.2026 17:17
1979620,80,87 30.09.2026 20:42
2114120,80,87 30.09.2026 21:32
2179060,80,811 30.09.2026 21:34
9038200,80,87 30.09.2026 05:42
5971660,80,811 5.10.2026 21:41
4730660,80,811 5.10.2026 10:00
1976060,80,811 30.09.2026 20:42
6733940,80,87 7.10.2026 20:50
2431120,80,87 30.09.2026 22:35
6568780,80,811 29.09.2026 18:42
15562240,80,811 30.09.2026 11:22
2824020,80,87 1.10.2026 19:18
3928120,80,87 4.10.2026 13:31
6892220,80,87 7.10.2026 20:51
5717620,80,87 5.10.2026 20:19
4563240,80,87 5.10.2026 09:48
2754260,80,811 1.10.2026 19:13
3582720,80,87 2.10.2026 17:32
7869620,80,87 9.10.2026 13:15
7443060,80,811 8.10.2026 16:38
3112020,80,87 1.10.2026 21:13
1774060,80,811 30.09.2026 15:42
45597120,80,811 5.10.2026 09:49
7166360,80,811 8.10.2026 12:37
63994120,80,87 6.10.2026 05:50
7865860,80,811 9.10.2026 13:15
9052600,80,811 30.09.2026 05:42
4262760,80,811 5.10.2026 02:58
7078260,80,811 8.10.2026 12:20
7961760,80,811 9.10.2026 14:27
2891320,80,87 1.10.2026 19:31
6578260,80,87 29.09.2026 18:42
2821360,80,811 1.10.2026 19:19
2621120,80,87 30.09.2026 22:53
2427160,80,811 30.09.2026 22:35
6977460,80,711 7.10.2026 20:53
5377120,80,87 5.10.2026 13:58
5892320,80,87 5.10.2026 21:38
4099620,80,87 4.10.2026 22:07
1906720,80,87 30.09.2026 19:36
61438120,80,811 5.10.2026 22:56
3297360,80,811 2.10.2026 01:09
3850460,80,811 4.10.2026 13:29
703110,80,811 29.09.2026 13:36
4097860,80,811 4.10.2026 22:07
1557380,80,87 30.09.2026 11:22
6639220,80,87 7.10.2026 20:12
8158120,80,87 9.10.2026 17:45
8050360,80,811 9.10.2026 14:29
7260220,80,87 8.10.2026 14:01
51404120,80,811 5.10.2026 12:59
3747420,90,87 4.10.2026 08:55
8254160,90,911 9.10.2026 19:25
1402320,90,97 30.09.2026 10:56
2684160,90,911 30.09.2026 22:56
3507760,90,911 2.10.2026 17:24
7257560,90,911 8.10.2026 14:01
3925860,90,911 4.10.2026 13:31
7355560,90,911 8.10.2026 16:34
2619560,90,911 30.09.2026 22:53
7445420,90,97 8.10.2026 16:38
3178540,90,97 2.10.2026 00:06
31751120,90,911 2.10.2026 00:06
3411640,90,97 2.10.2026 16:25
6146940,90,97 5.10.2026 22:56
2075710,90,928 30.09.2026 21:30
3652160,90,97 2.10.2026 18:17
2244820,90,97 30.09.2026 21:37
5889560,90,911 5.10.2026 21:38
603511,01,031 28.09.2026 16:25
2045761,01,011 30.09.2026 21:24
648351,01,024 29.09.2026 03:30
3580661,01,011 2.10.2026 17:32
8154661,01,011 9.10.2026 17:45
600211,01,031 28.09.2026 16:24
1462321,01,07 30.09.2026 11:02
2049721,01,07 30.09.2026 21:24
4265121,11,17 5.10.2026 02:58
3744061,11,111 4.10.2026 08:55
949211,11,130 30.09.2026 03:30
7169821,11,17 8.10.2026 12:37
7359121,11,17 8.10.2026 16:34
2965721,31,37 1.10.2026 20:57
5144041,31,37 5.10.2026 12:59
7628821,41,47 8.10.2026 18:57
7626661,61,611 8.10.2026 18:57
2407111,61,660 30.09.2026 22:30
3782011,71,742 4.10.2026 09:30
3699131,71,742 4.10.2026 08:30
4140421,81,842 4.10.2026 23:30
4304511,81,843 5.10.2026 03:30
4040851,91,941 4.10.2026 20:30
4042321,91,642 4.10.2026 16:30
3886612,02,042 4.10.2026 13:30
6456022,02,050 6.10.2026 22:15
3799632,01,843 4.10.2026 12:30
4479212,12,145 5.10.2026 09:30
6681812,21,952 7.10.2026 20:40
4057012,32,341 4.10.2026 21:30
1935522,62,630 30.09.2026 20:30
7023712,92,952 8.10.2026 08:30
3070313,63,634 1.10.2026 21:13
8096714,74,755 9.10.2026 14:52
4323716,36,345 5.10.2026 08:59
7761618,17,754 8.10.2026 20:03 en kötü

Davranış

Wait kategorileri (QDS)
Memory:5
Session'da görülen wait'ler
–
Başka oturumları bloklama
0
En büyük memory grant
–

Saat dağılımı

session yakalama
00:00 — 00001:00 — 002:00 — 003:00 — 00304:00 — 005:00 — 006:00 — 00607:00 — 008:00 — 009:00 — 00910:00 — 011:00 — 012:00 — 01213:00 — 014:00 — 015:00 — 01516:00 — 017:00 — 018:00 — 01819:00 — 020:00 — 021:00 — 02122:00 — 023:00 — 0

Sorgu metni

SQL 
WITH idr AS (
            SELECT w.CaseID, t.SchemaName, t.TableName, i.IndexName, i.LastSeenUtc AS E,
                   COALESCE((SELECT MIN(l.EndUtc) FROM DBA.CollectionRunLog AS l
                             WHERE l.SourceType = 'METADATA' AND l.Status = 'OK' AND l.ServerID = w.ServerID AND l.DatabaseName = w.DatabaseName
                               AND l.StartUtc > i.LastSeenUtc), DATEADD(day, 1, i.LastSeenUtc)) AS L,
                   w.WinStart, w.ChangeUtc, w.ChangeEndUtc
            FROM #win AS w
            JOIN #ptab AS t ON t.CaseID = w.CaseID
            JOIN perf.MetaIndex AS i ON i.ServerID = w.ServerID AND i.DatabaseName = w.DatabaseName AND i.object_id = t.object_id
            WHERE i.IsDeleted = 1 AND i.IndexName IS NOT NULL)
        INSERT rag.PlanChangeEvent (CaseID, EventType, EarliestUtc, LatestUtc, ObjectName, UsedByOldPlan, UsedByNewPlan, OrderUncertain)
        SELECT d.CaseID, 'IndexDropped', d.E, d.L, CONCAT(d.SchemaName, N'.', d.TableName, N'.', d.IndexName),
               CASE WHEN EXISTS (SELECT 1 FROM #pobj AS o WHERE o.CaseID = d.CaseID AND o.PlanRole = 'Old' AND o.TableName = d.TableName AND o.IndexName = d.IndexName) THEN 1 ELSE 0 END,
               CASE WHEN EXISTS (SELECT 1 FROM #pobj AS o WHERE o.CaseID = d.CaseID AND o.PlanRole = 'New' AND o.TableName = d.TableName AND o.IndexName = d.IndexName) THEN 1 ELSE 0 END,
               CASE WHEN d.L > d.ChangeUtc THEN 1 ELSE 0 END
        FROM idr AS d
        WHERE d.L >= d.WinStart AND d.E <= d.ChangeEndUtc

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.