Pahalı sorgular0xAFD0FE2F1296D97D
Demo modu

Sorgu 0xAFD0FE2F1296D97D

SQL-1 · DB-11· test_PlanChange.test esik alti ve kucuk mutlak fark elenir esigi gecen vaka olur · dönem 2026-09-12 → 2026-10-11 · 125 çalışma · Pahalı sorgulara dön

Ort. süre 1,1 ms
Ort. CPU 1,1 ms
Bekleme payı %1,7
Ort. mantıksal okuma 115
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,2 ms29.09.2026: 13 çalışma, ort. 1,2 ms30.09.2026: 43 çalışma, ort. 1,1 ms1.10.2026: 6 çalışma, ort. 1,0 ms2.10.2026: 10 çalışma, ort. 1,1 ms4.10.2026: 5 çalışma, ort. 1,0 ms5.10.2026: 26 çalışma, ort. 1,2 ms6.10.2026: 6 çalışma, ort. 1,0 ms7.10.2026: 6 çalışma, ort. 1,0 ms9.10.2026: 4 çalışma, ort. 1,8 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 82587
  2. 9.10.2026 17:00 yeni plan plan 81591
  3. 9.10.2026 14:00 yeni plan plan 79629
  4. 9.10.2026 14:00 yeni plan plan 80516
  5. 9.10.2026 13:00 yeni plan plan 78670
  6. 8.10.2026 19:00 yeni plan plan 77185
  7. 8.10.2026 18:00 yeni plan plan 76279
  8. 8.10.2026 17:00 yeni plan plan 75353
  9. 8.10.2026 16:00 yeni plan plan 73601
  10. 8.10.2026 16:00 yeni plan plan 74469
  11. 8.10.2026 14:00 yeni plan plan 72612
  12. 8.10.2026 12:00 yeni plan plan 70794
  13. 8.10.2026 12:00 yeni plan plan 71687
  14. 7.10.2026 20:00 yeni plan plan 66406
  15. 7.10.2026 20:00 yeni plan plan 67314
  16. 7.10.2026 20:00 yeni plan plan 68109
  17. 7.10.2026 20:00 yeni plan plan 68912
  18. 7.10.2026 20:00 yeni plan plan 69781
  19. 7.10.2026 13:00 yeni plan plan 65343
  20. 6.10.2026 00:00 yeni plan plan 63981
  21. 5.10.2026 23:00 yeni plan plan 63075
  22. 5.10.2026 22:00 yeni plan plan 60566
  23. 5.10.2026 22:00 yeni plan plan 61460
  24. 5.10.2026 22:00 yeni plan plan 62196
  25. 5.10.2026 21:00 yeni plan plan 58055
  26. 5.10.2026 21:00 yeni plan plan 58902
  27. 5.10.2026 21:00 yeni plan plan 59762
  28. 5.10.2026 20:00 yeni plan plan 57167
  29. 5.10.2026 18:00 yeni plan plan 56334
  30. 5.10.2026 17:00 yeni plan plan 54649
  31. 5.10.2026 17:00 yeni plan plan 55455
  32. 5.10.2026 13:00 yeni plan plan 52971
  33. 5.10.2026 13:00 yeni plan plan 53787
  34. 5.10.2026 12:00 yeni plan plan 49887
  35. 5.10.2026 12:00 yeni plan plan 50623
  36. 5.10.2026 12:00 yeni plan plan 51450
  37. 5.10.2026 12:00 yeni plan plan 52156
  38. 5.10.2026 10:00 yeni plan plan 47325
  39. 5.10.2026 10:00 yeni plan plan 48107
  40. 5.10.2026 10:00 yeni plan plan 48987
  41. 5.10.2026 09:00 yeni plan plan 43586
  42. 5.10.2026 09:00 yeni plan plan 44379
  43. 5.10.2026 09:00 yeni plan plan 45604
  44. 5.10.2026 09:00 yeni plan plan 46376
  45. 5.10.2026 02:00 yeni plan plan 42634
  46. 5.10.2026 00:00 yeni plan plan 41827
  47. 4.10.2026 22:00 yeni plan plan 41015
  48. 4.10.2026 13:00 yeni plan plan 38518
  49. 4.10.2026 13:00 yeni plan plan 39272
  50. 4.10.2026 13:00 yeni plan plan 40013
  51. 4.10.2026 08:00 yeni plan plan 37455
  52. 2.10.2026 17:00 yeni plan plan 35096
  53. 2.10.2026 17:00 yeni plan plan 35848
  54. 2.10.2026 17:00 yeni plan plan 36556
  55. 2.10.2026 16:00 yeni plan plan 34649
  56. 2.10.2026 02:00 yeni plan plan 33692
  57. 2.10.2026 01:00 yeni plan plan 32997
  58. 2.10.2026 00:00 yeni plan plan 31770
  59. 2.10.2026 00:00 yeni plan plan 32344
  60. 1.10.2026 21:00 yeni plan plan 31100
  61. 1.10.2026 20:00 yeni plan plan 29638
  62. 1.10.2026 20:00 yeni plan plan 30288
  63. 1.10.2026 19:00 yeni plan plan 27549
  64. 1.10.2026 19:00 yeni plan plan 28220
  65. 1.10.2026 19:00 yeni plan plan 28930
  66. 30.09.2026 22:00 yeni plan plan 23108
  67. 30.09.2026 22:00 yeni plan plan 23766
  68. 30.09.2026 22:00 yeni plan plan 24300
  69. 30.09.2026 22:00 yeni plan plan 24914
  70. 30.09.2026 22:00 yeni plan plan 25528
  71. 30.09.2026 22:00 yeni plan plan 26237
  72. 30.09.2026 22:00 yeni plan plan 26878
  73. 30.09.2026 21:00 yeni plan plan 20464
  74. 30.09.2026 21:00 yeni plan plan 21167
  75. 30.09.2026 21:00 yeni plan plan 21797
  76. 30.09.2026 21:00 yeni plan plan 22458
  77. 30.09.2026 20:00 yeni plan plan 19769
  78. 30.09.2026 19:00 yeni plan plan 19055
  79. 30.09.2026 15:00 yeni plan plan 17118
  80. 30.09.2026 15:00 yeni plan plan 17775
  81. 30.09.2026 15:00 yeni plan plan 18416
  82. 30.09.2026 11:00 yeni plan plan 14614
  83. 30.09.2026 11:00 yeni plan plan 15251
  84. 30.09.2026 11:00 yeni plan plan 15936
  85. 30.09.2026 11:00 yeni plan plan 16493
  86. 30.09.2026 10:00 yeni plan plan 12933
  87. 30.09.2026 10:00 yeni plan plan 13423
  88. 30.09.2026 10:00 yeni plan plan 14000
  89. 30.09.2026 07:00 yeni plan plan 12312
  90. 30.09.2026 06:00 yeni plan plan 10646
  91. 30.09.2026 06:00 yeni plan plan 11247
  92. 30.09.2026 06:00 yeni plan plan 11721
  93. 30.09.2026 05:00 yeni plan plan 10088
  94. 30.09.2026 00:00 yeni plan plan 9071
  95. 29.09.2026 21:00 yeni plan plan 8183
  96. 29.09.2026 21:00 yeni plan plan 8621
  97. 29.09.2026 20:00 yeni plan plan 7717
  98. 28.09.2026 16:00 yeni plan plan 6121

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2861,01,2 1,5113
2026-09-29131,21,2 1,6118
2026-09-30431,11,1 1,5115
2026-10-0161,01,0 1,1114
2026-10-02101,11,1 1,6119
2026-10-0451,01,0 1,0114
2026-10-05261,21,2 1,6114
2026-10-0661,01,0 1,0117
2026-10-0761,01,0 1,3116
2026-10-0941,81,8 3,0116

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
7627910,80,8119 8.10.2026 18:57 en iyi
6640610,80,8109 7.10.2026 20:12
2687810,90,9110 30.09.2026 22:56
3369210,90,9109 2.10.2026 02:27
2963810,90,9109 1.10.2026 20:57
7535310,90,9129 8.10.2026 17:17
3234410,90,9109 2.10.2026 00:06
7360110,90,9119 8.10.2026 16:34
7168710,90,9110 8.10.2026 12:37
1008810,90,9118 30.09.2026 05:49
4101510,90,9118 4.10.2026 22:07
6891210,90,9118 7.10.2026 20:51
3464910,90,9119 2.10.2026 16:25
7079410,90,9118 8.10.2026 12:20
771710,90,9109 29.09.2026 20:13
818310,90,9121 29.09.2026 21:26
4182710,90,9109 5.10.2026 00:27
4637610,90,9115 5.10.2026 09:49
5633410,90,9109 5.10.2026 18:28
2623710,90,9121 30.09.2026 22:53
6398161,01,0117 6.10.2026 05:50
4001311,01,0120 4.10.2026 13:45
7718511,01,0109 8.10.2026 19:59
6978111,01,0121 7.10.2026 20:53
4988711,01,0110 5.10.2026 12:32
3299711,01,0134 2.10.2026 01:09
1976911,01,0110 30.09.2026 20:42
1124711,01,0113 30.09.2026 06:58
1231211,01,0109 30.09.2026 07:00
2822011,01,0115 1.10.2026 19:18
5297111,01,0112 5.10.2026 13:19
3851811,01,0114 4.10.2026 13:28
5464911,01,0119 5.10.2026 17:49
5062311,01,0113 5.10.2026 12:33
1293311,01,0109 30.09.2026 10:51
5805511,01,0120 5.10.2026 21:02
2179711,01,0118 30.09.2026 21:34
9071101,01,0116 30.09.2026 05:42
3745511,01,0109 4.10.2026 08:55
6056611,01,0112 5.10.2026 22:03
5716711,01,0119 5.10.2026 20:19
2754911,01,0121 1.10.2026 19:13
4358611,01,0112 5.10.2026 09:00
3110011,01,0110 1.10.2026 21:13
7261211,01,0118 8.10.2026 14:01
6534311,01,0118 7.10.2026 13:55
2310811,01,0109 30.09.2026 22:15
3927211,01,0109 4.10.2026 13:31
4263411,01,0118 5.10.2026 02:58
1461411,01,0118 30.09.2026 11:02
6731411,01,0120 7.10.2026 20:49
4732511,01,0119 5.10.2026 10:00
3655631,01,0121 2.10.2026 18:17
2491411,01,0109 30.09.2026 22:38
4437911,01,0109 5.10.2026 09:09
4898711,01,0110 5.10.2026 10:42
6219611,11,0110 5.10.2026 22:56
3509611,11,1109 2.10.2026 17:24
3028811,11,1110 1.10.2026 20:58
8051611,11,1111 9.10.2026 14:29
1649311,11,1112 30.09.2026 11:22
5890211,11,1114 5.10.2026 21:38
2116711,11,1118 30.09.2026 21:32
1172121,11,1120 30.09.2026 06:59
1841611,11,1113 30.09.2026 15:51
7446911,11,1119 8.10.2026 16:38
1342311,11,1112 30.09.2026 10:52
3584811,11,1118 2.10.2026 17:32
8258711,11,1119 9.10.2026 19:25
2893011,11,1116 1.10.2026 19:31
5976211,11,1118 5.10.2026 21:41
1400011,11,1115 30.09.2026 10:56
2376621,11,1115 30.09.2026 22:19
1711811,11,1109 30.09.2026 15:32
4810711,11,1109 5.10.2026 10:03
6121161,21,1117 29.09.2026 18:42
6307511,21,2109 5.10.2026 23:04
1777511,21,2112 30.09.2026 15:42
5545511,21,2110 5.10.2026 17:58
7867011,21,2125 9.10.2026 13:15
5215611,21,2113 5.10.2026 12:59
1905511,31,1118 30.09.2026 19:36
1064611,40,9109 30.09.2026 06:32
2430021,41,4116 30.09.2026 22:38
5378711,41,4109 5.10.2026 13:58
1593621,41,4116 30.09.2026 11:20
4560411,41,4119 5.10.2026 09:47
6810911,41,1109 7.10.2026 20:50
1525121,41,4118 30.09.2026 11:15
2046411,51,5112 30.09.2026 21:24
862111,51,5112 29.09.2026 21:50
7962911,51,5109 9.10.2026 14:27
6146011,61,6118 5.10.2026 22:56
2245811,61,0109 30.09.2026 21:37
3177011,91,9128 2.10.2026 00:05
2552812,12,1128 30.09.2026 22:40
8159113,33,3119 9.10.2026 17:45
5145013,73,7116 5.10.2026 12:58 en kötü

Davranış

Wait kategorileri (QDS)
–
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.