Pahalı sorgular0xBE690DA1C460829D
Demo modu

Sorgu 0xBE690DA1C460829D

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 2,4 ms
Ort. CPU 2,4 ms
Bekleme payı %0,8
Ort. mantıksal okuma 263
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. 1,7 ms29.09.2026: 107 çalışma, ort. 1,6 ms30.09.2026: 349 çalışma, ort. 2,0 ms1.10.2026: 49 çalışma, ort. 2,2 ms2.10.2026: 83 çalışma, ort. 1,7 ms3.10.2026: 1 çalışma, ort. 14,6 ms4.10.2026: 57 çalışma, ort. 6,7 ms5.10.2026: 211 çalışma, ort. 1,9 ms6.10.2026: 50 çalışma, ort. 3,5 ms7.10.2026: 49 çalışma, ort. 2,9 ms9.10.2026: 33 çalışma, ort. 5,3 ms max 349 çalışma max ort. süre 14,6 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 82565
  2. 9.10.2026 19:00 yeni plan plan 82540
  3. 9.10.2026 17:00 yeni plan plan 81580
  4. 9.10.2026 17:00 yeni plan plan 81545
  5. 9.10.2026 14:00 yeni plan plan 80966
  6. 9.10.2026 14:00 yeni plan plan 80537
  7. 9.10.2026 14:00 yeni plan plan 80502
  8. 9.10.2026 14:00 yeni plan plan 79616
  9. 9.10.2026 14:00 yeni plan plan 79600
  10. 9.10.2026 13:00 yeni plan plan 78695
  11. 9.10.2026 13:00 yeni plan plan 78657
  12. 8.10.2026 20:00 yeni plan plan 77611
  13. 8.10.2026 19:00 yeni plan plan 77193
  14. 8.10.2026 19:00 yeni plan plan 77171
  15. 8.10.2026 18:00 yeni plan plan 76287
  16. 8.10.2026 18:00 yeni plan plan 76265
  17. 8.10.2026 17:00 yeni plan plan 75361
  18. 8.10.2026 17:00 yeni plan plan 75328
  19. 8.10.2026 16:00 yeni plan plan 74453
  20. 8.10.2026 16:00 yeni plan plan 74429
  21. 8.10.2026 16:00 yeni plan plan 73590
  22. 8.10.2026 16:00 yeni plan plan 73554
  23. 8.10.2026 14:00 yeni plan plan 72601
  24. 8.10.2026 14:00 yeni plan plan 72574
  25. 8.10.2026 12:00 yeni plan plan 70781
  26. 8.10.2026 12:00 yeni plan plan 70813
  27. 8.10.2026 12:00 yeni plan plan 71662
  28. 8.10.2026 12:00 yeni plan plan 71697
  29. 8.10.2026 08:00 yeni plan plan 70236
  30. 7.10.2026 20:00 yeni plan plan 69813
  31. 7.10.2026 20:00 yeni plan plan 69773
  32. 7.10.2026 20:00 yeni plan plan 68921
  33. 7.10.2026 20:00 yeni plan plan 68902
  34. 7.10.2026 20:00 yeni plan plan 67338
  35. 7.10.2026 20:00 yeni plan plan 67306
  36. 7.10.2026 20:00 yeni plan plan 66817
  37. 7.10.2026 20:00 yeni plan plan 66391
  38. 7.10.2026 20:00 yeni plan plan 66368
  39. 7.10.2026 13:00 yeni plan plan 65353
  40. 7.10.2026 13:00 yeni plan plan 65324
  41. 6.10.2026 03:00 yeni plan plan 64559
  42. 6.10.2026 00:00 yeni plan plan 63993
  43. 6.10.2026 00:00 yeni plan plan 63957
  44. 5.10.2026 23:00 yeni plan plan 63066
  45. 5.10.2026 23:00 yeni plan plan 63050
  46. 5.10.2026 22:00 yeni plan plan 61468
  47. 5.10.2026 22:00 yeni plan plan 61437
  48. 5.10.2026 22:00 yeni plan plan 60588
  49. 5.10.2026 22:00 yeni plan plan 60552
  50. 5.10.2026 21:00 yeni plan plan 58032
  51. 5.10.2026 21:00 yeni plan plan 58071
  52. 5.10.2026 21:00 yeni plan plan 58894
  53. 5.10.2026 21:00 yeni plan plan 58922
  54. 5.10.2026 21:00 yeni plan plan 59715
  55. 5.10.2026 21:00 yeni plan plan 59733
  56. 5.10.2026 20:00 yeni plan plan 57175
  57. 5.10.2026 20:00 yeni plan plan 57136
  58. 5.10.2026 18:00 yeni plan plan 56320
  59. 5.10.2026 18:00 yeni plan plan 56290
  60. 5.10.2026 17:00 yeni plan plan 55482
  61. 5.10.2026 17:00 yeni plan plan 55442
  62. 5.10.2026 17:00 yeni plan plan 54657
  63. 5.10.2026 17:00 yeni plan plan 54621
  64. 5.10.2026 13:00 yeni plan plan 53770
  65. 5.10.2026 13:00 yeni plan plan 53749
  66. 5.10.2026 13:00 yeni plan plan 52950
  67. 5.10.2026 13:00 yeni plan plan 52930
  68. 5.10.2026 12:00 yeni plan plan 51439
  69. 5.10.2026 12:00 yeni plan plan 51403
  70. 5.10.2026 12:00 yeni plan plan 49900
  71. 5.10.2026 12:00 yeni plan plan 49869
  72. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  73. 5.10.2026 10:00 yeni plan plan 49008
  74. 5.10.2026 10:00 yeni plan plan 48975
  75. 5.10.2026 10:00 yeni plan plan 48115
  76. 5.10.2026 10:00 yeni plan plan 48093
  77. 5.10.2026 10:00 yeni plan plan 47305
  78. 5.10.2026 10:00 yeni plan plan 47290
  79. 5.10.2026 09:00 yeni plan plan 43575
  80. 5.10.2026 09:00 yeni plan plan 43606
  81. 5.10.2026 09:00 yeni plan plan 44361
  82. 5.10.2026 09:00 yeni plan plan 44392
  83. 5.10.2026 09:00 yeni plan plan 44791
  84. 5.10.2026 09:00 yeni plan plan 45596
  85. 5.10.2026 09:00 yeni plan plan 45631
  86. 5.10.2026 08:00 yeni plan plan 43236
  87. 5.10.2026 03:00 yeni plan plan 43044
  88. 5.10.2026 02:00 yeni plan plan 42650
  89. 5.10.2026 02:00 yeni plan plan 42626
  90. 5.10.2026 00:00 yeni plan plan 41845
  91. 5.10.2026 00:00 yeni plan plan 41819
  92. 4.10.2026 22:00 yeni plan plan 41403
  93. 4.10.2026 22:00 yeni plan plan 40995
  94. 4.10.2026 22:00 yeni plan plan 40977
  95. 4.10.2026 21:00 yeni plan plan 40569
  96. 4.10.2026 20:00 yeni plan plan 40439
  97. 4.10.2026 15:00 yeni plan plan 40422
  98. 4.10.2026 14:00 yeni plan plan 40407
  99. 4.10.2026 13:00 yeni plan plan 40029
  100. 4.10.2026 13:00 yeni plan plan 40003
  101. 4.10.2026 13:00 yeni plan plan 39280
  102. 4.10.2026 13:00 yeni plan plan 39257
  103. 4.10.2026 13:00 yeni plan plan 38865
  104. 4.10.2026 13:00 yeni plan plan 38503
  105. 4.10.2026 13:00 yeni plan plan 38486
  106. 4.10.2026 10:00 yeni plan plan 37995
  107. 4.10.2026 09:00 yeni plan plan 37819
  108. 4.10.2026 08:00 yeni plan plan 37473
  109. 4.10.2026 08:00 yeni plan plan 37439
  110. 3.10.2026 03:00 yeni plan plan 36990
  111. 2.10.2026 17:00 yeni plan plan 36538
  112. 2.10.2026 17:00 yeni plan plan 36520
  113. 2.10.2026 17:00 yeni plan plan 35826
  114. 2.10.2026 17:00 yeni plan plan 35805
  115. 2.10.2026 17:00 yeni plan plan 35076
  116. 2.10.2026 17:00 yeni plan plan 35059
  117. 2.10.2026 16:00 yeni plan plan 34131
  118. 2.10.2026 16:00 yeni plan plan 34115
  119. 2.10.2026 02:00 yeni plan plan 33710
  120. 2.10.2026 02:00 yeni plan plan 33670
  121. 2.10.2026 01:00 yeni plan plan 33009
  122. 2.10.2026 01:00 yeni plan plan 32972
  123. 2.10.2026 00:00 yeni plan plan 31784
  124. 2.10.2026 00:00 yeni plan plan 31750
  125. 1.10.2026 21:00 yeni plan plan 31119
  126. 1.10.2026 21:00 yeni plan plan 31091
  127. 1.10.2026 21:00 yeni plan plan 30702
  128. 1.10.2026 20:00 yeni plan plan 29616
  129. 1.10.2026 20:00 yeni plan plan 29656
  130. 1.10.2026 20:00 yeni plan plan 30266
  131. 1.10.2026 20:00 yeni plan plan 30282
  132. 1.10.2026 19:00 yeni plan plan 28912
  133. 1.10.2026 19:00 yeni plan plan 28891
  134. 1.10.2026 19:00 yeni plan plan 28239
  135. 1.10.2026 19:00 yeni plan plan 28212
  136. 1.10.2026 19:00 yeni plan plan 27571
  137. 1.10.2026 19:00 yeni plan plan 27541
  138. 30.09.2026 22:00 yeni plan plan 26866
  139. 30.09.2026 22:00 yeni plan plan 26840
  140. 30.09.2026 22:00 yeni plan plan 26210
  141. 30.09.2026 22:00 yeni plan plan 26194
  142. 30.09.2026 22:00 yeni plan plan 25536
  143. 30.09.2026 22:00 yeni plan plan 25514
  144. 30.09.2026 22:00 yeni plan plan 24576
  145. 30.09.2026 22:00 yeni plan plan 24564
  146. 30.09.2026 22:00 yeni plan plan 24310
  147. 30.09.2026 22:00 yeni plan plan 24270
  148. 30.09.2026 22:00 yeni plan plan 24070
  149. 30.09.2026 22:00 yeni plan plan 23778
  150. 30.09.2026 22:00 yeni plan plan 23740
  151. 30.09.2026 22:00 yeni plan plan 23116
  152. 30.09.2026 22:00 yeni plan plan 23094
  153. 30.09.2026 21:00 yeni plan plan 20456
  154. 30.09.2026 21:00 yeni plan plan 20496
  155. 30.09.2026 21:00 yeni plan plan 20756
  156. 30.09.2026 21:00 yeni plan plan 21123
  157. 30.09.2026 21:00 yeni plan plan 21140
  158. 30.09.2026 21:00 yeni plan plan 21773
  159. 30.09.2026 21:00 yeni plan plan 21789
  160. 30.09.2026 21:00 yeni plan plan 22416
  161. 30.09.2026 21:00 yeni plan plan 22447
  162. 30.09.2026 20:00 yeni plan plan 19795
  163. 30.09.2026 20:00 yeni plan plan 19759
  164. 30.09.2026 20:00 yeni plan plan 19354
  165. 30.09.2026 19:00 yeni plan plan 19066
  166. 30.09.2026 19:00 yeni plan plan 19040
  167. 30.09.2026 15:00 yeni plan plan 18405
  168. 30.09.2026 15:00 yeni plan plan 18371
  169. 30.09.2026 15:00 yeni plan plan 17763
  170. 30.09.2026 15:00 yeni plan plan 17739
  171. 30.09.2026 15:00 yeni plan plan 17103
  172. 30.09.2026 15:00 yeni plan plan 17087
  173. 30.09.2026 11:00 yeni plan plan 15572
  174. 30.09.2026 11:00 yeni plan plan 15561
  175. 30.09.2026 11:00 yeni plan plan 15242
  176. 30.09.2026 11:00 yeni plan plan 15228
  177. 30.09.2026 11:00 yeni plan plan 14622
  178. 30.09.2026 11:00 yeni plan plan 14590
  179. 30.09.2026 10:00 yeni plan plan 14022
  180. 30.09.2026 10:00 yeni plan plan 13984
  181. 30.09.2026 10:00 yeni plan plan 12903
  182. 30.09.2026 10:00 yeni plan plan 12888
  183. 30.09.2026 06:00 yeni plan plan 10636
  184. 30.09.2026 06:00 yeni plan plan 10655
  185. 30.09.2026 06:00 yeni plan plan 11199
  186. 30.09.2026 06:00 yeni plan plan 11233
  187. 30.09.2026 06:00 yeni plan plan 11974
  188. 30.09.2026 06:00 yeni plan plan 11985
  189. 30.09.2026 05:00 yeni plan plan 10109
  190. 30.09.2026 05:00 yeni plan plan 10073
  191. 30.09.2026 03:00 yeni plan plan 9491
  192. 30.09.2026 00:00 yeni plan plan 9051
  193. 30.09.2026 00:00 yeni plan plan 9037
  194. 29.09.2026 21:00 yeni plan plan 8610
  195. 29.09.2026 21:00 yeni plan plan 8581
  196. 29.09.2026 21:00 yeni plan plan 8191
  197. 29.09.2026 21:00 yeni plan plan 8153
  198. 29.09.2026 20:00 yeni plan plan 7689
  199. 29.09.2026 20:00 yeni plan plan 7673
  200. 29.09.2026 13:00 yeni plan plan 7030
  201. 29.09.2026 03:00 yeni plan plan 6772
  202. 29.09.2026 02:00 yeni plan plan 6746
  203. 28.09.2026 19:00 yeni plan plan 6577
  204. 28.09.2026 19:00 yeni plan plan 6567
  205. 28.09.2026 19:00 yeni plan plan 6482
  206. 28.09.2026 16:00 yeni plan plan 6110
  207. 28.09.2026 16:00 yeni plan plan 6074
  208. 28.09.2026 16:00 yeni plan plan 6034
  209. 28.09.2026 16:00 yeni plan plan 6001

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28531,71,7 3,869
2026-09-291071,61,6 2,442
2026-09-303492,02,0 7,549
2026-10-01492,02,2 14,6104
2026-10-02831,71,7 2,126
2026-10-03114,314,6 14,65.497
2026-10-04576,76,7 25,42.053
2026-10-052111,91,9 13,0132
2026-10-06503,53,5 49,5749
2026-10-07492,82,9 34,8523
2026-10-09335,35,3 76,4855

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
7960021,11,122 9.10.2026 14:27 en iyi
7869521,21,222 9.10.2026 13:15
611061,21,222 28.09.2026 17:03
3371021,21,222 2.10.2026 02:27
5632021,21,222 5.10.2026 18:28
6535321,21,222 7.10.2026 13:55
8053721,21,222 9.10.2026 14:29
5548221,21,222 5.10.2026 17:58
4729021,21,222 5.10.2026 10:00
4811521,21,222 5.10.2026 10:03
2553621,21,222 30.09.2026 22:40
6305021,21,222 5.10.2026 23:04
1840521,21,222 30.09.2026 15:51
1010921,21,222 30.09.2026 05:49
5717521,21,222 5.10.2026 20:19
3300921,21,222 2.10.2026 01:09
1288841,21,222 30.09.2026 10:52
4439221,21,222 5.10.2026 09:09
6058821,21,222 5.10.2026 22:04
861021,21,222 29.09.2026 21:50
2311621,21,222 30.09.2026 22:15
2457641,21,222 30.09.2026 22:38
1123341,21,222 30.09.2026 06:59
7445321,21,222 8.10.2026 16:38
3411541,21,222 2.10.2026 16:25
1522821,21,222 30.09.2026 11:08
7081321,21,222 8.10.2026 12:20
2431021,21,222 30.09.2026 22:35
7719321,21,222 8.10.2026 19:59
3026621,31,322 1.10.2026 20:58
1708721,31,322 30.09.2026 15:32
7260121,31,322 8.10.2026 14:01
8158021,31,322 9.10.2026 17:45
6981321,31,322 7.10.2026 20:53
5973321,31,322 5.10.2026 21:41
1402221,31,322 30.09.2026 10:56
8256521,31,322 9.10.2026 19:25
819121,31,322 29.09.2026 21:26
6733841,31,322 7.10.2026 20:50
1906621,31,322 30.09.2026 19:36
1462221,31,322 30.09.2026 11:02
1979521,31,322 30.09.2026 20:42
4900821,31,322 5.10.2026 10:42
5892221,31,322 5.10.2026 21:38
6146841,31,322 5.10.2026 22:56
3848621,31,322 4.10.2026 13:28
2686621,31,322 30.09.2026 22:56
5807121,31,322 5.10.2026 21:02
1198541,31,322 30.09.2026 07:00
2965621,31,322 1.10.2026 20:57
768921,31,322 29.09.2026 20:13
4563141,31,322 5.10.2026 09:48
677211,31,34 29.09.2026 03:30
2177321,31,322 30.09.2026 21:34
63993121,31,322 6.10.2026 05:50
4099521,31,322 4.10.2026 22:07
5465721,41,422 5.10.2026 17:49
5293021,41,422 5.10.2026 13:19
3928021,41,422 4.10.2026 13:31
3505921,41,422 2.10.2026 17:24
6577261,41,422 29.09.2026 18:42
4990041,41,422 5.10.2026 12:33
2891221,41,422 1.10.2026 19:31
3111921,41,422 1.10.2026 21:13
4265021,41,422 5.10.2026 02:58
1065521,41,222 30.09.2026 06:32
2377841,41,422 30.09.2026 22:19
5377021,41,422 5.10.2026 13:58
4360621,41,422 5.10.2026 09:01
2823921,41,422 1.10.2026 19:18
2757121,41,422 1.10.2026 19:13
1557281,41,422 30.09.2026 11:22
4184521,41,422 5.10.2026 00:27
2049621,51,522 30.09.2026 21:24
6639121,51,522 7.10.2026 20:12
6636861,51,527 7.10.2026 20:12
7628721,51,522 8.10.2026 18:57
5803261,51,527 5.10.2026 21:02
1007361,51,527 30.09.2026 05:49
7536121,51,222 8.10.2026 17:17
3178441,51,522 2.10.2026 00:06
6306661,51,527 5.10.2026 23:04
3582621,51,522 2.10.2026 17:32
3367061,51,527 2.10.2026 02:27
4000361,51,527 4.10.2026 13:45
815361,51,527 29.09.2026 21:26
1904061,51,527 30.09.2026 19:36
5295061,51,527 5.10.2026 13:19
2961661,61,641 1.10.2026 20:57
1710361,61,627 30.09.2026 15:32
6977361,61,628 7.10.2026 20:53
1398461,61,641 30.09.2026 10:56
67306121,61,628 7.10.2026 20:50
2178961,61,628 30.09.2026 21:34
11199121,61,636 30.09.2026 06:59
3028261,61,627 1.10.2026 20:58
5462161,61,627 5.10.2026 17:49
5544261,61,628 5.10.2026 17:58
8050261,61,628 9.10.2026 14:29
2621021,61,622 30.09.2026 22:53
3850361,61,628 4.10.2026 13:29
5713661,61,627 5.10.2026 20:19
5143941,61,622 5.10.2026 12:59
1524261,61,627 30.09.2026 11:08
3747321,61,622 4.10.2026 08:55
6890261,61,628 7.10.2026 20:51
5629061,61,627 5.10.2026 18:28
3652061,61,622 2.10.2026 18:17
4897561,61,627 5.10.2026 10:42
2551461,61,628 30.09.2026 22:40
1773961,61,642 30.09.2026 15:42
4002921,61,522 4.10.2026 13:45
9037201,61,622 30.09.2026 05:42
24564121,61,628 30.09.2026 22:38
2684061,61,628 30.09.2026 22:56
5374961,61,628 5.10.2026 13:58
7078161,61,628 8.10.2026 12:20
2754161,61,627 1.10.2026 19:13
2889161,61,627 1.10.2026 19:31
1837161,61,642 30.09.2026 15:51
8154561,61,629 9.10.2026 17:45
858161,71,728 29.09.2026 21:50
2244721,71,522 30.09.2026 21:37
6567781,71,729 29.09.2026 18:42
2241661,71,728 30.09.2026 21:37
1063661,71,727 30.09.2026 06:32
36538181,71,727 2.10.2026 18:17
63957361,71,728 6.10.2026 05:50
1776321,71,722 30.09.2026 15:42
3109161,71,727 1.10.2026 21:13
4809361,71,728 5.10.2026 10:03
7169721,71,722 8.10.2026 12:37
7865761,71,728 9.10.2026 13:15
7961661,71,728 9.10.2026 14:27
15561241,71,731 30.09.2026 11:22
61437121,71,728 5.10.2026 22:56
6055261,71,728 5.10.2026 22:04
6892121,71,722 7.10.2026 20:51
7257461,71,727 8.10.2026 14:01
2427061,71,728 30.09.2026 22:35
12903121,71,727 30.09.2026 10:52
8254061,71,729 9.10.2026 19:25
5889461,71,728 5.10.2026 21:38
45596121,71,727 5.10.2026 09:49
4097761,71,727 4.10.2026 22:07
6074181,71,733 28.09.2026 17:03
7442961,71,727 8.10.2026 16:38
5971561,71,728 5.10.2026 21:41
1459061,71,754 30.09.2026 11:02
49869121,71,727 5.10.2026 12:33
11974121,71,728 30.09.2026 07:00
9051601,71,728 30.09.2026 05:42
2309461,81,828 30.09.2026 22:15
3413171,81,831 2.10.2026 16:25
7717161,81,827 8.10.2026 19:59
4730561,81,827 5.10.2026 10:00
767361,81,827 29.09.2026 20:13
1975961,81,828 30.09.2026 20:42
7532861,81,727 8.10.2026 17:17
3925761,81,827 4.10.2026 13:31
31750121,81,828 2.10.2026 00:06
4357561,81,827 5.10.2026 09:01
7166261,91,927 8.10.2026 12:37
4262661,91,928 5.10.2026 02:58
2619461,91,928 30.09.2026 22:53
2821261,91,927 1.10.2026 19:19
4181961,91,927 5.10.2026 00:27
7355462,02,028 8.10.2026 16:34
51403122,02,027 5.10.2026 12:59
7626562,02,027 8.10.2026 18:57
3580562,02,027 2.10.2026 17:32
23740122,02,029 30.09.2026 22:19
3297262,02,028 2.10.2026 01:09
6532462,12,127 7.10.2026 13:55
3743962,12,127 4.10.2026 08:55
4436162,12,128 5.10.2026 09:09
703012,22,252 29.09.2026 13:36
2114022,22,222 30.09.2026 21:32
2112362,22,227 30.09.2026 21:32
2045662,42,428 30.09.2026 21:24
3507662,42,427 2.10.2026 17:24
648232,52,580 28.09.2026 22:33
603413,73,71.046 28.09.2026 16:25
600114,03,91.024 28.09.2026 16:24
674615,15,11.636 29.09.2026 02:24
7359025,15,122 8.10.2026 16:34
949118,48,42.783 30.09.2026 03:30
36990315,115,05.914 4.10.2026 08:30
40407116,616,66.735 4.10.2026 14:30
40422517,217,17.170 4.10.2026 19:30
43044117,617,67.673 5.10.2026 03:30
40439117,617,67.178 4.10.2026 20:30
44791118,118,17.355 5.10.2026 09:30
37819118,718,76.288 4.10.2026 09:30
38865119,419,46.503 4.10.2026 13:30
40569120,220,27.215 4.10.2026 21:30
37995320,420,06.413 4.10.2026 12:30
41403222,122,17.362 4.10.2026 23:30
20756127,427,41.152 30.09.2026 21:30
19354231,931,91.155 30.09.2026 20:30
43236132,032,07.283 5.10.2026 08:59
24070133,533,51.109 30.09.2026 22:30
30702133,623,53.777 1.10.2026 21:13
64559248,648,518.100 6.10.2026 22:15
66817167,559,524.372 7.10.2026 20:40
77611180,175,326.909 8.10.2026 20:03
70236180,580,324.670 8.10.2026 08:30
809661126,3126,327.354 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
Memory:24,CPU:23
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 ic AS (
            SELECT w.CaseID, t.SchemaName, t.TableName, i.IndexName, i.FirstSeenUtc,
                   COALESCE((SELECT MAX(l.StartUtc) 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.EndUtc < i.FirstSeenUtc), DATEADD(day, -1, i.FirstSeenUtc)) AS PrevCollect,
                   COALESCE((SELECT MIN(h.LastUpdatedUtc) FROM perf.MetaStatisticsHistory AS h
                             WHERE h.ServerID = w.ServerID AND h.DatabaseName = w.DatabaseName AND h.object_id = i.object_id AND h.stats_id = i.index_id),
                            (SELECT st.LastUpdatedUtc FROM perf.MetaStatistics AS st
                             WHERE st.ServerID = w.ServerID AND st.DatabaseName = w.DatabaseName AND st.object_id = i.object_id AND st.stats_id = i.index_id)) AS StatsUtc,
                   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
            JOIN #firstc AS f ON f.ServerID = w.ServerID AND f.DatabaseName = w.DatabaseName
            WHERE i.IndexName IS NOT NULL AND i.FirstSeenUtc > f.FirstCollectUtc),
        ict AS (
            SELECT *, CASE WHEN StatsUtc > PrevCollect AND StatsUtc <= FirstSeenUtc THEN StatsUtc ELSE PrevCollect END AS E,
                      CASE WHEN StatsUtc > PrevCollect AND StatsUtc <= FirstSeenUtc THEN StatsUtc ELSE FirstSeenUtc END AS L
            FROM ic)
        INSERT rag.PlanChangeEvent (CaseID, EventType, EarliestUtc, LatestUtc, ObjectName, UsedByOldPlan, UsedByNewPlan, OrderUncertain)
        SELECT c.CaseID, 'IndexCreated', c.E, c.L, CONCAT(c.SchemaName, N'.', c.TableName, N'.', c.IndexName),
               CASE WHEN EXISTS (SELECT 1 FROM #pobj AS o WHERE o.CaseID = c.CaseID AND o.PlanRole = 'Old' AND o.TableName = c.TableName AND o.IndexName = c.IndexName) THEN 1 ELSE 0 END,
               CASE WHEN EXISTS (SELECT 1 FROM #pobj AS o WHERE o.CaseID = c.CaseID AND o.PlanRole = 'New' AND o.TableName = c.TableName AND o.IndexName = c.IndexName) THEN 1 ELSE 0 END,
               CASE WHEN c.L > c.ChangeUtc THEN 1 ELSE 0 END
        FROM ict AS c
        WHERE c.L >= c.WinStart AND c.E <= c.ChangeEndUtc

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.