Pahalı sorgular0x670E5176BAC25D4D
Demo modu

Sorgu 0x670E5176BAC25D4D

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 0,1 ms
Ort. CPU 0,1 ms
Bekleme payı %0,3
Ort. mantıksal okuma 8
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,1 ms29.09.2026: 13 çalışma, ort. 0,1 ms30.09.2026: 43 çalışma, ort. 0,1 ms1.10.2026: 6 çalışma, ort. 0,1 ms2.10.2026: 10 çalışma, ort. 0,1 ms4.10.2026: 5 çalışma, ort. 0,1 ms5.10.2026: 26 çalışma, ort. 0,1 ms6.10.2026: 6 çalışma, ort. 0,1 ms7.10.2026: 6 çalışma, ort. 0,1 ms9.10.2026: 4 çalışma, ort. 0,1 ms max 43 çalışma max ort. süre 0,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 82588
  2. 9.10.2026 17:00 yeni plan plan 81592
  3. 9.10.2026 14:00 yeni plan plan 79630
  4. 9.10.2026 14:00 yeni plan plan 80517
  5. 9.10.2026 13:00 yeni plan plan 78671
  6. 8.10.2026 19:00 yeni plan plan 77186
  7. 8.10.2026 18:00 yeni plan plan 76280
  8. 8.10.2026 17:00 yeni plan plan 75354
  9. 8.10.2026 16:00 yeni plan plan 73602
  10. 8.10.2026 16:00 yeni plan plan 74470
  11. 8.10.2026 14:00 yeni plan plan 72613
  12. 8.10.2026 12:00 yeni plan plan 70795
  13. 8.10.2026 12:00 yeni plan plan 71688
  14. 7.10.2026 20:00 yeni plan plan 66407
  15. 7.10.2026 20:00 yeni plan plan 67315
  16. 7.10.2026 20:00 yeni plan plan 68110
  17. 7.10.2026 20:00 yeni plan plan 68913
  18. 7.10.2026 20:00 yeni plan plan 69782
  19. 7.10.2026 13:00 yeni plan plan 65344
  20. 6.10.2026 00:00 yeni plan plan 63982
  21. 5.10.2026 23:00 yeni plan plan 63076
  22. 5.10.2026 22:00 yeni plan plan 60567
  23. 5.10.2026 22:00 yeni plan plan 61461
  24. 5.10.2026 22:00 yeni plan plan 62197
  25. 5.10.2026 21:00 yeni plan plan 58056
  26. 5.10.2026 21:00 yeni plan plan 58903
  27. 5.10.2026 21:00 yeni plan plan 59763
  28. 5.10.2026 20:00 yeni plan plan 57168
  29. 5.10.2026 18:00 yeni plan plan 56335
  30. 5.10.2026 17:00 yeni plan plan 54650
  31. 5.10.2026 17:00 yeni plan plan 55456
  32. 5.10.2026 13:00 yeni plan plan 52972
  33. 5.10.2026 13:00 yeni plan plan 53788
  34. 5.10.2026 12:00 yeni plan plan 49888
  35. 5.10.2026 12:00 yeni plan plan 50624
  36. 5.10.2026 12:00 yeni plan plan 51451
  37. 5.10.2026 12:00 yeni plan plan 52157
  38. 5.10.2026 10:00 yeni plan plan 47326
  39. 5.10.2026 10:00 yeni plan plan 48108
  40. 5.10.2026 10:00 yeni plan plan 48988
  41. 5.10.2026 09:00 yeni plan plan 43587
  42. 5.10.2026 09:00 yeni plan plan 44380
  43. 5.10.2026 09:00 yeni plan plan 45605
  44. 5.10.2026 09:00 yeni plan plan 46377
  45. 5.10.2026 02:00 yeni plan plan 42635
  46. 5.10.2026 00:00 yeni plan plan 41828
  47. 4.10.2026 22:00 yeni plan plan 41016
  48. 4.10.2026 13:00 yeni plan plan 38519
  49. 4.10.2026 13:00 yeni plan plan 39273
  50. 4.10.2026 13:00 yeni plan plan 40014
  51. 4.10.2026 08:00 yeni plan plan 37456
  52. 2.10.2026 17:00 yeni plan plan 35097
  53. 2.10.2026 17:00 yeni plan plan 35849
  54. 2.10.2026 17:00 yeni plan plan 36557
  55. 2.10.2026 16:00 yeni plan plan 34650
  56. 2.10.2026 02:00 yeni plan plan 33693
  57. 2.10.2026 01:00 yeni plan plan 32998
  58. 2.10.2026 00:00 yeni plan plan 31771
  59. 2.10.2026 00:00 yeni plan plan 32345
  60. 1.10.2026 21:00 yeni plan plan 31101
  61. 1.10.2026 20:00 yeni plan plan 29639
  62. 1.10.2026 20:00 yeni plan plan 30289
  63. 1.10.2026 19:00 yeni plan plan 27550
  64. 1.10.2026 19:00 yeni plan plan 28221
  65. 1.10.2026 19:00 yeni plan plan 28931
  66. 30.09.2026 22:00 yeni plan plan 23109
  67. 30.09.2026 22:00 yeni plan plan 23767
  68. 30.09.2026 22:00 yeni plan plan 24301
  69. 30.09.2026 22:00 yeni plan plan 24915
  70. 30.09.2026 22:00 yeni plan plan 25529
  71. 30.09.2026 22:00 yeni plan plan 26238
  72. 30.09.2026 22:00 yeni plan plan 26879
  73. 30.09.2026 21:00 yeni plan plan 20465
  74. 30.09.2026 21:00 yeni plan plan 21168
  75. 30.09.2026 21:00 yeni plan plan 21798
  76. 30.09.2026 21:00 yeni plan plan 22459
  77. 30.09.2026 20:00 yeni plan plan 19770
  78. 30.09.2026 19:00 yeni plan plan 19056
  79. 30.09.2026 15:00 yeni plan plan 17119
  80. 30.09.2026 15:00 yeni plan plan 17776
  81. 30.09.2026 15:00 yeni plan plan 18417
  82. 30.09.2026 11:00 yeni plan plan 14615
  83. 30.09.2026 11:00 yeni plan plan 15252
  84. 30.09.2026 11:00 yeni plan plan 15937
  85. 30.09.2026 11:00 yeni plan plan 16494
  86. 30.09.2026 10:00 yeni plan plan 12934
  87. 30.09.2026 10:00 yeni plan plan 13424
  88. 30.09.2026 10:00 yeni plan plan 14001
  89. 30.09.2026 07:00 yeni plan plan 12313
  90. 30.09.2026 06:00 yeni plan plan 10647
  91. 30.09.2026 06:00 yeni plan plan 11248
  92. 30.09.2026 06:00 yeni plan plan 11722
  93. 30.09.2026 05:00 yeni plan plan 10089
  94. 30.09.2026 00:00 yeni plan plan 9072
  95. 29.09.2026 21:00 yeni plan plan 8184
  96. 29.09.2026 21:00 yeni plan plan 8622
  97. 29.09.2026 20:00 yeni plan plan 7718
  98. 28.09.2026 16:00 yeni plan plan 6122

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2860,10,1 0,18
2026-09-29130,10,1 0,18
2026-09-30430,10,1 0,18
2026-10-0160,10,1 0,18
2026-10-02100,10,1 0,18
2026-10-0450,10,1 0,18
2026-10-05260,10,1 0,19
2026-10-0660,10,1 0,18
2026-10-0760,10,1 0,18
2026-10-0940,10,1 0,18

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
7628010,10,18 8.10.2026 18:57 en iyi
818410,10,18 29.09.2026 21:26
4988810,10,18 5.10.2026 12:32
4182810,10,18 5.10.2026 00:27
2245910,10,18 30.09.2026 21:37
1008910,10,18 30.09.2026 05:49
8051710,10,18 9.10.2026 14:29
4637710,10,19 5.10.2026 09:49
4358710,10,18 5.10.2026 09:00
1064710,10,18 30.09.2026 06:32
6056710,10,19 5.10.2026 22:03
2963910,10,19 1.10.2026 20:57
6978210,10,19 7.10.2026 20:53
5633510,10,19 5.10.2026 18:28
2623810,10,18 30.09.2026 22:53
6891310,10,18 7.10.2026 20:51
1124810,10,18 30.09.2026 06:58
1293410,10,18 30.09.2026 10:51
771810,10,18 29.09.2026 20:13
5545610,10,19 5.10.2026 17:58
1977010,10,18 30.09.2026 20:42
5805610,10,19 5.10.2026 21:02
6398260,10,18 6.10.2026 05:50
7168810,10,18 8.10.2026 12:37
5062410,10,18 5.10.2026 12:33
6640710,10,19 7.10.2026 20:12
3369310,10,18 2.10.2026 02:27
2687910,10,18 30.09.2026 22:56
6811010,10,18 7.10.2026 20:50
2822110,10,19 1.10.2026 19:18
7360210,10,19 8.10.2026 16:34
3465010,10,18 2.10.2026 16:25
1905610,10,18 30.09.2026 19:36
5297210,10,19 5.10.2026 13:19
4101610,10,18 4.10.2026 22:07
4732610,10,18 5.10.2026 10:00
7535410,10,19 8.10.2026 17:17
2310910,10,18 30.09.2026 22:15
3509710,10,18 2.10.2026 17:24
4898810,10,19 5.10.2026 10:42
6731510,10,19 7.10.2026 20:49
2491510,10,18 30.09.2026 22:38
1342410,10,18 30.09.2026 10:52
3028910,10,19 1.10.2026 20:58
5716810,10,18 5.10.2026 20:19
1841710,10,18 30.09.2026 15:51
3851910,10,18 4.10.2026 13:28
1649410,10,18 30.09.2026 11:22
2755010,10,18 1.10.2026 19:13
2893110,10,18 1.10.2026 19:31
1461510,10,18 30.09.2026 11:02
2179810,10,18 30.09.2026 21:34
7079510,10,18 8.10.2026 12:20
7718610,10,19 8.10.2026 19:59
1231310,10,18 30.09.2026 07:00
7867110,10,18 9.10.2026 13:15
5976310,10,18 5.10.2026 21:41
7261310,10,19 8.10.2026 14:01
4438010,10,19 5.10.2026 09:09
4001410,10,18 4.10.2026 13:45
3299810,10,19 2.10.2026 01:09
4263510,10,19 5.10.2026 02:58
6146110,10,19 5.10.2026 22:56
6534410,10,18 7.10.2026 13:55
5890310,10,19 5.10.2026 21:38
7963010,10,18 9.10.2026 14:27
8258810,10,18 9.10.2026 19:25
3745610,10,18 4.10.2026 08:55
1711910,10,18 30.09.2026 15:32
1400110,10,18 30.09.2026 10:56
9072100,10,18 30.09.2026 05:42
3655730,10,18 2.10.2026 18:17
2046510,10,18 30.09.2026 21:24
4810810,10,19 5.10.2026 10:03
1525220,10,18 30.09.2026 11:15
6122160,10,18 29.09.2026 18:42
3110110,10,18 1.10.2026 21:13
7447010,10,18 8.10.2026 16:38
4560510,10,18 5.10.2026 09:47
1777610,10,18 30.09.2026 15:42
3927310,10,18 4.10.2026 13:31
3584910,10,18 2.10.2026 17:32
2376720,10,18 30.09.2026 22:19
2116810,10,18 30.09.2026 21:32
2430120,10,18 30.09.2026 22:38
6219710,10,19 5.10.2026 22:56
6307610,10,18 5.10.2026 23:04
1172220,10,18 30.09.2026 06:59
5215710,10,18 5.10.2026 12:59
3177110,10,19 2.10.2026 00:05
5378810,10,18 5.10.2026 13:58
2552910,10,18 30.09.2026 22:40
5465010,10,19 5.10.2026 17:49
1593720,10,18 30.09.2026 11:20
862210,10,18 29.09.2026 21:50
8159210,10,18 9.10.2026 17:45
3234510,10,18 2.10.2026 00:06
5145110,10,19 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 
INSERT #expected VALUES (1, 11, 12, '2026-01-06', '2026-01-06 01:00', 'Regressed', 4, 'Switch', 'New')

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.