Pahalı sorgular0x6B0D1B3378000CEB
Demo modu

Sorgu 0x6B0D1B3378000CEB

SQL-1 · DB-11· test_PlanChange.test etki ozeti iptal ve hatayi ayri sayar birimleri cevirir · 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 9
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 82549
  2. 9.10.2026 17:00 yeni plan plan 81557
  3. 9.10.2026 14:00 yeni plan plan 79625
  4. 9.10.2026 14:00 yeni plan plan 80527
  5. 9.10.2026 13:00 yeni plan plan 78666
  6. 8.10.2026 19:00 yeni plan plan 77217
  7. 8.10.2026 18:00 yeni plan plan 76300
  8. 8.10.2026 17:00 yeni plan plan 75339
  9. 8.10.2026 16:00 yeni plan plan 73582
  10. 8.10.2026 16:00 yeni plan plan 74474
  11. 8.10.2026 14:00 yeni plan plan 72586
  12. 8.10.2026 12:00 yeni plan plan 70790
  13. 8.10.2026 12:00 yeni plan plan 71681
  14. 7.10.2026 20:00 yeni plan plan 66403
  15. 7.10.2026 20:00 yeni plan plan 67324
  16. 7.10.2026 20:00 yeni plan plan 68115
  17. 7.10.2026 20:00 yeni plan plan 68950
  18. 7.10.2026 20:00 yeni plan plan 69797
  19. 7.10.2026 13:00 yeni plan plan 65365
  20. 6.10.2026 00:00 yeni plan plan 63986
  21. 5.10.2026 23:00 yeni plan plan 63082
  22. 5.10.2026 22:00 yeni plan plan 60571
  23. 5.10.2026 22:00 yeni plan plan 61446
  24. 5.10.2026 22:00 yeni plan plan 62193
  25. 5.10.2026 21:00 yeni plan plan 58044
  26. 5.10.2026 21:00 yeni plan plan 58908
  27. 5.10.2026 21:00 yeni plan plan 59745
  28. 5.10.2026 20:00 yeni plan plan 57155
  29. 5.10.2026 18:00 yeni plan plan 56304
  30. 5.10.2026 17:00 yeni plan plan 54669
  31. 5.10.2026 17:00 yeni plan plan 55451
  32. 5.10.2026 13:00 yeni plan plan 52976
  33. 5.10.2026 13:00 yeni plan plan 53763
  34. 5.10.2026 12:00 yeni plan plan 49883
  35. 5.10.2026 12:00 yeni plan plan 50617
  36. 5.10.2026 12:00 yeni plan plan 51422
  37. 5.10.2026 12:00 yeni plan plan 52167
  38. 5.10.2026 10:00 yeni plan plan 47312
  39. 5.10.2026 10:00 yeni plan plan 48136
  40. 5.10.2026 10:00 yeni plan plan 48993
  41. 5.10.2026 09:00 yeni plan plan 43600
  42. 5.10.2026 09:00 yeni plan plan 44375
  43. 5.10.2026 09:00 yeni plan plan 45624
  44. 5.10.2026 09:00 yeni plan plan 46381
  45. 5.10.2026 02:00 yeni plan plan 42640
  46. 5.10.2026 00:00 yeni plan plan 41867
  47. 4.10.2026 22:00 yeni plan plan 40988
  48. 4.10.2026 13:00 yeni plan plan 38530
  49. 4.10.2026 13:00 yeni plan plan 39292
  50. 4.10.2026 13:00 yeni plan plan 40049
  51. 4.10.2026 08:00 yeni plan plan 37485
  52. 2.10.2026 17:00 yeni plan plan 35093
  53. 2.10.2026 17:00 yeni plan plan 35845
  54. 2.10.2026 17:00 yeni plan plan 36561
  55. 2.10.2026 16:00 yeni plan plan 34646
  56. 2.10.2026 02:00 yeni plan plan 33703
  57. 2.10.2026 01:00 yeni plan plan 33002
  58. 2.10.2026 00:00 yeni plan plan 31775
  59. 2.10.2026 00:00 yeni plan plan 32341
  60. 1.10.2026 21:00 yeni plan plan 31106
  61. 1.10.2026 20:00 yeni plan plan 29625
  62. 1.10.2026 20:00 yeni plan plan 30296
  63. 1.10.2026 19:00 yeni plan plan 27557
  64. 1.10.2026 19:00 yeni plan plan 28252
  65. 1.10.2026 19:00 yeni plan plan 28905
  66. 30.09.2026 22:00 yeni plan plan 23134
  67. 30.09.2026 22:00 yeni plan plan 23771
  68. 30.09.2026 22:00 yeni plan plan 24279
  69. 30.09.2026 22:00 yeni plan plan 24923
  70. 30.09.2026 22:00 yeni plan plan 25560
  71. 30.09.2026 22:00 yeni plan plan 26230
  72. 30.09.2026 22:00 yeni plan plan 26849
  73. 30.09.2026 21:00 yeni plan plan 20470
  74. 30.09.2026 21:00 yeni plan plan 21172
  75. 30.09.2026 21:00 yeni plan plan 21802
  76. 30.09.2026 21:00 yeni plan plan 22464
  77. 30.09.2026 20:00 yeni plan plan 19807
  78. 30.09.2026 19:00 yeni plan plan 19049
  79. 30.09.2026 15:00 yeni plan plan 17123
  80. 30.09.2026 15:00 yeni plan plan 17780
  81. 30.09.2026 15:00 yeni plan plan 18392
  82. 30.09.2026 11:00 yeni plan plan 14599
  83. 30.09.2026 11:00 yeni plan plan 15264
  84. 30.09.2026 11:00 yeni plan plan 15941
  85. 30.09.2026 11:00 yeni plan plan 16466
  86. 30.09.2026 10:00 yeni plan plan 12910
  87. 30.09.2026 10:00 yeni plan plan 13446
  88. 30.09.2026 10:00 yeni plan plan 14015
  89. 30.09.2026 07:00 yeni plan plan 12338
  90. 30.09.2026 06:00 yeni plan plan 10695
  91. 30.09.2026 06:00 yeni plan plan 11210
  92. 30.09.2026 06:00 yeni plan plan 11726
  93. 30.09.2026 05:00 yeni plan plan 10093
  94. 30.09.2026 00:00 yeni plan plan 9060
  95. 29.09.2026 21:00 yeni plan plan 8172
  96. 29.09.2026 21:00 yeni plan plan 8593
  97. 29.09.2026 20:00 yeni plan plan 7711
  98. 28.09.2026 16:00 yeni plan plan 6095

