Pahalı sorgular0x2FD14409B4F370AB
Demo modu

Sorgu 0x2FD14409B4F370AB

SQL-1 · DB-11· test_PlanChange.test yeni index olayi kesin zamanli ve plan kullanimi isaretli ilk toplama index i olay degil · dönem 2026-09-12 → 2026-10-11 · 126 çalışma · Pahalı sorgulara dön

Ort. süre 1,1 ms
Ort. CPU 1,1 ms
Bekleme payı %1,3
Ort. mantıksal okuma 103
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: 6 çalışma, ort. 1,1 ms29.09.2026: 13 çalışma, ort. 1,2 ms30.09.2026: 43 çalışma, ort. 1,0 ms1.10.2026: 6 çalışma, ort. 1,8 ms2.10.2026: 11 çalışma, ort. 0,9 ms4.10.2026: 5 çalışma, ort. 1,0 ms5.10.2026: 26 çalışma, ort. 1,1 ms6.10.2026: 6 çalışma, ort. 0,9 ms7.10.2026: 6 çalışma, ort. 0,9 ms9.10.2026: 4 çalışma, ort. 1,1 ms max 43 ç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 82557
  2. 9.10.2026 17:00 yeni plan plan 81564
  3. 9.10.2026 14:00 yeni plan plan 79637
  4. 9.10.2026 14:00 yeni plan plan 80510
  5. 9.10.2026 13:00 yeni plan plan 78687
  6. 8.10.2026 19:00 yeni plan plan 77207
  7. 8.10.2026 18:00 yeni plan plan 76308
  8. 8.10.2026 17:00 yeni plan plan 75346
  9. 8.10.2026 16:00 yeni plan plan 73569
  10. 8.10.2026 16:00 yeni plan plan 74437
  11. 8.10.2026 14:00 yeni plan plan 72621
  12. 8.10.2026 12:00 yeni plan plan 70804
  13. 8.10.2026 12:00 yeni plan plan 71676
  14. 7.10.2026 20:00 yeni plan plan 66376
  15. 7.10.2026 20:00 yeni plan plan 67353
  16. 7.10.2026 20:00 yeni plan plan 68103
  17. 7.10.2026 20:00 yeni plan plan 68945
  18. 7.10.2026 20:00 yeni plan plan 69803
  19. 7.10.2026 13:00 yeni plan plan 65338
  20. 6.10.2026 00:00 yeni plan plan 63972
  21. 5.10.2026 23:00 yeni plan plan 63095
  22. 5.10.2026 22:00 yeni plan plan 60560
  23. 5.10.2026 22:00 yeni plan plan 61484
  24. 5.10.2026 22:00 yeni plan plan 62206
  25. 5.10.2026 21:00 yeni plan plan 58051
  26. 5.10.2026 21:00 yeni plan plan 58936
  27. 5.10.2026 21:00 yeni plan plan 59758
  28. 5.10.2026 20:00 yeni plan plan 57150
  29. 5.10.2026 18:00 yeni plan plan 56298
  30. 5.10.2026 17:00 yeni plan plan 54638
  31. 5.10.2026 17:00 yeni plan plan 55465
  32. 5.10.2026 13:00 yeni plan plan 52956
  33. 5.10.2026 13:00 yeni plan plan 53757
  34. 5.10.2026 12:00 yeni plan plan 49877
  35. 5.10.2026 12:00 yeni plan plan 50632
  36. 5.10.2026 12:00 yeni plan plan 51431
  37. 5.10.2026 12:00 yeni plan plan 52144
  38. 5.10.2026 10:00 yeni plan plan 47334
  39. 5.10.2026 10:00 yeni plan plan 48129
  40. 5.10.2026 10:00 yeni plan plan 49000
  41. 5.10.2026 09:00 yeni plan plan 43620
  42. 5.10.2026 09:00 yeni plan plan 44369
  43. 5.10.2026 09:00 yeni plan plan 45613
  44. 5.10.2026 09:00 yeni plan plan 46356
  45. 5.10.2026 02:00 yeni plan plan 42665
  46. 5.10.2026 00:00 yeni plan plan 41837
  47. 4.10.2026 22:00 yeni plan plan 41010
  48. 4.10.2026 13:00 yeni plan plan 38525
  49. 4.10.2026 13:00 yeni plan plan 39300
  50. 4.10.2026 13:00 yeni plan plan 40044
  51. 4.10.2026 08:00 yeni plan plan 37465
  52. 2.10.2026 17:00 yeni plan plan 35104
  53. 2.10.2026 17:00 yeni plan plan 35840
  54. 2.10.2026 17:00 yeni plan plan 36544
  55. 2.10.2026 16:00 yeni plan plan 34136
  56. 2.10.2026 02:00 yeni plan plan 33685
  57. 2.10.2026 01:00 yeni plan plan 32980
  58. 2.10.2026 00:00 yeni plan plan 31798
  59. 2.10.2026 00:00 yeni plan plan 32357
  60. 1.10.2026 21:00 yeni plan plan 31136
  61. 1.10.2026 20:00 yeni plan plan 29648
  62. 1.10.2026 20:00 yeni plan plan 30303
  63. 1.10.2026 19:00 yeni plan plan 27588
  64. 1.10.2026 19:00 yeni plan plan 28231
  65. 1.10.2026 19:00 yeni plan plan 28899
  66. 30.09.2026 22:00 yeni plan plan 23102
  67. 30.09.2026 22:00 yeni plan plan 23757
  68. 30.09.2026 22:00 yeni plan plan 24295
  69. 30.09.2026 22:00 yeni plan plan 24936
  70. 30.09.2026 22:00 yeni plan plan 25550
  71. 30.09.2026 22:00 yeni plan plan 26224
  72. 30.09.2026 22:00 yeni plan plan 26887
  73. 30.09.2026 21:00 yeni plan plan 20478
  74. 30.09.2026 21:00 yeni plan plan 21157
  75. 30.09.2026 21:00 yeni plan plan 21816
  76. 30.09.2026 21:00 yeni plan plan 22431
  77. 30.09.2026 20:00 yeni plan plan 19787
  78. 30.09.2026 19:00 yeni plan plan 19081
  79. 30.09.2026 15:00 yeni plan plan 17131
  80. 30.09.2026 15:00 yeni plan plan 17754
  81. 30.09.2026 15:00 yeni plan plan 18386
  82. 30.09.2026 11:00 yeni plan plan 14610
  83. 30.09.2026 11:00 yeni plan plan 15259
  84. 30.09.2026 11:00 yeni plan plan 15932
  85. 30.09.2026 11:00 yeni plan plan 16487
  86. 30.09.2026 10:00 yeni plan plan 12917
  87. 30.09.2026 10:00 yeni plan plan 13439
  88. 30.09.2026 10:00 yeni plan plan 14010
  89. 30.09.2026 07:00 yeni plan plan 12325
  90. 30.09.2026 06:00 yeni plan plan 10680
  91. 30.09.2026 06:00 yeni plan plan 11225
  92. 30.09.2026 06:00 yeni plan plan 11732
  93. 30.09.2026 05:00 yeni plan plan 10081
  94. 30.09.2026 00:00 yeni plan plan 9078
  95. 29.09.2026 21:00 yeni plan plan 8178
  96. 29.09.2026 21:00 yeni plan plan 8628
  97. 29.09.2026 20:00 yeni plan plan 7703
  98. 28.09.2026 16:00 yeni plan plan 6089

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2861,11,1 1,3108
2026-09-29131,11,2 1,4100
2026-09-30431,01,0 1,4102
2026-10-0161,81,8 4,399
2026-10-02110,90,9 0,9107
2026-10-0451,01,0 1,2100
2026-10-05261,11,1 1,6103
2026-10-0660,90,9 0,9102
2026-10-0760,90,9 1,0104
2026-10-0941,11,1 1,2102

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
7356910,80,8104 8.10.2026 16:34 en iyi
3510410,80,8104 2.10.2026 17:24
3368510,80,8101 2.10.2026 02:27
3298010,80,8117 2.10.2026 01:09
4101010,90,997 4.10.2026 22:07
2758810,90,9106 1.10.2026 19:13
6148410,90,9106 5.10.2026 22:56
1122510,90,9104 30.09.2026 06:58
7720710,90,998 8.10.2026 19:59
770310,90,998 29.09.2026 20:13
817810,90,997 29.09.2026 21:26
6735310,90,9104 7.10.2026 20:49
862810,90,998 29.09.2026 21:50
5375710,90,9104 5.10.2026 13:58
4812910,90,9104 5.10.2026 10:03
3852510,90,9100 4.10.2026 13:29
6533810,90,997 7.10.2026 13:55
6894510,90,9102 7.10.2026 20:51
7080410,90,997 8.10.2026 12:20
3584010,90,9104 2.10.2026 17:32
6309510,90,9104 5.10.2026 23:04
2964810,90,997 1.10.2026 20:57
6980310,90,9111 7.10.2026 20:53
2181610,90,998 30.09.2026 21:34
4900010,90,9104 5.10.2026 10:42
3413620,90,9108 2.10.2026 16:25
3746510,90,997 4.10.2026 08:55
6397260,90,9102 6.10.2026 05:50
3654430,90,9111 2.10.2026 18:17
3235710,90,9104 2.10.2026 00:06
3179810,90,997 2.10.2026 00:05
4635610,90,9104 5.10.2026 09:48
1008110,90,9102 30.09.2026 05:49
6637611,01,0104 7.10.2026 20:12
7167611,01,0100 8.10.2026 12:37
1838611,01,097 30.09.2026 15:51
9078101,01,0103 30.09.2026 05:42
2889911,01,0100 1.10.2026 19:31
4362011,01,097 5.10.2026 09:01
4004411,01,0104 4.10.2026 13:45
1978711,01,0117 30.09.2026 20:42
2622411,01,098 30.09.2026 22:53
6810311,01,0105 7.10.2026 20:50
4733411,01,098 5.10.2026 10:00
4987711,01,0100 5.10.2026 12:32
1525921,01,0102 30.09.2026 11:15
1291711,01,097 30.09.2026 10:51
5295611,01,097 5.10.2026 13:19
1593221,01,0104 30.09.2026 11:20
2493611,01,0104 30.09.2026 22:38
1401011,01,099 30.09.2026 10:56
2310211,01,097 30.09.2026 22:15
2429521,01,099 30.09.2026 22:38
1173221,01,0104 30.09.2026 06:59
8051011,01,0104 9.10.2026 14:29
5715011,01,097 5.10.2026 20:19
5143111,01,0105 5.10.2026 12:58
2047811,01,0105 30.09.2026 21:24
5805111,01,0104 5.10.2026 21:02
2375721,01,097 30.09.2026 22:19
4561311,01,0104 5.10.2026 09:48
8255711,01,097 9.10.2026 19:25
1461011,11,1105 30.09.2026 11:02
2243111,11,1101 30.09.2026 21:37
1343911,11,1108 30.09.2026 10:52
1648711,11,1108 30.09.2026 11:22
1908111,11,1104 30.09.2026 19:36
4266511,11,1101 5.10.2026 02:58
1232511,11,1101 30.09.2026 07:00
2688711,11,199 30.09.2026 22:56
1713111,11,1109 30.09.2026 15:32
8156411,11,1101 9.10.2026 17:45
2555011,11,1104 30.09.2026 22:40
5063211,11,1108 5.10.2026 12:33
7963711,21,2104 9.10.2026 14:27
7868711,21,297 9.10.2026 13:15
5463811,21,298 5.10.2026 17:49
4436911,21,2104 5.10.2026 09:09
4183711,21,2105 5.10.2026 00:27
3930011,21,2104 4.10.2026 13:31
3030311,21,299 1.10.2026 20:58
6089161,21,1104 29.09.2026 18:42
7443711,21,2111 8.10.2026 16:38
6220611,21,2115 5.10.2026 22:56
5629811,31,397 5.10.2026 18:28
7262111,31,397 8.10.2026 14:01
7534611,30,9104 8.10.2026 17:17
6056011,31,3109 5.10.2026 22:03
1775411,31,397 30.09.2026 15:42
5214411,41,4101 5.10.2026 12:59
1068011,41,4100 30.09.2026 06:32
5975811,61,697 5.10.2026 21:41
5893611,61,6100 5.10.2026 21:38
2115711,81,8105 30.09.2026 21:32
5546511,91,9104 5.10.2026 17:58
3113612,02,097 1.10.2026 21:13
7630814,74,7105 8.10.2026 18:57
2823115,15,197 1.10.2026 19:18 en kötü

Davranış

Wait kategorileri (QDS)
CPU:1
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 
SELECT TOP (0) * INTO #expected FROM #actual

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.