Pahalı sorgular0x203D608DD1A0C200
Demo modu

Sorgu 0x203D608DD1A0C200

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 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: 11 ç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 82581
  2. 9.10.2026 17:00 yeni plan plan 81573
  3. 9.10.2026 14:00 yeni plan plan 79646
  4. 9.10.2026 14:00 yeni plan plan 80523
  5. 9.10.2026 13:00 yeni plan plan 78681
  6. 8.10.2026 19:00 yeni plan plan 77180
  7. 8.10.2026 18:00 yeni plan plan 76274
  8. 8.10.2026 17:00 yeni plan plan 75375
  9. 8.10.2026 16:00 yeni plan plan 73578
  10. 8.10.2026 16:00 yeni plan plan 74446
  11. 8.10.2026 14:00 yeni plan plan 72594
  12. 8.10.2026 12:00 yeni plan plan 70827
  13. 8.10.2026 12:00 yeni plan plan 71711
  14. 7.10.2026 20:00 yeni plan plan 66413
  15. 7.10.2026 20:00 yeni plan plan 67331
  16. 7.10.2026 20:00 yeni plan plan 68097
  17. 7.10.2026 20:00 yeni plan plan 68937
  18. 7.10.2026 20:00 yeni plan plan 69793
  19. 7.10.2026 13:00 yeni plan plan 65373
  20. 6.10.2026 00:00 yeni plan plan 63966
  21. 5.10.2026 23:00 yeni plan plan 63089
  22. 5.10.2026 22:00 yeni plan plan 60579
  23. 5.10.2026 22:00 yeni plan plan 61453
  24. 5.10.2026 22:00 yeni plan plan 62215
  25. 5.10.2026 21:00 yeni plan plan 58062
  26. 5.10.2026 21:00 yeni plan plan 58915
  27. 5.10.2026 21:00 yeni plan plan 59752
  28. 5.10.2026 20:00 yeni plan plan 57161
  29. 5.10.2026 18:00 yeni plan plan 56310
  30. 5.10.2026 17:00 yeni plan plan 54646
  31. 5.10.2026 17:00 yeni plan plan 55475
  32. 5.10.2026 13:00 yeni plan plan 52965
  33. 5.10.2026 13:00 yeni plan plan 53794
  34. 5.10.2026 12:00 yeni plan plan 49914
  35. 5.10.2026 12:00 yeni plan plan 50607
  36. 5.10.2026 12:00 yeni plan plan 51418
  37. 5.10.2026 12:00 yeni plan plan 52163
  38. 5.10.2026 10:00 yeni plan plan 47319
  39. 5.10.2026 10:00 yeni plan plan 48102
  40. 5.10.2026 10:00 yeni plan plan 49023
  41. 5.10.2026 09:00 yeni plan plan 43596
  42. 5.10.2026 09:00 yeni plan plan 44406
  43. 5.10.2026 09:00 yeni plan plan 45620
  44. 5.10.2026 09:00 yeni plan plan 46371
  45. 5.10.2026 02:00 yeni plan plan 42672
  46. 5.10.2026 00:00 yeni plan plan 41863
  47. 4.10.2026 22:00 yeni plan plan 41024
  48. 4.10.2026 13:00 yeni plan plan 38510
  49. 4.10.2026 13:00 yeni plan plan 39266
  50. 4.10.2026 13:00 yeni plan plan 40022
  51. 4.10.2026 08:00 yeni plan plan 37448
  52. 2.10.2026 17:00 yeni plan plan 35083
  53. 2.10.2026 17:00 yeni plan plan 35814
  54. 2.10.2026 17:00 yeni plan plan 36551
  55. 2.10.2026 16:00 yeni plan plan 34079
  56. 2.10.2026 02:00 yeni plan plan 33699
  57. 2.10.2026 01:00 yeni plan plan 32989
  58. 2.10.2026 00:00 yeni plan plan 31764
  59. 2.10.2026 00:00 yeni plan plan 32351
  60. 1.10.2026 21:00 yeni plan plan 31113
  61. 1.10.2026 20:00 yeni plan plan 29635
  62. 1.10.2026 20:00 yeni plan plan 30312
  63. 1.10.2026 19:00 yeni plan plan 27564
  64. 1.10.2026 19:00 yeni plan plan 28258
  65. 1.10.2026 19:00 yeni plan plan 28926
  66. 30.09.2026 22:00 yeni plan plan 23130
  67. 30.09.2026 22:00 yeni plan plan 23749
  68. 30.09.2026 22:00 yeni plan plan 24286
  69. 30.09.2026 22:00 yeni plan plan 24929
  70. 30.09.2026 22:00 yeni plan plan 25523
  71. 30.09.2026 22:00 yeni plan plan 26203
  72. 30.09.2026 22:00 yeni plan plan 26859
  73. 30.09.2026 21:00 yeni plan plan 20487
  74. 30.09.2026 21:00 yeni plan plan 21164
  75. 30.09.2026 21:00 yeni plan plan 21810
  76. 30.09.2026 21:00 yeni plan plan 22438
  77. 30.09.2026 20:00 yeni plan plan 19778
  78. 30.09.2026 19:00 yeni plan plan 19088
  79. 30.09.2026 15:00 yeni plan plan 17115
  80. 30.09.2026 15:00 yeni plan plan 17786
  81. 30.09.2026 15:00 yeni plan plan 18398
  82. 30.09.2026 11:00 yeni plan plan 14636
  83. 30.09.2026 11:00 yeni plan plan 15272
  84. 30.09.2026 11:00 yeni plan plan 15926
  85. 30.09.2026 11:00 yeni plan plan 16472
  86. 30.09.2026 10:00 yeni plan plan 12926
  87. 30.09.2026 10:00 yeni plan plan 13452
  88. 30.09.2026 10:00 yeni plan plan 13993
  89. 30.09.2026 07:00 yeni plan plan 12319
  90. 30.09.2026 06:00 yeni plan plan 10691
  91. 30.09.2026 06:00 yeni plan plan 11217
  92. 30.09.2026 06:00 yeni plan plan 11739
  93. 30.09.2026 05:00 yeni plan plan 10100
  94. 30.09.2026 00:00 yeni plan plan 9067
  95. 29.09.2026 21:00 yeni plan plan 8162
  96. 29.09.2026 21:00 yeni plan plan 8600
  97. 29.09.2026 20:00 yeni plan plan 7682
  98. 28.09.2026 16:00 yeni plan plan 6101

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,18
2026-09-30430,10,1 0,28
2026-10-0160,10,1 0,19
2026-10-02110,10,1 0,18
2026-10-0450,10,1 0,38
2026-10-05260,10,1 0,18
2026-10-0660,10,1 0,18
2026-10-0760,10,1 0,18
2026-10-0940,10,1 0,28

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
6308910,10,19 5.10.2026 23:04 en iyi
5806210,10,19 5.10.2026 21:02
1345210,10,18 30.09.2026 10:52
2428620,10,18 30.09.2026 22:38
6221510,10,18 5.10.2026 22:56
7082710,10,19 8.10.2026 12:20
6145310,10,18 5.10.2026 22:56
4991410,10,18 5.10.2026 12:32
4902310,10,19 5.10.2026 10:42
860010,10,18 29.09.2026 21:50
7964610,10,18 9.10.2026 14:27
1173920,10,18 30.09.2026 06:59
1463610,10,18 30.09.2026 11:02
1908810,10,18 30.09.2026 19:36
1592620,10,18 30.09.2026 11:20
8157310,10,19 9.10.2026 17:45
3031210,10,18 1.10.2026 20:58
1010010,10,18 30.09.2026 05:49
5547510,10,18 5.10.2026 17:58
4810210,10,19 5.10.2026 10:03
3111310,10,19 1.10.2026 21:13
2963510,10,19 1.10.2026 20:57
6101160,10,18 29.09.2026 18:42
768210,10,18 29.09.2026 20:13
7171110,10,18 8.10.2026 12:37
1711510,10,18 30.09.2026 15:32
4102410,10,18 4.10.2026 22:07
3407920,10,18 2.10.2026 16:25
3369910,10,18 2.10.2026 02:27
2374920,10,18 30.09.2026 22:19
2552310,10,18 30.09.2026 22:40
1399310,10,18 30.09.2026 10:56
1977810,10,18 30.09.2026 20:42
1527220,10,18 30.09.2026 11:15
3655130,10,18 2.10.2026 18:17
1121710,10,18 30.09.2026 06:58
2116410,10,18 30.09.2026 21:32
6733110,10,18 7.10.2026 20:49
4267210,10,18 5.10.2026 02:58
4440610,10,18 5.10.2026 09:09
4731910,10,18 5.10.2026 10:00
1839810,10,18 30.09.2026 15:51
2620310,10,18 30.09.2026 22:53
8052310,10,18 9.10.2026 14:29
1292610,10,18 30.09.2026 10:51
5891510,10,19 5.10.2026 21:38
2892610,10,18 1.10.2026 19:31
2492910,10,18 30.09.2026 22:38
7537510,10,18 8.10.2026 17:17
3581410,10,18 2.10.2026 17:32
2313010,10,18 30.09.2026 22:15
6979310,10,18 7.10.2026 20:53
6809710,10,18 7.10.2026 20:50
1231910,10,18 30.09.2026 07:00
5631010,10,19 5.10.2026 18:28
3508310,10,18 2.10.2026 17:24
5716110,10,18 5.10.2026 20:19
5464610,10,18 5.10.2026 17:49
8258110,10,19 9.10.2026 19:25
7627410,10,19 8.10.2026 18:57
6893710,10,19 7.10.2026 20:51
4002210,10,18 4.10.2026 13:45
6057910,10,18 5.10.2026 22:03
4359610,10,19 5.10.2026 09:00
5975210,10,18 5.10.2026 21:41
1778610,10,18 30.09.2026 15:42
1069110,10,18 30.09.2026 06:32
5141810,10,18 5.10.2026 12:58
3176410,10,18 2.10.2026 00:05
6537310,10,18 7.10.2026 13:55
3926610,10,19 4.10.2026 13:31
7259410,10,19 8.10.2026 14:01
4562010,10,18 5.10.2026 09:48
6641310,10,19 7.10.2026 20:12
7444610,10,19 8.10.2026 16:38
6396660,10,18 6.10.2026 05:50
2243810,10,18 30.09.2026 21:37
2181010,10,18 30.09.2026 21:34
7718010,10,19 8.10.2026 19:59
3298910,10,19 2.10.2026 01:09
2685910,10,18 30.09.2026 22:56
5216310,10,19 5.10.2026 12:59
5379410,10,18 5.10.2026 13:58
4637110,10,18 5.10.2026 09:49
3851010,10,19 4.10.2026 13:28
3235110,10,19 2.10.2026 00:06
5060710,10,19 5.10.2026 12:33
5296510,10,18 5.10.2026 13:19
2756410,10,19 1.10.2026 19:13
7357810,10,18 8.10.2026 16:34
816210,10,18 29.09.2026 21:26
2825810,10,19 1.10.2026 19:19
4186310,10,19 5.10.2026 00:27
2048710,10,18 30.09.2026 21:24
9067100,20,28 30.09.2026 05:42
7868110,20,28 9.10.2026 13:15
3744810,30,38 4.10.2026 08:55
1647210,70,78 30.09.2026 11:22 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 ('IndexCreated', '2026-01-04 03:00', '2026-01-05 07:00', 1)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.