Pahalı sorgular0x244BA180E697454B
Demo modu

Sorgu 0x244BA180E697454B

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,1 ms
Ort. CPU 6,1 ms
Bekleme payı %0,5
Ort. mantıksal okuma 226
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,7 ms29.09.2026: 107 çalışma, ort. 1,7 ms30.09.2026: 349 çalışma, ort. 1,8 ms1.10.2026: 49 çalışma, ort. 2,0 ms2.10.2026: 83 çalışma, ort. 1,6 ms3.10.2026: 1 çalışma, ort. 79,4 ms4.10.2026: 57 çalışma, ort. 40,4 ms5.10.2026: 211 çalışma, ort. 4,2 ms6.10.2026: 50 çalışma, ort. 14,2 ms7.10.2026: 49 çalışma, ort. 10,7 ms9.10.2026: 33 çalışma, ort. 22,1 ms max 349 çalışma max ort. süre 79,4 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 82563
  2. 9.10.2026 19:00 yeni plan plan 82535
  3. 9.10.2026 17:00 yeni plan plan 81578
  4. 9.10.2026 17:00 yeni plan plan 81540
  5. 9.10.2026 14:00 yeni plan plan 80961
  6. 9.10.2026 14:00 yeni plan plan 80535
  7. 9.10.2026 14:00 yeni plan plan 80497
  8. 9.10.2026 14:00 yeni plan plan 79614
  9. 9.10.2026 14:00 yeni plan plan 79595
  10. 9.10.2026 13:00 yeni plan plan 78693
  11. 9.10.2026 13:00 yeni plan plan 78652
  12. 8.10.2026 19:00 yeni plan plan 77191
  13. 8.10.2026 19:00 yeni plan plan 77166
  14. 8.10.2026 18:00 yeni plan plan 76285
  15. 8.10.2026 18:00 yeni plan plan 76260
  16. 8.10.2026 17:00 yeni plan plan 75359
  17. 8.10.2026 17:00 yeni plan plan 75323
  18. 8.10.2026 16:00 yeni plan plan 74451
  19. 8.10.2026 16:00 yeni plan plan 74424
  20. 8.10.2026 16:00 yeni plan plan 73588
  21. 8.10.2026 16:00 yeni plan plan 73549
  22. 8.10.2026 14:00 yeni plan plan 72599
  23. 8.10.2026 14:00 yeni plan plan 72569
  24. 8.10.2026 12:00 yeni plan plan 70776
  25. 8.10.2026 12:00 yeni plan plan 70811
  26. 8.10.2026 12:00 yeni plan plan 71657
  27. 8.10.2026 12:00 yeni plan plan 71695
  28. 7.10.2026 20:00 yeni plan plan 69811
  29. 7.10.2026 20:00 yeni plan plan 69768
  30. 7.10.2026 20:00 yeni plan plan 68919
  31. 7.10.2026 20:00 yeni plan plan 68897
  32. 7.10.2026 20:00 yeni plan plan 67336
  33. 7.10.2026 20:00 yeni plan plan 67301
  34. 7.10.2026 20:00 yeni plan plan 66389
  35. 7.10.2026 20:00 yeni plan plan 66363
  36. 7.10.2026 13:00 yeni plan plan 65351
  37. 7.10.2026 13:00 yeni plan plan 65319
  38. 6.10.2026 00:00 yeni plan plan 63991
  39. 6.10.2026 00:00 yeni plan plan 63952
  40. 5.10.2026 23:00 yeni plan plan 63064
  41. 5.10.2026 23:00 yeni plan plan 63045
  42. 5.10.2026 22:00 yeni plan plan 61466
  43. 5.10.2026 22:00 yeni plan plan 61432
  44. 5.10.2026 22:00 yeni plan plan 60586
  45. 5.10.2026 22:00 yeni plan plan 60547
  46. 5.10.2026 21:00 yeni plan plan 58027
  47. 5.10.2026 21:00 yeni plan plan 58069
  48. 5.10.2026 21:00 yeni plan plan 58889
  49. 5.10.2026 21:00 yeni plan plan 58920
  50. 5.10.2026 21:00 yeni plan plan 59710
  51. 5.10.2026 21:00 yeni plan plan 59731
  52. 5.10.2026 20:00 yeni plan plan 57173
  53. 5.10.2026 20:00 yeni plan plan 57131
  54. 5.10.2026 18:00 yeni plan plan 56318
  55. 5.10.2026 18:00 yeni plan plan 56285
  56. 5.10.2026 17:00 yeni plan plan 55480
  57. 5.10.2026 17:00 yeni plan plan 55437
  58. 5.10.2026 17:00 yeni plan plan 54655
  59. 5.10.2026 17:00 yeni plan plan 54616
  60. 5.10.2026 13:00 yeni plan plan 53768
  61. 5.10.2026 13:00 yeni plan plan 53744
  62. 5.10.2026 13:00 yeni plan plan 52948
  63. 5.10.2026 13:00 yeni plan plan 52925
  64. 5.10.2026 12:00 yeni plan plan 51437
  65. 5.10.2026 12:00 yeni plan plan 51398
  66. 5.10.2026 12:00 yeni plan plan 49898
  67. 5.10.2026 12:00 yeni plan plan 49864
  68. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  69. 5.10.2026 10:00 yeni plan plan 47285
  70. 5.10.2026 10:00 yeni plan plan 47303
  71. 5.10.2026 10:00 yeni plan plan 48088
  72. 5.10.2026 10:00 yeni plan plan 48113
  73. 5.10.2026 10:00 yeni plan plan 48970
  74. 5.10.2026 10:00 yeni plan plan 49006
  75. 5.10.2026 09:00 yeni plan plan 45629
  76. 5.10.2026 09:00 yeni plan plan 45591
  77. 5.10.2026 09:00 yeni plan plan 44390
  78. 5.10.2026 09:00 yeni plan plan 44356
  79. 5.10.2026 09:00 yeni plan plan 43571
  80. 5.10.2026 08:00 yeni plan plan 43230
  81. 5.10.2026 02:00 yeni plan plan 42648
  82. 5.10.2026 02:00 yeni plan plan 42621
  83. 5.10.2026 00:00 yeni plan plan 41843
  84. 5.10.2026 00:00 yeni plan plan 41814
  85. 4.10.2026 22:00 yeni plan plan 40993
  86. 4.10.2026 22:00 yeni plan plan 40972
  87. 4.10.2026 21:00 yeni plan plan 40564
  88. 4.10.2026 13:00 yeni plan plan 40027
  89. 4.10.2026 13:00 yeni plan plan 39998
  90. 4.10.2026 13:00 yeni plan plan 39278
  91. 4.10.2026 13:00 yeni plan plan 39252
  92. 4.10.2026 13:00 yeni plan plan 38501
  93. 4.10.2026 13:00 yeni plan plan 38481
  94. 4.10.2026 10:00 yeni plan plan 37990
  95. 4.10.2026 08:00 yeni plan plan 37471
  96. 4.10.2026 08:00 yeni plan plan 37434
  97. 2.10.2026 17:00 yeni plan plan 36536
  98. 2.10.2026 17:00 yeni plan plan 36515
  99. 2.10.2026 17:00 yeni plan plan 35824
  100. 2.10.2026 17:00 yeni plan plan 35800
  101. 2.10.2026 17:00 yeni plan plan 35074
  102. 2.10.2026 17:00 yeni plan plan 35054
  103. 2.10.2026 16:00 yeni plan plan 34129
  104. 2.10.2026 16:00 yeni plan plan 34110
  105. 2.10.2026 02:00 yeni plan plan 33708
  106. 2.10.2026 02:00 yeni plan plan 33665
  107. 2.10.2026 01:00 yeni plan plan 33007
  108. 2.10.2026 01:00 yeni plan plan 32967
  109. 2.10.2026 00:00 yeni plan plan 31782
  110. 2.10.2026 00:00 yeni plan plan 31745
  111. 1.10.2026 21:00 yeni plan plan 31087
  112. 1.10.2026 21:00 yeni plan plan 30694
  113. 1.10.2026 20:00 yeni plan plan 30280
  114. 1.10.2026 20:00 yeni plan plan 30261
  115. 1.10.2026 20:00 yeni plan plan 29654
  116. 1.10.2026 20:00 yeni plan plan 29611
  117. 1.10.2026 19:00 yeni plan plan 27536
  118. 1.10.2026 19:00 yeni plan plan 27569
  119. 1.10.2026 19:00 yeni plan plan 28207
  120. 1.10.2026 19:00 yeni plan plan 28237
  121. 1.10.2026 19:00 yeni plan plan 28886
  122. 1.10.2026 19:00 yeni plan plan 28910
  123. 30.09.2026 22:00 yeni plan plan 26864
  124. 30.09.2026 22:00 yeni plan plan 26835
  125. 30.09.2026 22:00 yeni plan plan 26208
  126. 30.09.2026 22:00 yeni plan plan 26189
  127. 30.09.2026 22:00 yeni plan plan 25534
  128. 30.09.2026 22:00 yeni plan plan 25509
  129. 30.09.2026 22:00 yeni plan plan 24574
  130. 30.09.2026 22:00 yeni plan plan 24559
  131. 30.09.2026 22:00 yeni plan plan 24308
  132. 30.09.2026 22:00 yeni plan plan 24265
  133. 30.09.2026 22:00 yeni plan plan 23776
  134. 30.09.2026 22:00 yeni plan plan 23735
  135. 30.09.2026 22:00 yeni plan plan 23114
  136. 30.09.2026 22:00 yeni plan plan 23089
  137. 30.09.2026 21:00 yeni plan plan 20451
  138. 30.09.2026 21:00 yeni plan plan 20494
  139. 30.09.2026 21:00 yeni plan plan 21118
  140. 30.09.2026 21:00 yeni plan plan 21138
  141. 30.09.2026 21:00 yeni plan plan 21768
  142. 30.09.2026 21:00 yeni plan plan 21787
  143. 30.09.2026 21:00 yeni plan plan 22411
  144. 30.09.2026 21:00 yeni plan plan 22445
  145. 30.09.2026 20:00 yeni plan plan 19793
  146. 30.09.2026 20:00 yeni plan plan 19754
  147. 30.09.2026 19:00 yeni plan plan 19064
  148. 30.09.2026 19:00 yeni plan plan 19035
  149. 30.09.2026 15:00 yeni plan plan 18403
  150. 30.09.2026 15:00 yeni plan plan 18366
  151. 30.09.2026 15:00 yeni plan plan 17761
  152. 30.09.2026 15:00 yeni plan plan 17734
  153. 30.09.2026 15:00 yeni plan plan 17101
  154. 30.09.2026 15:00 yeni plan plan 17082
  155. 30.09.2026 11:00 yeni plan plan 15570
  156. 30.09.2026 11:00 yeni plan plan 15556
  157. 30.09.2026 11:00 yeni plan plan 15240
  158. 30.09.2026 11:00 yeni plan plan 15223
  159. 30.09.2026 11:00 yeni plan plan 14620
  160. 30.09.2026 11:00 yeni plan plan 14585
  161. 30.09.2026 10:00 yeni plan plan 12883
  162. 30.09.2026 10:00 yeni plan plan 12901
  163. 30.09.2026 10:00 yeni plan plan 13979
  164. 30.09.2026 10:00 yeni plan plan 14020
  165. 30.09.2026 06:00 yeni plan plan 11983
  166. 30.09.2026 06:00 yeni plan plan 11969
  167. 30.09.2026 06:00 yeni plan plan 11231
  168. 30.09.2026 06:00 yeni plan plan 11194
  169. 30.09.2026 06:00 yeni plan plan 10653
  170. 30.09.2026 06:00 yeni plan plan 10631
  171. 30.09.2026 05:00 yeni plan plan 10107
  172. 30.09.2026 05:00 yeni plan plan 10068
  173. 30.09.2026 00:00 yeni plan plan 9049
  174. 30.09.2026 00:00 yeni plan plan 9032
  175. 29.09.2026 21:00 yeni plan plan 8608
  176. 29.09.2026 21:00 yeni plan plan 8576
  177. 29.09.2026 21:00 yeni plan plan 8189
  178. 29.09.2026 21:00 yeni plan plan 8148
  179. 29.09.2026 20:00 yeni plan plan 7687
  180. 29.09.2026 20:00 yeni plan plan 7668
  181. 28.09.2026 19:00 yeni plan plan 6563
  182. 28.09.2026 19:00 yeni plan plan 6477
  183. 28.09.2026 16:00 yeni plan plan 6070
  184. 28.09.2026 16:00 yeni plan plan 6029
  185. 28.09.2026 16:00 yeni plan plan 5997

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28532,72,7 15,6159
2026-09-291071,71,7 4,799
2026-09-303491,81,8 2,497
2026-10-01491,72,0 5,5103
2026-10-02831,61,6 1,994
2026-10-03179,479,4 79,42.792
2026-10-045740,340,4 152,71.279
2026-10-052114,24,2 44,0160
2026-10-065014,214,2 317,5533
2026-10-074910,710,7 84,7340
2026-10-093321,622,1 406,5516

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
814861,31,394 29.09.2026 21:26 en iyi
6304521,31,3102 5.10.2026 23:04
857661,31,392 29.09.2026 21:50
1006861,31,391 30.09.2026 05:49
4097261,31,395 4.10.2026 22:07
766861,31,391 29.09.2026 20:13
3028061,31,392 1.10.2026 20:58
2961161,31,392 1.10.2026 20:57
6889761,31,390 7.10.2026 20:51
2686421,31,394 30.09.2026 22:56
3370821,31,396 2.10.2026 02:27
4808861,41,492 5.10.2026 10:03
4181461,41,494 5.10.2026 00:27
6733641,41,492 7.10.2026 20:50
1123141,41,490 30.09.2026 06:59
7081121,41,495 8.10.2026 12:20
2888661,41,495 1.10.2026 19:31
6535121,41,492 7.10.2026 13:55
1063161,41,490 30.09.2026 06:32
2683561,41,494 30.09.2026 22:56
3412971,41,494 2.10.2026 16:25
11194121,41,493 30.09.2026 06:59
7077661,41,493 8.10.2026 12:20
3296761,41,495 2.10.2026 01:09
2620821,41,494 30.09.2026 22:53
3366561,41,490 2.10.2026 02:27
5628561,41,491 5.10.2026 18:28
6891921,41,492 7.10.2026 20:51
4811321,41,493 5.10.2026 10:03
4728521,41,493 5.10.2026 10:00
2891021,41,498 1.10.2026 19:31
67301121,41,492 7.10.2026 20:50
5543761,41,492 5.10.2026 17:58
11969121,41,492 30.09.2026 07:00
2756921,41,497 1.10.2026 19:13
3580061,41,494 2.10.2026 17:32
3505421,41,496 2.10.2026 17:24
7959521,41,498 9.10.2026 14:27
3999861,41,492 4.10.2026 13:45
1010721,41,392 30.09.2026 05:49
818921,41,498 29.09.2026 21:26
4897061,41,492 5.10.2026 10:42
860821,41,494 29.09.2026 21:50
7535921,51,598 8.10.2026 17:17
2965421,51,596 1.10.2026 20:57
7532361,51,589 8.10.2026 17:17
2753661,51,593 1.10.2026 19:13
5374461,51,593 5.10.2026 13:58
7442461,51,594 8.10.2026 16:38
5465521,51,595 5.10.2026 17:49
6976861,51,594 7.10.2026 20:53
2618961,51,592 30.09.2026 22:53
3300721,51,594 2.10.2026 01:09
1397961,51,592 30.09.2026 10:56
4184321,51,592 5.10.2026 00:27
1840321,51,594 30.09.2026 15:51
3108761,51,592 1.10.2026 21:13
2311421,51,597 30.09.2026 22:15
3411041,51,595 2.10.2026 16:25
768721,51,596 29.09.2026 20:13
1708221,51,595 30.09.2026 15:32
7259921,51,594 8.10.2026 14:01
6531961,51,592 7.10.2026 13:55
7165761,51,596 8.10.2026 12:37
5806921,51,598 5.10.2026 21:02
6058621,51,592 5.10.2026 22:04
1522321,51,594 30.09.2026 11:08
2823721,51,597 1.10.2026 19:18
61432121,51,595 5.10.2026 22:56
63952361,51,594 6.10.2026 05:50
5802761,51,593 5.10.2026 21:02
8253561,51,592 9.10.2026 19:25
3582421,51,597 2.10.2026 17:32
6636361,51,591 7.10.2026 20:12
36536181,51,594 2.10.2026 18:17
2550961,51,595 30.09.2026 22:40
8157821,51,592 9.10.2026 17:45
8256321,51,593 9.10.2026 19:25
7256961,51,594 8.10.2026 14:01
5294861,61,693 5.10.2026 13:19
7169521,61,697 8.10.2026 12:37
5717321,61,6100 5.10.2026 20:19
4262161,61,691 5.10.2026 02:58
2457441,61,692 30.09.2026 22:38
5971061,61,693 5.10.2026 21:41
4730361,61,692 5.10.2026 10:00
7961461,61,696 9.10.2026 14:27
1773461,61,693 30.09.2026 15:42
1288341,61,695 30.09.2026 10:52
12901121,61,692 30.09.2026 10:52
6563791,61,693 29.09.2026 18:42
6070181,61,693 28.09.2026 17:03
3927821,61,692 4.10.2026 13:31
6306461,61,694 5.10.2026 23:04
45591121,61,692 5.10.2026 09:49
7716661,61,692 8.10.2026 19:59
2820761,61,694 1.10.2026 19:19
1903561,61,690 30.09.2026 19:36
9049601,61,694 30.09.2026 05:42
2241161,61,694 30.09.2026 21:37
5376821,61,694 5.10.2026 13:58
1979321,61,694 30.09.2026 20:42
4357161,61,691 5.10.2026 09:01
3850161,61,693 4.10.2026 13:28
1462021,61,694 30.09.2026 11:02
8049761,61,694 9.10.2026 14:29
1198341,61,692 30.09.2026 07:00
1975461,61,691 30.09.2026 20:42
5973121,61,694 5.10.2026 21:41
5548021,61,697 5.10.2026 17:58
5631821,71,793 5.10.2026 18:28
6146641,71,797 5.10.2026 22:56
5713161,71,793 5.10.2026 20:19
2176821,71,796 30.09.2026 21:34
7865261,71,796 9.10.2026 13:15
2430821,71,793 30.09.2026 22:35
6054761,71,792 5.10.2026 22:04
24559121,71,794 30.09.2026 22:38
3178241,71,798 2.10.2026 00:06
1065321,71,690 30.09.2026 06:32
7869321,71,794 9.10.2026 13:15
1776121,71,794 30.09.2026 15:42
8053521,71,795 9.10.2026 14:29
8154061,71,792 9.10.2026 17:45
5143741,71,794 5.10.2026 12:59
1557081,71,794 30.09.2026 11:22
1524061,71,792 30.09.2026 11:08
1836661,71,792 30.09.2026 15:51
4562941,71,792 5.10.2026 09:48
2308961,71,792 30.09.2026 22:15
2553421,71,792 30.09.2026 22:40
3925261,71,792 4.10.2026 13:31
3026121,81,896 1.10.2026 20:58
23735121,81,893 30.09.2026 22:19
1710161,81,893 30.09.2026 15:32
4989841,81,898 5.10.2026 12:33
5461661,81,896 5.10.2026 17:49
49864121,81,891 5.10.2026 12:33
5892021,81,890 5.10.2026 21:38
3507461,81,895 2.10.2026 17:24
1458561,81,896 30.09.2026 11:02
1402021,81,890 30.09.2026 10:56
5888961,91,992 5.10.2026 21:38
31745121,91,994 2.10.2026 00:06
15556241,91,992 30.09.2026 11:22
5292521,91,992 5.10.2026 13:19
7445121,91,992 8.10.2026 16:38
7626062,01,995 8.10.2026 18:57
2426562,02,093 30.09.2026 22:35
2111862,02,095 30.09.2026 21:32
7354962,02,091 8.10.2026 16:34
51398122,02,091 5.10.2026 12:59
4435662,02,092 5.10.2026 09:09
2244522,01,997 30.09.2026 21:37
9032212,12,1114 30.09.2026 05:42
3743462,12,192 4.10.2026 08:55
4900622,12,193 5.10.2026 10:42
2178762,32,393 30.09.2026 21:34
2045162,32,392 30.09.2026 21:24
2113822,32,391 30.09.2026 21:32
2377652,52,5132 30.09.2026 22:30
7628523,03,096 8.10.2026 18:57
7358823,03,099 8.10.2026 16:34
6477313,23,2177 29.09.2026 18:42
602973,53,5206 28.09.2026 17:03
2049434,54,5199 30.09.2026 21:30
1906445,55,5236 30.09.2026 20:30
30694310,06,2238 1.10.2026 21:13
5997117,817,8868 28.09.2026 16:24
36515937,037,01.156 4.10.2026 08:30
38481337,537,51.346 4.10.2026 13:30
37471339,839,81.314 4.10.2026 09:30
639911446,646,61.663 6.10.2026 22:15
42648347,347,31.636 5.10.2026 03:30
44390358,058,01.706 5.10.2026 09:30
43230378,978,91.650 5.10.2026 09:01
40993497,597,52.280 4.10.2026 23:30
40027997,697,63.349 4.10.2026 20:30
379903116,7116,23.722 4.10.2026 12:30
663893152,8152,84.148 7.10.2026 20:40
405641155,3155,34.443 4.10.2026 21:30
771913171,0166,64.686 8.10.2026 20:03
698113211,5202,74.382 8.10.2026 08:30
809611676,4660,913.995 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
Memory:36,Idle:32,Buffer Latch: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 XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
        SELECT DISTINCT px.CaseID, px.PlanRole,
               PARSENAME(n.value('@Schema', 'nvarchar(260)'), 1) AS SchemaName,
               PARSENAME(n.value('@Table', 'nvarchar(260)'), 1) AS TableName,
               PARSENAME(n.value('@Statistics', 'nvarchar(260)'), 1) AS StatsName
        INTO #pstat
        FROM #px AS px
        CROSS APPLY px.PlanXml.nodes('//OptimizerStatsUsage/StatisticsInfo') AS o (n)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.