Pahalı sorgular0x683E0DD86BCE5CD9
Demo modu

Sorgu 0x683E0DD86BCE5CD9

SQL-1 · DB-11· test_PlanChange.test olay araligi degisim anini kapsiyorsa sira belirsiz · dönem 2026-09-12 → 2026-10-11 · 126 çalışma · Pahalı sorgulara dön

Ort. süre 1,0 ms
Ort. CPU 1,0 ms
Bekleme payı %0
Ort. mantıksal okuma 83
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. 0,9 ms29.09.2026: 13 çalışma, ort. 1,0 ms30.09.2026: 43 çalışma, ort. 1,0 ms1.10.2026: 6 çalışma, ort. 1,4 ms2.10.2026: 11 çalışma, ort. 1,0 ms4.10.2026: 5 çalışma, ort. 1,0 ms5.10.2026: 26 çalışma, ort. 1,0 ms6.10.2026: 6 çalışma, ort. 1,0 ms7.10.2026: 6 çalışma, ort. 0,9 ms9.10.2026: 4 çalışma, ort. 0,9 ms max 43 çalışma max ort. süre 1,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 82580
  2. 9.10.2026 17:00 yeni plan plan 81572
  3. 9.10.2026 14:00 yeni plan plan 79645
  4. 9.10.2026 14:00 yeni plan plan 80522
  5. 9.10.2026 13:00 yeni plan plan 78680
  6. 8.10.2026 19:00 yeni plan plan 77179
  7. 8.10.2026 18:00 yeni plan plan 76273
  8. 8.10.2026 17:00 yeni plan plan 75374
  9. 8.10.2026 16:00 yeni plan plan 73577
  10. 8.10.2026 16:00 yeni plan plan 74445
  11. 8.10.2026 14:00 yeni plan plan 72593
  12. 8.10.2026 12:00 yeni plan plan 70826
  13. 8.10.2026 12:00 yeni plan plan 71710
  14. 7.10.2026 20:00 yeni plan plan 66412
  15. 7.10.2026 20:00 yeni plan plan 67330
  16. 7.10.2026 20:00 yeni plan plan 68096
  17. 7.10.2026 20:00 yeni plan plan 68936
  18. 7.10.2026 20:00 yeni plan plan 69792
  19. 7.10.2026 13:00 yeni plan plan 65372
  20. 6.10.2026 00:00 yeni plan plan 63965
  21. 5.10.2026 23:00 yeni plan plan 63088
  22. 5.10.2026 22:00 yeni plan plan 60578
  23. 5.10.2026 22:00 yeni plan plan 61452
  24. 5.10.2026 22:00 yeni plan plan 62214
  25. 5.10.2026 21:00 yeni plan plan 58061
  26. 5.10.2026 21:00 yeni plan plan 58914
  27. 5.10.2026 21:00 yeni plan plan 59751
  28. 5.10.2026 20:00 yeni plan plan 57160
  29. 5.10.2026 18:00 yeni plan plan 56309
  30. 5.10.2026 17:00 yeni plan plan 54645
  31. 5.10.2026 17:00 yeni plan plan 55474
  32. 5.10.2026 13:00 yeni plan plan 52964
  33. 5.10.2026 13:00 yeni plan plan 53793
  34. 5.10.2026 12:00 yeni plan plan 49913
  35. 5.10.2026 12:00 yeni plan plan 50606
  36. 5.10.2026 12:00 yeni plan plan 51417
  37. 5.10.2026 12:00 yeni plan plan 52162
  38. 5.10.2026 10:00 yeni plan plan 47318
  39. 5.10.2026 10:00 yeni plan plan 48101
  40. 5.10.2026 10:00 yeni plan plan 49022
  41. 5.10.2026 09:00 yeni plan plan 43595
  42. 5.10.2026 09:00 yeni plan plan 44405
  43. 5.10.2026 09:00 yeni plan plan 45619
  44. 5.10.2026 09:00 yeni plan plan 46370
  45. 5.10.2026 02:00 yeni plan plan 42671
  46. 5.10.2026 00:00 yeni plan plan 41862
  47. 4.10.2026 22:00 yeni plan plan 41023
  48. 4.10.2026 13:00 yeni plan plan 38509
  49. 4.10.2026 13:00 yeni plan plan 39265
  50. 4.10.2026 13:00 yeni plan plan 40021
  51. 4.10.2026 08:00 yeni plan plan 37447
  52. 2.10.2026 17:00 yeni plan plan 35082
  53. 2.10.2026 17:00 yeni plan plan 35813
  54. 2.10.2026 17:00 yeni plan plan 36550
  55. 2.10.2026 16:00 yeni plan plan 34078
  56. 2.10.2026 02:00 yeni plan plan 33698
  57. 2.10.2026 01:00 yeni plan plan 32988
  58. 2.10.2026 00:00 yeni plan plan 31763
  59. 2.10.2026 00:00 yeni plan plan 32350
  60. 1.10.2026 21:00 yeni plan plan 31112
  61. 1.10.2026 20:00 yeni plan plan 29634
  62. 1.10.2026 20:00 yeni plan plan 30311
  63. 1.10.2026 19:00 yeni plan plan 27563
  64. 1.10.2026 19:00 yeni plan plan 28257
  65. 1.10.2026 19:00 yeni plan plan 28925
  66. 30.09.2026 22:00 yeni plan plan 23129
  67. 30.09.2026 22:00 yeni plan plan 23748
  68. 30.09.2026 22:00 yeni plan plan 24285
  69. 30.09.2026 22:00 yeni plan plan 24928
  70. 30.09.2026 22:00 yeni plan plan 25522
  71. 30.09.2026 22:00 yeni plan plan 26202
  72. 30.09.2026 22:00 yeni plan plan 26858
  73. 30.09.2026 21:00 yeni plan plan 20486
  74. 30.09.2026 21:00 yeni plan plan 21163
  75. 30.09.2026 21:00 yeni plan plan 21809
  76. 30.09.2026 21:00 yeni plan plan 22437
  77. 30.09.2026 20:00 yeni plan plan 19777
  78. 30.09.2026 19:00 yeni plan plan 19087
  79. 30.09.2026 15:00 yeni plan plan 17114
  80. 30.09.2026 15:00 yeni plan plan 17785
  81. 30.09.2026 15:00 yeni plan plan 18397
  82. 30.09.2026 11:00 yeni plan plan 14635
  83. 30.09.2026 11:00 yeni plan plan 15271
  84. 30.09.2026 11:00 yeni plan plan 15925
  85. 30.09.2026 11:00 yeni plan plan 16471
  86. 30.09.2026 10:00 yeni plan plan 12925
  87. 30.09.2026 10:00 yeni plan plan 13451
  88. 30.09.2026 10:00 yeni plan plan 13992
  89. 30.09.2026 07:00 yeni plan plan 12318
  90. 30.09.2026 06:00 yeni plan plan 10690
  91. 30.09.2026 06:00 yeni plan plan 11216
  92. 30.09.2026 06:00 yeni plan plan 11738
  93. 30.09.2026 05:00 yeni plan plan 10099
  94. 30.09.2026 00:00 yeni plan plan 9066
  95. 29.09.2026 21:00 yeni plan plan 8161
  96. 29.09.2026 21:00 yeni plan plan 8599
  97. 29.09.2026 20:00 yeni plan plan 7681
  98. 28.09.2026 16:00 yeni plan plan 6100

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2860,90,9 1,085
2026-09-29131,01,0 1,483
2026-09-30431,01,0 1,283
2026-10-0161,41,4 3,184
2026-10-02111,01,0 1,384
2026-10-0451,01,0 1,182
2026-10-05261,01,0 1,483
2026-10-0661,01,0 1,083
2026-10-0760,90,9 1,081
2026-10-0940,90,9 1,084

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
7082610,80,879 8.10.2026 12:20 en iyi
3298810,80,879 2.10.2026 01:09
3508210,80,884 2.10.2026 17:24
6308810,80,891 5.10.2026 23:04
6221410,80,883 5.10.2026 22:56
7444510,80,883 8.10.2026 16:38
4102310,80,879 4.10.2026 22:07
6733010,80,879 7.10.2026 20:49
7171010,80,888 8.10.2026 12:37
2963410,80,879 1.10.2026 20:57
7717910,80,882 8.10.2026 19:59
3369810,80,885 2.10.2026 02:27
1069010,80,879 30.09.2026 06:32
3111210,80,883 1.10.2026 21:13
1173820,80,880 30.09.2026 06:59
6979210,80,879 7.10.2026 20:53
8258010,80,884 9.10.2026 19:25
3407820,80,884 2.10.2026 16:25
6809610,80,883 7.10.2026 20:50
6145210,90,979 5.10.2026 22:56
4991310,90,982 5.10.2026 12:32
4637010,90,980 5.10.2026 09:49
3581310,90,983 2.10.2026 17:32
3744710,90,979 4.10.2026 08:55
5806110,90,979 5.10.2026 21:02
859910,90,980 29.09.2026 21:50
1009910,90,982 30.09.2026 05:49
816110,90,979 29.09.2026 21:26
8157210,90,985 9.10.2026 17:45
7537410,90,979 8.10.2026 17:17
4359510,90,983 5.10.2026 09:00
1292510,90,984 30.09.2026 10:51
7964510,90,984 9.10.2026 14:27
2492810,90,983 30.09.2026 22:38
2116310,90,983 30.09.2026 21:32
6537210,90,980 7.10.2026 13:55
4440510,90,985 5.10.2026 09:09
8052210,90,979 9.10.2026 14:29
4902210,90,979 5.10.2026 10:42
5891410,90,980 5.10.2026 21:38
4186210,90,979 5.10.2026 00:27
1908710,90,983 30.09.2026 19:36
2892510,90,992 1.10.2026 19:31
1231810,90,984 30.09.2026 07:00
5464510,90,995 5.10.2026 17:49
4731810,90,983 5.10.2026 10:00
1345110,90,989 30.09.2026 10:52
6641210,90,984 7.10.2026 20:12
3031111,01,079 1.10.2026 20:58
6396561,01,083 6.10.2026 05:50
6100161,01,083 29.09.2026 18:42
1121611,01,083 30.09.2026 06:58
1399211,01,079 30.09.2026 10:56
1463511,01,089 30.09.2026 11:02
5630911,01,081 5.10.2026 18:28
7259311,01,082 8.10.2026 14:01
9066101,01,083 30.09.2026 05:42
4561911,01,086 5.10.2026 09:48
2620211,01,095 30.09.2026 22:53
1527121,01,085 30.09.2026 11:15
2552211,01,079 30.09.2026 22:40
2374821,01,079 30.09.2026 22:19
1592521,01,079 30.09.2026 11:20
1647111,01,080 30.09.2026 11:22
1711411,01,085 30.09.2026 15:32
1977711,01,080 30.09.2026 20:42
4002111,01,084 4.10.2026 13:45
1839711,01,080 30.09.2026 15:51
2428521,01,083 30.09.2026 22:38
5379311,01,079 5.10.2026 13:58
5716011,01,083 5.10.2026 20:19
2312911,01,086 30.09.2026 22:15
3655031,01,084 2.10.2026 18:17
3926511,01,086 4.10.2026 13:31
6893611,01,079 7.10.2026 20:51
5547411,01,084 5.10.2026 17:58
2685811,01,083 30.09.2026 22:56
3176311,01,086 2.10.2026 00:05
7627311,11,179 8.10.2026 18:57
4267111,11,183 5.10.2026 02:58
7868011,11,186 9.10.2026 13:15
5141711,11,190 5.10.2026 12:58
1778511,11,179 30.09.2026 15:42
5216211,21,182 5.10.2026 12:59
3850911,21,280 4.10.2026 13:28
2825711,21,279 1.10.2026 19:19
4810111,21,279 5.10.2026 10:03
2243711,21,283 30.09.2026 21:37
7357711,21,280 8.10.2026 16:34
5296411,21,281 5.10.2026 13:19
2180911,31,380 30.09.2026 21:34
6057811,31,379 5.10.2026 22:03
3235011,41,484 2.10.2026 00:06
768111,41,491 29.09.2026 20:13
5060611,41,492 5.10.2026 12:33
2048611,51,583 30.09.2026 21:24
5975111,81,879 5.10.2026 21:41
2756313,73,795 1.10.2026 19:13 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.