Günler

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

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
1009310,10,19 30.09.2026 05:49 en iyi
7533910,10,110 8.10.2026 17:17
1401510,10,19 30.09.2026 10:56
4098810,10,19 4.10.2026 22:07
6536510,10,19 7.10.2026 13:55
5376310,10,19 5.10.2026 13:58
6811510,10,110 7.10.2026 20:50
4899310,10,110 5.10.2026 10:42
8052710,10,19 9.10.2026 14:29
7962510,10,19 9.10.2026 14:27
5545110,10,110 5.10.2026 17:58
4360010,10,110 5.10.2026 09:01
2117210,10,19 30.09.2026 21:32
6640310,10,19 7.10.2026 20:12
2890510,10,110 1.10.2026 19:31
7721710,10,110 8.10.2026 19:59
6979710,10,19 7.10.2026 20:53
1526420,10,19 30.09.2026 11:15
817210,10,19 29.09.2026 21:26
1594120,10,19 30.09.2026 11:20
5715510,10,19 5.10.2026 20:19
1069510,10,19 30.09.2026 06:32
3370310,10,110 2.10.2026 02:27
3300210,10,19 2.10.2026 01:09
6095160,10,19 29.09.2026 18:42
7079010,10,19 8.10.2026 12:19
5974510,10,19 5.10.2026 21:41
6308210,10,110 5.10.2026 23:04
2556010,10,19 30.09.2026 22:40
1459910,10,19 30.09.2026 11:02
4731210,10,110 5.10.2026 10:00
7358210,10,19 8.10.2026 16:34
2427920,10,19 30.09.2026 22:38
2684910,10,19 30.09.2026 22:56
1121010,10,19 30.09.2026 06:58
5297610,10,110 5.10.2026 13:19
6057110,10,19 5.10.2026 22:03
2962510,10,110 1.10.2026 20:57
6895010,10,110 7.10.2026 20:51
1980710,10,19 30.09.2026 20:42
2623010,10,19 30.09.2026 22:53
5630410,10,110 5.10.2026 18:28
771110,10,19 29.09.2026 20:13
4004910,10,110 4.10.2026 13:45
9060100,10,19 30.09.2026 05:42
859310,10,19 29.09.2026 21:50
7866610,10,19 9.10.2026 13:15
2313410,10,19 30.09.2026 22:15
1344610,10,19 30.09.2026 10:52
7447410,10,19 8.10.2026 16:38
1233810,10,19 30.09.2026 07:00
5804410,10,19 5.10.2026 21:02
3656130,10,19 2.10.2026 18:17
6398660,10,110 6.10.2026 05:50
7258610,10,19 8.10.2026 14:01
5466910,10,110 5.10.2026 17:49
1172620,10,19 30.09.2026 06:59
4988310,10,110 5.10.2026 12:32
1778010,10,19 30.09.2026 15:42
2492310,10,19 30.09.2026 22:38
6144610,10,19 5.10.2026 22:55
4437510,10,110 5.10.2026 09:09
4638110,10,110 5.10.2026 09:49
1904910,10,19 30.09.2026 19:36
6732410,10,110 7.10.2026 20:49
2047010,10,19 30.09.2026 21:24
2825210,10,19 1.10.2026 19:19
1291010,10,19 30.09.2026 10:51
8155710,10,110 9.10.2026 17:45
1646610,10,19 30.09.2026 11:22
8254910,10,19 9.10.2026 19:25
3029610,10,19 1.10.2026 20:58
3748510,10,19 4.10.2026 08:55
5142210,10,110 5.10.2026 12:58
3509310,10,19 2.10.2026 17:24
1839210,10,19 30.09.2026 15:51
3110610,10,19 1.10.2026 21:13
3929210,10,110 4.10.2026 13:31
2180210,10,19 30.09.2026 21:34
2377120,10,19 30.09.2026 22:19
3234110,10,110 2.10.2026 00:06
7630010,10,110 8.10.2026 18:57
4562410,10,19 5.10.2026 09:48
2246410,10,19 30.09.2026 21:37
3853010,10,110 4.10.2026 13:29
1712310,10,19 30.09.2026 15:32
3177510,10,19 2.10.2026 00:05
5216710,10,19 5.10.2026 12:59
5061710,10,110 5.10.2026 12:33
6219310,10,19 5.10.2026 22:56
3584510,10,19 2.10.2026 17:32
4186710,10,110 5.10.2026 00:27
3464610,20,29 2.10.2026 16:25
4813610,20,29 5.10.2026 10:03
7168110,20,210 8.10.2026 12:37
2755710,20,29 1.10.2026 19:13
4264010,30,310 5.10.2026 02:58
5890810,30,310 5.10.2026 21:38 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 ('New', 240, 6, 0, 40, 80, 20, 100, 10, '2026-01-06'), ('Old', 240, 0, 0, 10, 20, 5, 100, 10, '2026-01-05')

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.