Pahalı sorgular0x9CF63BB9FFB4BC70
Demo modu

Sorgu 0x9CF63BB9FFB4BC70

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 6,0 ms
Ort. CPU 6,0 ms
Bekleme payı %0,4
Ort. mantıksal okuma 1.432
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. 2,0 ms29.09.2026: 107 çalışma, ort. 2,2 ms30.09.2026: 349 çalışma, ort. 2,2 ms1.10.2026: 49 çalışma, ort. 2,3 ms2.10.2026: 83 çalışma, ort. 2,2 ms3.10.2026: 1 çalışma, ort. 65,1 ms4.10.2026: 57 çalışma, ort. 22,2 ms5.10.2026: 211 çalışma, ort. 3,8 ms6.10.2026: 50 çalışma, ort. 15,0 ms7.10.2026: 49 çalışma, ort. 18,1 ms9.10.2026: 33 çalışma, ort. 32,8 ms max 349 çalışma max ort. süre 65,1 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 82567
  2. 9.10.2026 19:00 yeni plan plan 82556
  3. 9.10.2026 19:00 yeni plan plan 82542
  4. 9.10.2026 17:00 yeni plan plan 81582
  5. 9.10.2026 17:00 yeni plan plan 81563
  6. 9.10.2026 17:00 yeni plan plan 81547
  7. 9.10.2026 14:00 yeni plan plan 80968
  8. 9.10.2026 14:00 yeni plan plan 80539
  9. 9.10.2026 14:00 yeni plan plan 80515
  10. 9.10.2026 14:00 yeni plan plan 80504
  11. 9.10.2026 14:00 yeni plan plan 79636
  12. 9.10.2026 14:00 yeni plan plan 79618
  13. 9.10.2026 14:00 yeni plan plan 79602
  14. 9.10.2026 13:00 yeni plan plan 78697
  15. 9.10.2026 13:00 yeni plan plan 78679
  16. 9.10.2026 13:00 yeni plan plan 78659
  17. 8.10.2026 20:00 yeni plan plan 77617
  18. 8.10.2026 19:00 yeni plan plan 77195
  19. 8.10.2026 19:00 yeni plan plan 77184
  20. 8.10.2026 19:00 yeni plan plan 77173
  21. 8.10.2026 18:00 yeni plan plan 76289
  22. 8.10.2026 18:00 yeni plan plan 76278
  23. 8.10.2026 18:00 yeni plan plan 76267
  24. 8.10.2026 17:00 yeni plan plan 75363
  25. 8.10.2026 17:00 yeni plan plan 75345
  26. 8.10.2026 17:00 yeni plan plan 75330
  27. 8.10.2026 16:00 yeni plan plan 74465
  28. 8.10.2026 16:00 yeni plan plan 74455
  29. 8.10.2026 16:00 yeni plan plan 74431
  30. 8.10.2026 16:00 yeni plan plan 73592
  31. 8.10.2026 16:00 yeni plan plan 73568
  32. 8.10.2026 16:00 yeni plan plan 73556
  33. 8.10.2026 14:00 yeni plan plan 72603
  34. 8.10.2026 14:00 yeni plan plan 72592
  35. 8.10.2026 14:00 yeni plan plan 72576
  36. 8.10.2026 12:00 yeni plan plan 70783
  37. 8.10.2026 12:00 yeni plan plan 70803
  38. 8.10.2026 12:00 yeni plan plan 70815
  39. 8.10.2026 12:00 yeni plan plan 71664
  40. 8.10.2026 12:00 yeni plan plan 71675
  41. 8.10.2026 12:00 yeni plan plan 71699
  42. 8.10.2026 08:00 yeni plan plan 70238
  43. 7.10.2026 20:00 yeni plan plan 69815
  44. 7.10.2026 20:00 yeni plan plan 69791
  45. 7.10.2026 20:00 yeni plan plan 69775
  46. 7.10.2026 20:00 yeni plan plan 68935
  47. 7.10.2026 20:00 yeni plan plan 68923
  48. 7.10.2026 20:00 yeni plan plan 68904
  49. 7.10.2026 20:00 yeni plan plan 67340
  50. 7.10.2026 20:00 yeni plan plan 67329
  51. 7.10.2026 20:00 yeni plan plan 67308
  52. 7.10.2026 20:00 yeni plan plan 66819
  53. 7.10.2026 20:00 yeni plan plan 66393
  54. 7.10.2026 20:00 yeni plan plan 66381
  55. 7.10.2026 20:00 yeni plan plan 66370
  56. 7.10.2026 13:00 yeni plan plan 65355
  57. 7.10.2026 13:00 yeni plan plan 65337
  58. 7.10.2026 13:00 yeni plan plan 65326
  59. 6.10.2026 22:00 yeni plan plan 64775
  60. 6.10.2026 03:00 yeni plan plan 64561
  61. 6.10.2026 00:00 yeni plan plan 63995
  62. 6.10.2026 00:00 yeni plan plan 63977
  63. 6.10.2026 00:00 yeni plan plan 63959
  64. 5.10.2026 23:00 yeni plan plan 63087
  65. 5.10.2026 23:00 yeni plan plan 63068
  66. 5.10.2026 23:00 yeni plan plan 63052
  67. 5.10.2026 22:00 yeni plan plan 61470
  68. 5.10.2026 22:00 yeni plan plan 61451
  69. 5.10.2026 22:00 yeni plan plan 61439
  70. 5.10.2026 22:00 yeni plan plan 60590
  71. 5.10.2026 22:00 yeni plan plan 60565
  72. 5.10.2026 22:00 yeni plan plan 60554
  73. 5.10.2026 21:00 yeni plan plan 58034
  74. 5.10.2026 21:00 yeni plan plan 58050
  75. 5.10.2026 21:00 yeni plan plan 58073
  76. 5.10.2026 21:00 yeni plan plan 58896
  77. 5.10.2026 21:00 yeni plan plan 58913
  78. 5.10.2026 21:00 yeni plan plan 58924
  79. 5.10.2026 21:00 yeni plan plan 59717
  80. 5.10.2026 21:00 yeni plan plan 59735
  81. 5.10.2026 21:00 yeni plan plan 59750
  82. 5.10.2026 20:00 yeni plan plan 57177
  83. 5.10.2026 20:00 yeni plan plan 57149
  84. 5.10.2026 20:00 yeni plan plan 57138
  85. 5.10.2026 18:00 yeni plan plan 56322
  86. 5.10.2026 18:00 yeni plan plan 56302
  87. 5.10.2026 18:00 yeni plan plan 56292
  88. 5.10.2026 17:00 yeni plan plan 55484
  89. 5.10.2026 17:00 yeni plan plan 55464
  90. 5.10.2026 17:00 yeni plan plan 55444
  91. 5.10.2026 17:00 yeni plan plan 54659
  92. 5.10.2026 17:00 yeni plan plan 54637
  93. 5.10.2026 17:00 yeni plan plan 54623
  94. 5.10.2026 13:00 yeni plan plan 53772
  95. 5.10.2026 13:00 yeni plan plan 53761
  96. 5.10.2026 13:00 yeni plan plan 53751
  97. 5.10.2026 13:00 yeni plan plan 52959
  98. 5.10.2026 13:00 yeni plan plan 52952
  99. 5.10.2026 13:00 yeni plan plan 52932
  100. 5.10.2026 12:00 yeni plan plan 51441
  101. 5.10.2026 12:00 yeni plan plan 51416
  102. 5.10.2026 12:00 yeni plan plan 51405
  103. 5.10.2026 12:00 yeni plan plan 49902
  104. 5.10.2026 12:00 yeni plan plan 49881
  105. 5.10.2026 12:00 yeni plan plan 49871
  106. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  107. 5.10.2026 10:00 yeni plan plan 47292
  108. 5.10.2026 10:00 yeni plan plan 47307
  109. 5.10.2026 10:00 yeni plan plan 47317
  110. 5.10.2026 10:00 yeni plan plan 48095
  111. 5.10.2026 10:00 yeni plan plan 48106
  112. 5.10.2026 10:00 yeni plan plan 48117
  113. 5.10.2026 10:00 yeni plan plan 48977
  114. 5.10.2026 10:00 yeni plan plan 48999
  115. 5.10.2026 10:00 yeni plan plan 49010
  116. 5.10.2026 09:00 yeni plan plan 45633
  117. 5.10.2026 09:00 yeni plan plan 45612
  118. 5.10.2026 09:00 yeni plan plan 45598
  119. 5.10.2026 09:00 yeni plan plan 44793
  120. 5.10.2026 09:00 yeni plan plan 44394
  121. 5.10.2026 09:00 yeni plan plan 44373
  122. 5.10.2026 09:00 yeni plan plan 44363
  123. 5.10.2026 09:00 yeni plan plan 43608
  124. 5.10.2026 09:00 yeni plan plan 43594
  125. 5.10.2026 09:00 yeni plan plan 43577
  126. 5.10.2026 08:00 yeni plan plan 43238
  127. 5.10.2026 03:00 yeni plan plan 43046
  128. 5.10.2026 02:00 yeni plan plan 42664
  129. 5.10.2026 02:00 yeni plan plan 42652
  130. 5.10.2026 02:00 yeni plan plan 42628
  131. 5.10.2026 00:00 yeni plan plan 41821
  132. 5.10.2026 00:00 yeni plan plan 41836
  133. 5.10.2026 00:00 yeni plan plan 41847
  134. 4.10.2026 22:00 yeni plan plan 41405
  135. 4.10.2026 22:00 yeni plan plan 41009
  136. 4.10.2026 22:00 yeni plan plan 40997
  137. 4.10.2026 22:00 yeni plan plan 40979
  138. 4.10.2026 21:00 yeni plan plan 40571
  139. 4.10.2026 17:00 yeni plan plan 40432
  140. 4.10.2026 15:00 yeni plan plan 40424
  141. 4.10.2026 14:00 yeni plan plan 40409
  142. 4.10.2026 13:00 yeni plan plan 40031
  143. 4.10.2026 13:00 yeni plan plan 40020
  144. 4.10.2026 13:00 yeni plan plan 40005
  145. 4.10.2026 13:00 yeni plan plan 39282
  146. 4.10.2026 13:00 yeni plan plan 39268
  147. 4.10.2026 13:00 yeni plan plan 39259
  148. 4.10.2026 13:00 yeni plan plan 38867
  149. 4.10.2026 13:00 yeni plan plan 38512
  150. 4.10.2026 13:00 yeni plan plan 38505
  151. 4.10.2026 13:00 yeni plan plan 38488
  152. 4.10.2026 11:00 yeni plan plan 38011
  153. 4.10.2026 10:00 yeni plan plan 37997
  154. 4.10.2026 09:00 yeni plan plan 37821
  155. 4.10.2026 08:00 yeni plan plan 37475
  156. 4.10.2026 08:00 yeni plan plan 37454
  157. 4.10.2026 08:00 yeni plan plan 37441
  158. 4.10.2026 08:00 yeni plan plan 37037
  159. 3.10.2026 03:00 yeni plan plan 36992
  160. 2.10.2026 17:00 yeni plan plan 36555
  161. 2.10.2026 17:00 yeni plan plan 36540
  162. 2.10.2026 17:00 yeni plan plan 36522
  163. 2.10.2026 17:00 yeni plan plan 35828
  164. 2.10.2026 17:00 yeni plan plan 35818
  165. 2.10.2026 17:00 yeni plan plan 35807
  166. 2.10.2026 17:00 yeni plan plan 35087
  167. 2.10.2026 17:00 yeni plan plan 35078
  168. 2.10.2026 17:00 yeni plan plan 35061
  169. 2.10.2026 16:00 yeni plan plan 34636
  170. 2.10.2026 16:00 yeni plan plan 34133
  171. 2.10.2026 16:00 yeni plan plan 34117
  172. 2.10.2026 02:00 yeni plan plan 33712
  173. 2.10.2026 02:00 yeni plan plan 33684
  174. 2.10.2026 02:00 yeni plan plan 33672
  175. 2.10.2026 01:00 yeni plan plan 33011
  176. 2.10.2026 01:00 yeni plan plan 32993
  177. 2.10.2026 01:00 yeni plan plan 32974
  178. 2.10.2026 00:00 yeni plan plan 31786
  179. 2.10.2026 00:00 yeni plan plan 31762
  180. 2.10.2026 00:00 yeni plan plan 31752
  181. 1.10.2026 21:00 yeni plan plan 31121
  182. 1.10.2026 21:00 yeni plan plan 31111
  183. 1.10.2026 21:00 yeni plan plan 31093
  184. 1.10.2026 21:00 yeni plan plan 30704
  185. 1.10.2026 20:00 yeni plan plan 29618
  186. 1.10.2026 20:00 yeni plan plan 29633
  187. 1.10.2026 20:00 yeni plan plan 29658
  188. 1.10.2026 20:00 yeni plan plan 30268
  189. 1.10.2026 20:00 yeni plan plan 30284
  190. 1.10.2026 20:00 yeni plan plan 30302
  191. 1.10.2026 19:00 yeni plan plan 28914
  192. 1.10.2026 19:00 yeni plan plan 28903
  193. 1.10.2026 19:00 yeni plan plan 28893
  194. 1.10.2026 19:00 yeni plan plan 28241
  195. 1.10.2026 19:00 yeni plan plan 28230
  196. 1.10.2026 19:00 yeni plan plan 28214
  197. 1.10.2026 19:00 yeni plan plan 27573
  198. 1.10.2026 19:00 yeni plan plan 27562
  199. 1.10.2026 19:00 yeni plan plan 27543
  200. 30.09.2026 22:00 yeni plan plan 26868
  201. 30.09.2026 22:00 yeni plan plan 26857
  202. 30.09.2026 22:00 yeni plan plan 26842
  203. 30.09.2026 22:00 yeni plan plan 26228
  204. 30.09.2026 22:00 yeni plan plan 26212
  205. 30.09.2026 22:00 yeni plan plan 26196
  206. 30.09.2026 22:00 yeni plan plan 25538
  207. 30.09.2026 22:00 yeni plan plan 25527
  208. 30.09.2026 22:00 yeni plan plan 25516
  209. 30.09.2026 22:00 yeni plan plan 24578
  210. 30.09.2026 22:00 yeni plan plan 24573
  211. 30.09.2026 22:00 yeni plan plan 24566
  212. 30.09.2026 22:00 yeni plan plan 24312
  213. 30.09.2026 22:00 yeni plan plan 24284
  214. 30.09.2026 22:00 yeni plan plan 24272
  215. 30.09.2026 22:00 yeni plan plan 24072
  216. 30.09.2026 22:00 yeni plan plan 23780
  217. 30.09.2026 22:00 yeni plan plan 23751
  218. 30.09.2026 22:00 yeni plan plan 23742
  219. 30.09.2026 22:00 yeni plan plan 23118
  220. 30.09.2026 22:00 yeni plan plan 23107
  221. 30.09.2026 22:00 yeni plan plan 23096
  222. 30.09.2026 21:00 yeni plan plan 20458
  223. 30.09.2026 21:00 yeni plan plan 20477
  224. 30.09.2026 21:00 yeni plan plan 20498
  225. 30.09.2026 21:00 yeni plan plan 20760
  226. 30.09.2026 21:00 yeni plan plan 21125
  227. 30.09.2026 21:00 yeni plan plan 21142
  228. 30.09.2026 21:00 yeni plan plan 21156
  229. 30.09.2026 21:00 yeni plan plan 21775
  230. 30.09.2026 21:00 yeni plan plan 21791
  231. 30.09.2026 21:00 yeni plan plan 21808
  232. 30.09.2026 21:00 yeni plan plan 22418
  233. 30.09.2026 21:00 yeni plan plan 22430
  234. 30.09.2026 21:00 yeni plan plan 22449
  235. 30.09.2026 20:00 yeni plan plan 19797
  236. 30.09.2026 20:00 yeni plan plan 19776
  237. 30.09.2026 20:00 yeni plan plan 19761
  238. 30.09.2026 20:00 yeni plan plan 19360
  239. 30.09.2026 19:00 yeni plan plan 19080
  240. 30.09.2026 19:00 yeni plan plan 19068
  241. 30.09.2026 19:00 yeni plan plan 19042
  242. 30.09.2026 15:00 yeni plan plan 18407
  243. 30.09.2026 15:00 yeni plan plan 18385
  244. 30.09.2026 15:00 yeni plan plan 18373
  245. 30.09.2026 15:00 yeni plan plan 17765
  246. 30.09.2026 15:00 yeni plan plan 17753
  247. 30.09.2026 15:00 yeni plan plan 17741
  248. 30.09.2026 15:00 yeni plan plan 17113
  249. 30.09.2026 15:00 yeni plan plan 17105
  250. 30.09.2026 15:00 yeni plan plan 17089
  251. 30.09.2026 11:00 yeni plan plan 15574
  252. 30.09.2026 11:00 yeni plan plan 15569
  253. 30.09.2026 11:00 yeni plan plan 15563
  254. 30.09.2026 11:00 yeni plan plan 15258
  255. 30.09.2026 11:00 yeni plan plan 15244
  256. 30.09.2026 11:00 yeni plan plan 15230
  257. 30.09.2026 11:00 yeni plan plan 14624
  258. 30.09.2026 11:00 yeni plan plan 14609
  259. 30.09.2026 11:00 yeni plan plan 14592
  260. 30.09.2026 10:00 yeni plan plan 12890
  261. 30.09.2026 10:00 yeni plan plan 12905
  262. 30.09.2026 10:00 yeni plan plan 12916
  263. 30.09.2026 10:00 yeni plan plan 13986
  264. 30.09.2026 10:00 yeni plan plan 13997
  265. 30.09.2026 10:00 yeni plan plan 14024
  266. 30.09.2026 06:00 yeni plan plan 11992
  267. 30.09.2026 06:00 yeni plan plan 11987
  268. 30.09.2026 06:00 yeni plan plan 11976
  269. 30.09.2026 06:00 yeni plan plan 11235
  270. 30.09.2026 06:00 yeni plan plan 11215
  271. 30.09.2026 06:00 yeni plan plan 11201
  272. 30.09.2026 06:00 yeni plan plan 10679
  273. 30.09.2026 06:00 yeni plan plan 10657
  274. 30.09.2026 06:00 yeni plan plan 10638
  275. 30.09.2026 05:00 yeni plan plan 10111
  276. 30.09.2026 05:00 yeni plan plan 10084
  277. 30.09.2026 05:00 yeni plan plan 10075
  278. 30.09.2026 03:00 yeni plan plan 9493
  279. 30.09.2026 00:00 yeni plan plan 9065
  280. 30.09.2026 00:00 yeni plan plan 9053
  281. 30.09.2026 00:00 yeni plan plan 9039
  282. 29.09.2026 21:00 yeni plan plan 8612
  283. 29.09.2026 21:00 yeni plan plan 8598
  284. 29.09.2026 21:00 yeni plan plan 8583
  285. 29.09.2026 21:00 yeni plan plan 8193
  286. 29.09.2026 21:00 yeni plan plan 8168
  287. 29.09.2026 21:00 yeni plan plan 8155
  288. 29.09.2026 20:00 yeni plan plan 7709
  289. 29.09.2026 20:00 yeni plan plan 7691
  290. 29.09.2026 20:00 yeni plan plan 7675
  291. 29.09.2026 13:00 yeni plan plan 7032
  292. 29.09.2026 03:00 yeni plan plan 6773
  293. 29.09.2026 02:00 yeni plan plan 6748
  294. 28.09.2026 19:00 yeni plan plan 6579
  295. 28.09.2026 19:00 yeni plan plan 6575
  296. 28.09.2026 19:00 yeni plan plan 6569
  297. 28.09.2026 19:00 yeni plan plan 6484
  298. 28.09.2026 16:00 yeni plan plan 6112
  299. 28.09.2026 16:00 yeni plan plan 6088
  300. 28.09.2026 16:00 yeni plan plan 6076
  301. 28.09.2026 16:00 yeni plan plan 6036
  302. 28.09.2026 16:00 yeni plan plan 6003

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28532,02,0 2,513
2026-09-291072,22,2 3,29
2026-09-303492,22,2 3,220
2026-10-01492,32,3 3,744
2026-10-02832,22,2 2,59
2026-10-03165,165,1 65,117.010
2026-10-045722,222,2 90,010.131
2026-10-052113,83,8 5,2705
2026-10-065015,015,0 322,76.083
2026-10-074917,918,1 199,03.756
2026-10-093332,432,8 407,97.544

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
677311,41,48 29.09.2026 03:30 en iyi
600311,51,544 28.09.2026 16:24
648431,51,563 28.09.2026 22:33
8053921,61,64 9.10.2026 14:29
4439421,61,64 5.10.2026 09:09
5465921,61,64 5.10.2026 17:49
6535521,61,64 7.10.2026 13:55
3848821,61,64 4.10.2026 13:28
5293221,71,74 5.10.2026 13:19
2757321,71,74 1.10.2026 19:13
5548421,71,74 5.10.2026 17:58
4184721,71,74 5.10.2026 00:27
5807321,71,74 5.10.2026 21:02
819321,71,74 29.09.2026 21:26
7081521,71,74 8.10.2026 12:20
611261,71,74 28.09.2026 17:03
7960221,71,74 9.10.2026 14:27
6305221,71,74 5.10.2026 23:04
703211,71,722 29.09.2026 13:36
6059021,71,74 5.10.2026 22:04
603611,71,744 28.09.2026 16:25
861221,71,74 29.09.2026 21:50
4360821,71,74 5.10.2026 09:01
1402421,71,74 30.09.2026 10:56
8158221,71,74 9.10.2026 17:45
2891421,71,74 1.10.2026 19:31
1123541,71,74 30.09.2026 06:59
3026821,71,74 1.10.2026 20:58
4811721,71,74 5.10.2026 10:03
7719521,71,74 8.10.2026 19:59
1906821,71,74 30.09.2026 19:36
1776521,71,74 30.09.2026 15:42
2457841,71,74 30.09.2026 22:38
1840721,71,74 30.09.2026 15:51
3371221,71,74 2.10.2026 02:27
769121,71,74 29.09.2026 20:13
4729221,71,74 5.10.2026 10:00
3506121,71,74 2.10.2026 17:24
6981521,71,74 7.10.2026 20:53
5632221,71,74 5.10.2026 18:28
1198741,71,74 30.09.2026 07:00
4265221,71,74 5.10.2026 02:58
2965821,81,84 1.10.2026 20:57
2311821,81,84 30.09.2026 22:15
1011121,81,64 30.09.2026 05:49
6639321,81,84 7.10.2026 20:12
4901021,81,84 5.10.2026 10:42
1523021,81,84 30.09.2026 11:08
8256721,81,84 9.10.2026 19:25
4563341,81,84 5.10.2026 09:48
1065721,81,84 30.09.2026 06:32
2621221,81,84 30.09.2026 22:53
6892321,81,84 7.10.2026 20:51
4003121,81,84 4.10.2026 13:45
1708921,81,84 30.09.2026 15:32
2177521,81,84 30.09.2026 21:34
2686821,81,84 30.09.2026 22:56
3582821,81,84 2.10.2026 17:32
6147041,81,84 5.10.2026 22:57
63995121,81,84 6.10.2026 05:50
3112121,81,84 1.10.2026 21:13
9039201,81,84 30.09.2026 05:42
2431221,81,84 30.09.2026 22:35
7628921,81,84 8.10.2026 18:57
2553821,91,94 30.09.2026 22:40
3301121,91,94 2.10.2026 01:09
5973521,91,94 5.10.2026 21:41
2114221,91,94 30.09.2026 21:32
5717721,91,94 5.10.2026 20:19
6734041,91,94 7.10.2026 20:50
2824121,91,94 1.10.2026 19:19
3747521,91,94 4.10.2026 08:55
1557481,91,94 30.09.2026 11:22
6579261,91,94 29.09.2026 18:42
816841,91,94 29.09.2026 21:26
4099721,91,94 4.10.2026 22:07
5544442,02,04 5.10.2026 17:58
3652262,02,04 2.10.2026 18:17
2961842,02,04 1.10.2026 20:57
2684242,02,04 30.09.2026 22:56
2049822,02,04 30.09.2026 21:24
7869722,02,04 9.10.2026 13:15
7260322,02,04 8.10.2026 14:01
1289042,02,04 30.09.2026 10:52
6638142,02,04 7.10.2026 20:12
770942,02,04 29.09.2026 20:13
4810642,02,04 5.10.2026 10:03
5803442,02,04 5.10.2026 21:02
5462342,02,04 5.10.2026 17:49
5630242,02,04 5.10.2026 18:28
7536322,02,04 8.10.2026 17:17
5971742,02,04 5.10.2026 21:41
1462422,02,04 30.09.2026 11:02
6056542,02,04 5.10.2026 22:04
6076122,02,04 28.09.2026 17:03
4097942,02,04 4.10.2026 22:07
3368422,02,022 2.10.2026 02:27
2378042,02,04 30.09.2026 22:19
5376142,02,04 5.10.2026 13:58
5713842,02,04 5.10.2026 20:19
6890442,02,04 7.10.2026 20:51
1008442,12,04 30.09.2026 05:49
5377222,12,14 5.10.2026 13:58
5889642,12,14 5.10.2026 21:38
2456682,12,14 30.09.2026 22:38
1290582,12,14 30.09.2026 10:52
4437342,12,14 5.10.2026 09:09
1904242,12,14 30.09.2026 19:36
3367242,12,14 2.10.2026 02:27
6532642,12,14 7.10.2026 13:55
2622842,12,14 30.09.2026 22:53
1067922,12,022 30.09.2026 06:32
2552742,12,14 30.09.2026 22:40
1710542,12,14 30.09.2026 15:32
3463642,12,14 2.10.2026 16:25
3028442,12,14 1.10.2026 20:58
1197682,12,14 30.09.2026 07:00
1063842,12,14 30.09.2026 06:32
859822,12,122 29.09.2026 21:50
36555122,12,14 2.10.2026 18:17
5629222,12,122 5.10.2026 18:28
7865942,12,14 9.10.2026 13:15
2963322,12,122 1.10.2026 20:57
1120182,12,14 30.09.2026 06:59
1524442,12,14 30.09.2026 11:08
4182142,12,14 5.10.2026 00:27
4357742,12,14 5.10.2026 09:00
7961842,12,14 9.10.2026 14:27
7257642,12,14 8.10.2026 14:01
7867922,12,122 9.10.2026 13:15
4731722,12,122 5.10.2026 10:00
5295942,12,14 5.10.2026 13:19
4559882,12,14 5.10.2026 09:49
2310742,12,14 30.09.2026 22:15
6730882,12,14 7.10.2026 20:50
6306842,12,14 5.10.2026 23:04
2889322,12,122 1.10.2026 19:31
815522,12,122 29.09.2026 21:26
5714922,12,122 5.10.2026 20:19
2375182,12,14 30.09.2026 22:19
6055422,12,122 5.10.2026 22:03
3111122,12,122 1.10.2026 21:13
1774142,12,14 30.09.2026 15:42
2179142,12,14 30.09.2026 21:34
5805022,12,122 5.10.2026 21:02
1399742,22,24 30.09.2026 10:56
5892422,22,24 5.10.2026 21:38
8154742,22,24 9.10.2026 17:45
7080322,22,222 8.10.2026 12:20
3030222,22,222 1.10.2026 20:58
3411742,22,24 2.10.2026 16:25
8051542,22,24 9.10.2026 14:29
4730742,22,24 5.10.2026 10:00
3507822,22,222 2.10.2026 17:24
2890342,22,24 1.10.2026 19:31
6533722,22,222 7.10.2026 13:55
6977542,22,04 7.10.2026 20:53
1976142,22,24 30.09.2026 20:42
3928222,22,24 4.10.2026 13:31
7443122,22,222 8.10.2026 16:38
7445522,22,24 8.10.2026 16:38
6308722,22,222 5.10.2026 23:04
4990242,22,24 5.10.2026 12:33
6979122,22,222 7.10.2026 20:53
4002022,22,222 4.10.2026 13:45
2457342,22,222 30.09.2026 22:38
4359422,22,224 5.10.2026 09:01
7166442,22,24 8.10.2026 12:37
7718442,22,24 8.10.2026 19:59
1121542,22,222 30.09.2026 06:59
7169922,22,24 8.10.2026 12:37
7078342,22,24 8.10.2026 12:20
1460922,22,222 30.09.2026 11:02
5546422,22,222 5.10.2026 17:58
7627842,22,24 8.10.2026 18:57
2427242,22,24 30.09.2026 22:35
1979722,22,24 30.09.2026 20:42
63959122,22,222 6.10.2026 05:50
7355642,22,24 8.10.2026 16:34
3178642,22,24 2.10.2026 00:06
7717322,22,222 8.10.2026 19:59
9053402,22,24 30.09.2026 05:42
1838522,22,222 30.09.2026 15:51
1398622,32,322 30.09.2026 10:56
3580722,32,322 2.10.2026 17:32
3851242,32,34 4.10.2026 13:29
6893522,32,322 7.10.2026 20:51
6145142,32,322 5.10.2026 22:56
6637022,32,322 7.10.2026 20:12
8050422,32,322 9.10.2026 14:29
5975022,32,322 5.10.2026 21:41
3413332,32,326 2.10.2026 16:25
3299342,32,34 2.10.2026 01:09
6143982,32,34 5.10.2026 22:56
2244922,32,14 30.09.2026 21:37
1007522,32,322 30.09.2026 05:49
1291642,32,222 30.09.2026 10:52
2241842,32,14 30.09.2026 21:37
1459242,32,34 30.09.2026 11:02
7533042,32,24 8.10.2026 17:17
4809522,32,322 5.10.2026 10:03
4897742,32,34 5.10.2026 10:42
5144142,32,34 5.10.2026 12:59
8254242,32,34 9.10.2026 19:25
15569162,32,34 30.09.2026 11:22
2821442,32,34 1.10.2026 19:19
5891322,32,322 5.10.2026 21:38
4899922,32,322 5.10.2026 10:42
1711322,32,322 30.09.2026 15:32
1908022,32,322 30.09.2026 19:36
1837342,32,34 30.09.2026 15:51
2756222,32,322 1.10.2026 19:13
2115622,32,322 30.09.2026 21:32
1977622,32,322 30.09.2026 20:42
63977242,32,34 6.10.2026 05:50
4100922,32,322 4.10.2026 22:07
9065202,32,322 30.09.2026 05:42
2112542,32,34 30.09.2026 21:32
6569522,32,34 29.09.2026 18:42
1525822,32,322 30.09.2026 11:08
4000542,32,34 4.10.2026 13:45
2551622,32,322 30.09.2026 22:40
3109342,32,34 1.10.2026 21:13
7356822,42,422 8.10.2026 16:34
5375122,42,422 5.10.2026 13:58
1775322,42,422 30.09.2026 15:42
3850522,42,422 4.10.2026 13:29
5463722,42,422 5.10.2026 17:49
608862,42,422 28.09.2026 17:03
3745442,42,44 4.10.2026 08:55
3297422,42,422 2.10.2026 01:09
4987142,42,422 5.10.2026 12:33
3654062,42,422 2.10.2026 18:17
2428422,42,422 30.09.2026 22:35
6575262,42,422 29.09.2026 18:42
5295222,42,422 5.10.2026 13:19
858342,52,54 29.09.2026 21:50
3581842,52,54 2.10.2026 17:32
3175282,52,54 2.10.2026 00:06
1199242,52,522 30.09.2026 07:00
4183622,52,522 5.10.2026 00:27
6732942,52,522 7.10.2026 20:50
3508742,52,54 2.10.2026 17:24
3926842,52,54 4.10.2026 13:31
8255622,52,522 9.10.2026 19:25
4561242,62,622 5.10.2026 09:49
2374242,62,622 30.09.2026 22:19
2180822,62,622 30.09.2026 21:34
2243022,62,522 30.09.2026 21:37
4266422,62,622 5.10.2026 02:58
3744122,62,622 4.10.2026 08:55
4988182,62,64 5.10.2026 12:33
7259222,62,622 8.10.2026 14:01
7963622,62,622 9.10.2026 14:27
767522,62,622 29.09.2026 20:13
8156322,82,824 9.10.2026 17:45
1556382,92,922 30.09.2026 11:22
2309622,92,922 30.09.2026 22:15
2047722,92,922 30.09.2026 21:24
674812,92,666 29.09.2026 02:24
2045843,03,04 30.09.2026 21:24
7534523,02,222 8.10.2026 17:17
3176243,03,022 2.10.2026 00:06
4262843,13,14 5.10.2026 02:58
2076013,23,2835 30.09.2026 21:30
949313,23,2837 30.09.2026 03:30
4436323,23,222 5.10.2026 09:09
7359223,33,34 8.10.2026 16:34
2754343,33,34 1.10.2026 19:13
2823023,33,322 1.10.2026 19:19
7167523,43,422 8.10.2026 12:37
3925923,53,522 4.10.2026 13:31
1936023,63,6856 30.09.2026 20:30
7446543,73,74 8.10.2026 16:38
5141644,14,122 5.10.2026 12:59
7626724,54,522 8.10.2026 18:57
2685724,74,722 30.09.2026 22:56
2407214,84,8826 30.09.2026 22:30
2619624,84,822 30.09.2026 22:53
5140585,95,94 5.10.2026 12:59
3070416,76,71.747 1.10.2026 21:13
37037140,840,817.701 4.10.2026 08:18
37821150,750,730.301 4.10.2026 09:30
38011251,751,728.833 4.10.2026 12:30
37997153,252,230.487 4.10.2026 10:30
38867153,853,828.087 4.10.2026 13:30
36992263,763,724.058 4.10.2026 08:30
40409169,969,939.209 4.10.2026 14:30
40424271,871,540.248 4.10.2026 16:30
44793183,183,148.323 5.10.2026 09:30
40432483,383,338.058 4.10.2026 20:30
41405286,286,236.721 4.10.2026 23:30
43046190,490,456.995 5.10.2026 03:30
40571191,391,336.426 4.10.2026 21:30
432381148,7148,641.680 5.10.2026 08:59
645611309,1308,7118.056 6.10.2026 03:30
647751336,2335,6185.682 6.10.2026 22:15
776171695,1670,5249.079 8.10.2026 20:03
668191788,3780,0183.641 7.10.2026 20:40
7023811.005,81.003,6201.882 8.10.2026 08:30
8096811.015,51.001,7248.665 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
Memory:30,CPU:30,Other Disk IO:19
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 su AS (
            SELECT w.CaseID, t.SchemaName, t.TableName, t.object_id, h.stats_id, h.LastUpdatedUtc, h.[Rows], h.RowsSampled, w.WinStart, w.ChangeUtc, w.ChangeEndUtc
            FROM #win AS w
            JOIN #ptab AS t ON t.CaseID = w.CaseID
            JOIN perf.MetaStatisticsHistory AS h ON h.ServerID = w.ServerID AND h.DatabaseName = w.DatabaseName AND h.object_id = t.object_id
            UNION
            SELECT w.CaseID, t.SchemaName, t.TableName, t.object_id, s.stats_id, s.LastUpdatedUtc, s.[Rows], s.RowsSampled, w.WinStart, w.ChangeUtc, w.ChangeEndUtc
            FROM #win AS w
            JOIN #ptab AS t ON t.CaseID = w.CaseID
            JOIN perf.MetaStatistics AS s ON s.ServerID = w.ServerID AND s.DatabaseName = w.DatabaseName AND s.object_id = t.object_id
            WHERE s.LastUpdatedUtc IS NOT NULL)
        INSERT rag.PlanChangeEvent (CaseID, EventType, EarliestUtc, LatestUtc, ObjectName, BeforeValue, AfterValue, UsedByOldPlan, UsedByNewPlan, OrderUncertain)
        SELECT su.CaseID, 'StatsUpdated', su.LastUpdatedUtc, su.LastUpdatedUtc, CONCAT(su.SchemaName, N'.', su.TableName, N'.', st.StatsName),
               NULL, CONCAT(su.RowsSampled, N'/', su.[Rows]),
               CASE WHEN NOT EXISTS (SELECT 1 FROM #pstat AS ps WHERE ps.CaseID = su.CaseID AND ps.PlanRole = 'Old') THEN NULL
                    WHEN EXISTS (SELECT 1 FROM #pstat AS ps WHERE ps.CaseID = su.CaseID AND ps.PlanRole = 'Old' AND ps.TableName = su.TableName AND ps.StatsName = st.StatsName) THEN 1 ELSE 0 END,
               CASE WHEN NOT EXISTS (SELECT 1 FROM #pstat AS ps WHERE ps.CaseID = su.CaseID AND ps.PlanRole = 'New') THEN NULL
                    WHEN EXISTS (SELECT 1 FROM #pstat AS ps WHERE ps.CaseID = su.CaseID AND ps.PlanRole = 'New' AND ps.TableName = su.TableName AND ps.StatsName = st.StatsName) THEN 1 ELSE 0 END,
               CASE WHEN su.LastUpdatedUtc > su.ChangeUtc THEN 1 ELSE 0 END
        FROM su
        CROSS APPLY (SELECT COALESCE(
                        (SELECT TOP (1) s2.StatsName FROM perf.MetaStatistics AS s2 JOIN #win AS w2 ON w2.CaseID = su.CaseID
                         WHERE s2.ServerID = w2.ServerID AND s2.DatabaseName = w2.DatabaseName AND s2.object_id = su.object_id AND s2.stats_id = su.stats_id),
                        CONCAT(N'stats_id ', su.stats_id)) AS StatsName) AS st
        WHERE su.LastUpdatedUtc >= su.WinStart AND su.LastUpdatedUtc <= su.ChangeEndUtc
          AND NOT EXISTS (SELECT 1 FROM rag.PlanChangeEvent AS e
                          WHERE e.CaseID = su.CaseID AND e.EventType = 'IndexCreated'
                            AND e.ObjectName = CONCAT(su.SchemaName, N'.', su.TableName, N'.', st.StatsName))

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.