Pahalı sorgular0x169F9B64CB371F3A
Demo modu

Sorgu 0x169F9B64CB371F3A

SQL-1 · DB-11· test_PlanChange.test yeni index olayi kesin zamanli ve plan kullanimi isaretli ilk toplama index i olay degil · 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,3 ms max 43 çalışma max ort. süre 0,3 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 82558
  2. 9.10.2026 17:00 yeni plan plan 81565
  3. 9.10.2026 14:00 yeni plan plan 79638
  4. 9.10.2026 14:00 yeni plan plan 80511
  5. 9.10.2026 13:00 yeni plan plan 78688
  6. 8.10.2026 19:00 yeni plan plan 77208
  7. 8.10.2026 18:00 yeni plan plan 76309
  8. 8.10.2026 17:00 yeni plan plan 75347
  9. 8.10.2026 16:00 yeni plan plan 73570
  10. 8.10.2026 16:00 yeni plan plan 74438
  11. 8.10.2026 14:00 yeni plan plan 72622
  12. 8.10.2026 12:00 yeni plan plan 70805
  13. 8.10.2026 12:00 yeni plan plan 71677
  14. 7.10.2026 20:00 yeni plan plan 66377
  15. 7.10.2026 20:00 yeni plan plan 67354
  16. 7.10.2026 20:00 yeni plan plan 68104
  17. 7.10.2026 20:00 yeni plan plan 68946
  18. 7.10.2026 20:00 yeni plan plan 69804
  19. 7.10.2026 13:00 yeni plan plan 65339
  20. 6.10.2026 00:00 yeni plan plan 63973
  21. 5.10.2026 23:00 yeni plan plan 63096
  22. 5.10.2026 22:00 yeni plan plan 60561
  23. 5.10.2026 22:00 yeni plan plan 61485
  24. 5.10.2026 22:00 yeni plan plan 62207
  25. 5.10.2026 21:00 yeni plan plan 58052
  26. 5.10.2026 21:00 yeni plan plan 58937
  27. 5.10.2026 21:00 yeni plan plan 59759
  28. 5.10.2026 20:00 yeni plan plan 57151
  29. 5.10.2026 18:00 yeni plan plan 56299
  30. 5.10.2026 17:00 yeni plan plan 54639
  31. 5.10.2026 17:00 yeni plan plan 55466
  32. 5.10.2026 13:00 yeni plan plan 52957
  33. 5.10.2026 13:00 yeni plan plan 53758
  34. 5.10.2026 12:00 yeni plan plan 49878
  35. 5.10.2026 12:00 yeni plan plan 50633
  36. 5.10.2026 12:00 yeni plan plan 51432
  37. 5.10.2026 12:00 yeni plan plan 52145
  38. 5.10.2026 10:00 yeni plan plan 47335
  39. 5.10.2026 10:00 yeni plan plan 48130
  40. 5.10.2026 10:00 yeni plan plan 49001
  41. 5.10.2026 09:00 yeni plan plan 43621
  42. 5.10.2026 09:00 yeni plan plan 44370
  43. 5.10.2026 09:00 yeni plan plan 45614
  44. 5.10.2026 09:00 yeni plan plan 46357
  45. 5.10.2026 02:00 yeni plan plan 42666
  46. 5.10.2026 00:00 yeni plan plan 41838
  47. 4.10.2026 22:00 yeni plan plan 41011
  48. 4.10.2026 13:00 yeni plan plan 38526
  49. 4.10.2026 13:00 yeni plan plan 39301
  50. 4.10.2026 13:00 yeni plan plan 40045
  51. 4.10.2026 08:00 yeni plan plan 37466
  52. 2.10.2026 17:00 yeni plan plan 35105
  53. 2.10.2026 17:00 yeni plan plan 35841
  54. 2.10.2026 17:00 yeni plan plan 36545
  55. 2.10.2026 16:00 yeni plan plan 34137
  56. 2.10.2026 02:00 yeni plan plan 33686
  57. 2.10.2026 01:00 yeni plan plan 32981
  58. 2.10.2026 00:00 yeni plan plan 31799
  59. 2.10.2026 00:00 yeni plan plan 32358
  60. 1.10.2026 21:00 yeni plan plan 31137
  61. 1.10.2026 20:00 yeni plan plan 29649
  62. 1.10.2026 20:00 yeni plan plan 30304
  63. 1.10.2026 19:00 yeni plan plan 27589
  64. 1.10.2026 19:00 yeni plan plan 28232
  65. 1.10.2026 19:00 yeni plan plan 28900
  66. 30.09.2026 22:00 yeni plan plan 23103
  67. 30.09.2026 22:00 yeni plan plan 23758
  68. 30.09.2026 22:00 yeni plan plan 24296
  69. 30.09.2026 22:00 yeni plan plan 24937
  70. 30.09.2026 22:00 yeni plan plan 25551
  71. 30.09.2026 22:00 yeni plan plan 26225
  72. 30.09.2026 22:00 yeni plan plan 26888
  73. 30.09.2026 21:00 yeni plan plan 20479
  74. 30.09.2026 21:00 yeni plan plan 21158
  75. 30.09.2026 21:00 yeni plan plan 21817
  76. 30.09.2026 21:00 yeni plan plan 22432
  77. 30.09.2026 20:00 yeni plan plan 19788
  78. 30.09.2026 19:00 yeni plan plan 19082
  79. 30.09.2026 15:00 yeni plan plan 17132
  80. 30.09.2026 15:00 yeni plan plan 17755
  81. 30.09.2026 15:00 yeni plan plan 18387
  82. 30.09.2026 11:00 yeni plan plan 14611
  83. 30.09.2026 11:00 yeni plan plan 15260
  84. 30.09.2026 11:00 yeni plan plan 15933
  85. 30.09.2026 11:00 yeni plan plan 16488
  86. 30.09.2026 10:00 yeni plan plan 12918
  87. 30.09.2026 10:00 yeni plan plan 13440
  88. 30.09.2026 10:00 yeni plan plan 14011
  89. 30.09.2026 07:00 yeni plan plan 12326
  90. 30.09.2026 06:00 yeni plan plan 10681
  91. 30.09.2026 06:00 yeni plan plan 11226
  92. 30.09.2026 06:00 yeni plan plan 11733
  93. 30.09.2026 05:00 yeni plan plan 10082
  94. 30.09.2026 00:00 yeni plan plan 9079
  95. 29.09.2026 21:00 yeni plan plan 8179
  96. 29.09.2026 21:00 yeni plan plan 8629
  97. 29.09.2026 20:00 yeni plan plan 7704
  98. 28.09.2026 16:00 yeni plan plan 6090

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-02110,10,1 0,18
2026-10-0450,10,1 0,18
2026-10-05260,10,1 0,18
2026-10-0660,10,1 0,19
2026-10-0760,10,1 0,18
2026-10-0940,30,3 0,88

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
1401110,10,18 30.09.2026 10:56 en iyi
1775510,10,18 30.09.2026 15:42
1291810,10,18 30.09.2026 10:51
2555110,10,18 30.09.2026 22:40
1008210,10,18 30.09.2026 05:49
5375810,10,18 5.10.2026 13:58
7868810,10,18 9.10.2026 13:15
4813010,10,18 5.10.2026 10:03
7534710,10,19 8.10.2026 17:17
1344010,10,18 30.09.2026 10:52
3298110,10,18 2.10.2026 01:09
2429620,10,18 30.09.2026 22:38
1461110,10,18 30.09.2026 11:02
6980410,10,18 7.10.2026 20:53
4987810,10,18 5.10.2026 12:32
3654530,10,18 2.10.2026 18:17
7357010,10,19 8.10.2026 16:34
4900110,10,19 5.10.2026 10:42
7167710,10,18 8.10.2026 12:37
1232610,10,18 30.09.2026 07:00
3368610,10,19 2.10.2026 02:27
2964910,10,18 1.10.2026 20:57
6148510,10,18 5.10.2026 22:56
4733510,10,19 5.10.2026 10:00
3413720,10,18 2.10.2026 16:25
3030410,10,18 1.10.2026 20:58
1838710,10,18 30.09.2026 15:51
6533910,10,18 7.10.2026 13:55
2493710,10,18 30.09.2026 22:38
5715110,10,18 5.10.2026 20:19
5546610,10,19 5.10.2026 17:58
1908210,10,18 30.09.2026 19:36
1648810,10,18 30.09.2026 11:22
8051110,10,18 9.10.2026 14:29
6056110,10,19 5.10.2026 22:03
4362110,10,18 5.10.2026 09:01
6397360,10,19 6.10.2026 05:50
6309610,10,19 5.10.2026 23:04
5805210,10,19 5.10.2026 21:02
5463910,10,18 5.10.2026 17:49
6637710,10,18 7.10.2026 20:12
2047910,10,18 30.09.2026 21:24
6810410,10,19 7.10.2026 20:50
1593320,10,18 30.09.2026 11:20
1122610,10,18 30.09.2026 06:58
6735410,10,19 7.10.2026 20:49
1526020,10,18 30.09.2026 11:15
7720810,10,19 8.10.2026 19:59
4101110,10,18 4.10.2026 22:07
817910,10,18 29.09.2026 21:26
6090160,10,18 29.09.2026 18:42
1173320,10,18 30.09.2026 06:59
2890010,10,18 1.10.2026 19:31
7443810,10,19 8.10.2026 16:38
4635710,10,18 5.10.2026 09:48
3746610,10,18 4.10.2026 08:55
2181710,10,18 30.09.2026 21:34
2758910,10,18 1.10.2026 19:13
3179910,10,18 2.10.2026 00:05
4004510,10,18 4.10.2026 13:45
2375820,10,18 30.09.2026 22:19
5143210,10,18 5.10.2026 12:58
8255810,10,19 9.10.2026 19:25
3510510,10,18 2.10.2026 17:24
5893710,10,19 5.10.2026 21:38
5295710,10,18 5.10.2026 13:19
1068110,10,18 30.09.2026 06:32
1978810,10,18 30.09.2026 20:42
4561410,10,18 5.10.2026 09:48
9079100,10,18 30.09.2026 05:42
862910,10,18 29.09.2026 21:50
3113710,10,18 1.10.2026 21:13
5975910,10,19 5.10.2026 21:41
7630910,10,19 8.10.2026 18:57
770410,10,18 29.09.2026 20:13
4266610,10,18 5.10.2026 02:58
3584110,10,18 2.10.2026 17:32
7963810,10,18 9.10.2026 14:27
2243210,10,18 30.09.2026 21:37
5063310,10,18 5.10.2026 12:33
2310310,10,18 30.09.2026 22:15
3852610,10,18 4.10.2026 13:29
6894610,10,19 7.10.2026 20:51
3235810,10,19 2.10.2026 00:06
7080510,10,18 8.10.2026 12:20
4183810,10,19 5.10.2026 00:27
2823210,10,18 1.10.2026 19:18
6220710,10,18 5.10.2026 22:56
2622510,10,18 30.09.2026 22:53
1713210,10,18 30.09.2026 15:32
5629910,10,19 5.10.2026 18:28
2115810,10,18 30.09.2026 21:32
5214510,10,18 5.10.2026 12:59
3930110,10,18 4.10.2026 13:31
4437010,20,29 5.10.2026 09:09
2688810,20,28 30.09.2026 22:56
7262210,30,39 8.10.2026 14:01
8156510,90,99 9.10.2026 17:45 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-05 02:10', '2026-01-05 02:10', N'dbo.T.IX_New', 0, 1, 0)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.