Pahalı sorgular0x31A3E817436A0738
Demo modu

Sorgu 0x31A3E817436A0738

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,4 ms
Ort. CPU 0,4 ms
Bekleme payı %0,1
Ort. mantıksal okuma 24
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,3 ms29.09.2026: 13 çalışma, ort. 0,4 ms30.09.2026: 43 çalışma, ort. 0,4 ms1.10.2026: 6 çalışma, ort. 0,4 ms2.10.2026: 11 çalışma, ort. 0,3 ms4.10.2026: 5 çalışma, ort. 0,3 ms5.10.2026: 26 çalışma, ort. 0,4 ms6.10.2026: 6 çalışma, ort. 0,3 ms7.10.2026: 6 çalışma, ort. 0,3 ms9.10.2026: 4 çalışma, ort. 0,4 ms max 43 çalışma max ort. süre 0,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 82553
  2. 9.10.2026 17:00 yeni plan plan 81560
  3. 9.10.2026 14:00 yeni plan plan 79633
  4. 9.10.2026 14:00 yeni plan plan 80471
  5. 9.10.2026 13:00 yeni plan plan 78684
  6. 8.10.2026 19:00 yeni plan plan 77204
  7. 8.10.2026 18:00 yeni plan plan 76305
  8. 8.10.2026 17:00 yeni plan plan 75342
  9. 8.10.2026 16:00 yeni plan plan 73564
  10. 8.10.2026 16:00 yeni plan plan 74398
  11. 8.10.2026 14:00 yeni plan plan 72618
  12. 8.10.2026 12:00 yeni plan plan 70800
  13. 8.10.2026 12:00 yeni plan plan 71672
  14. 7.10.2026 20:00 yeni plan plan 66337
  15. 7.10.2026 20:00 yeni plan plan 67350
  16. 7.10.2026 20:00 yeni plan plan 68100
  17. 7.10.2026 20:00 yeni plan plan 68942
  18. 7.10.2026 20:00 yeni plan plan 69800
  19. 7.10.2026 13:00 yeni plan plan 65334
  20. 6.10.2026 00:00 yeni plan plan 63969
  21. 5.10.2026 23:00 yeni plan plan 63092
  22. 5.10.2026 22:00 yeni plan plan 60521
  23. 5.10.2026 22:00 yeni plan plan 61481
  24. 5.10.2026 22:00 yeni plan plan 62203
  25. 5.10.2026 21:00 yeni plan plan 58047
  26. 5.10.2026 21:00 yeni plan plan 58933
  27. 5.10.2026 21:00 yeni plan plan 59755
  28. 5.10.2026 20:00 yeni plan plan 57146
  29. 5.10.2026 18:00 yeni plan plan 56259
  30. 5.10.2026 17:00 yeni plan plan 54633
  31. 5.10.2026 17:00 yeni plan plan 55461
  32. 5.10.2026 13:00 yeni plan plan 52945
  33. 5.10.2026 13:00 yeni plan plan 53718
  34. 5.10.2026 12:00 yeni plan plan 49838
  35. 5.10.2026 12:00 yeni plan plan 50629
  36. 5.10.2026 12:00 yeni plan plan 51428
  37. 5.10.2026 12:00 yeni plan plan 52141
  38. 5.10.2026 10:00 yeni plan plan 47331
  39. 5.10.2026 10:00 yeni plan plan 48126
  40. 5.10.2026 10:00 yeni plan plan 48996
  41. 5.10.2026 09:00 yeni plan plan 43617
  42. 5.10.2026 09:00 yeni plan plan 44330
  43. 5.10.2026 09:00 yeni plan plan 45608
  44. 5.10.2026 09:00 yeni plan plan 46350
  45. 5.10.2026 02:00 yeni plan plan 42661
  46. 5.10.2026 00:00 yeni plan plan 41833
  47. 4.10.2026 22:00 yeni plan plan 41006
  48. 4.10.2026 13:00 yeni plan plan 38522
  49. 4.10.2026 13:00 yeni plan plan 39297
  50. 4.10.2026 13:00 yeni plan plan 40041
  51. 4.10.2026 08:00 yeni plan plan 37462
  52. 2.10.2026 17:00 yeni plan plan 35101
  53. 2.10.2026 17:00 yeni plan plan 35837
  54. 2.10.2026 17:00 yeni plan plan 36533
  55. 2.10.2026 16:00 yeni plan plan 34126
  56. 2.10.2026 02:00 yeni plan plan 33680
  57. 2.10.2026 01:00 yeni plan plan 32941
  58. 2.10.2026 00:00 yeni plan plan 31795
  59. 2.10.2026 00:00 yeni plan plan 32354
  60. 1.10.2026 21:00 yeni plan plan 31133
  61. 1.10.2026 20:00 yeni plan plan 29645
  62. 1.10.2026 20:00 yeni plan plan 30299
  63. 1.10.2026 19:00 yeni plan plan 27585
  64. 1.10.2026 19:00 yeni plan plan 28226
  65. 1.10.2026 19:00 yeni plan plan 28860
  66. 30.09.2026 22:00 yeni plan plan 23063
  67. 30.09.2026 22:00 yeni plan plan 23754
  68. 30.09.2026 22:00 yeni plan plan 24292
  69. 30.09.2026 22:00 yeni plan plan 24933
  70. 30.09.2026 22:00 yeni plan plan 25547
  71. 30.09.2026 22:00 yeni plan plan 26221
  72. 30.09.2026 22:00 yeni plan plan 26884
  73. 30.09.2026 21:00 yeni plan plan 20474
  74. 30.09.2026 21:00 yeni plan plan 21153
  75. 30.09.2026 21:00 yeni plan plan 21813
  76. 30.09.2026 21:00 yeni plan plan 22426
  77. 30.09.2026 20:00 yeni plan plan 19784
  78. 30.09.2026 19:00 yeni plan plan 19077
  79. 30.09.2026 15:00 yeni plan plan 17128
  80. 30.09.2026 15:00 yeni plan plan 17749
  81. 30.09.2026 15:00 yeni plan plan 18381
  82. 30.09.2026 11:00 yeni plan plan 14606
  83. 30.09.2026 11:00 yeni plan plan 15255
  84. 30.09.2026 11:00 yeni plan plan 15929
  85. 30.09.2026 11:00 yeni plan plan 16484
  86. 30.09.2026 10:00 yeni plan plan 12913
  87. 30.09.2026 10:00 yeni plan plan 13436
  88. 30.09.2026 10:00 yeni plan plan 14007
  89. 30.09.2026 07:00 yeni plan plan 12322
  90. 30.09.2026 06:00 yeni plan plan 10669
  91. 30.09.2026 06:00 yeni plan plan 11222
  92. 30.09.2026 06:00 yeni plan plan 11729
  93. 30.09.2026 05:00 yeni plan plan 10042
  94. 30.09.2026 00:00 yeni plan plan 9075
  95. 29.09.2026 21:00 yeni plan plan 8175
  96. 29.09.2026 21:00 yeni plan plan 8625
  97. 29.09.2026 20:00 yeni plan plan 7700
  98. 28.09.2026 16:00 yeni plan plan 6084

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2860,30,3 0,320
2026-09-29130,40,4 0,527
2026-09-30430,40,4 0,525
2026-10-0160,40,4 0,520
2026-10-02110,30,3 0,420
2026-10-0450,30,3 0,421
2026-10-05260,40,4 0,520
2026-10-0660,30,3 0,320
2026-10-0760,30,3 0,322
2026-10-0940,40,4 0,545

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
1066910,30,320 30.09.2026 06:32 en iyi
3113310,30,320 1.10.2026 21:13
5893310,30,320 5.10.2026 21:38
2493310,30,323 30.09.2026 22:38
3368010,30,320 2.10.2026 02:27
6980010,30,323 7.10.2026 20:53
4004110,30,320 4.10.2026 13:45
4433010,30,320 5.10.2026 09:09
2306310,30,323 30.09.2026 22:15
6220310,30,320 5.10.2026 22:56
6396960,30,320 6.10.2026 05:50
1907710,30,323 30.09.2026 19:36
3029910,30,320 1.10.2026 20:58
6894210,30,323 7.10.2026 20:51
5975510,30,320 5.10.2026 21:41
4899610,30,320 5.10.2026 10:42
3583710,30,320 2.10.2026 17:32
2964510,30,320 1.10.2026 20:57
1343610,30,320 30.09.2026 10:52
6309210,30,320 5.10.2026 23:04
8255310,30,320 9.10.2026 19:25
2886010,30,320 1.10.2026 19:31
5371810,30,320 5.10.2026 13:58
1291310,30,320 30.09.2026 10:51
1592920,30,322 30.09.2026 11:20
5062910,30,320 5.10.2026 12:33
4361710,30,320 5.10.2026 09:01
5804710,30,320 5.10.2026 21:02
1004210,30,320 30.09.2026 05:49
6735010,30,323 7.10.2026 20:49
5214110,30,320 5.10.2026 12:59
3852210,30,320 4.10.2026 13:28
1172920,30,320 30.09.2026 06:59
1460610,30,329 30.09.2026 11:02
3653330,30,320 2.10.2026 18:17
4812610,30,320 5.10.2026 10:03
2429220,30,322 30.09.2026 22:38
2375420,30,320 30.09.2026 22:19
4266110,30,320 5.10.2026 02:58
4733110,30,320 5.10.2026 10:00
5625910,30,320 5.10.2026 18:28
3929710,30,320 4.10.2026 13:31
6533410,30,320 7.10.2026 13:55
5294510,30,323 5.10.2026 13:19
1400710,30,329 30.09.2026 10:56
5463310,30,323 5.10.2026 17:49
862510,30,320 29.09.2026 21:50
1648410,30,323 30.09.2026 11:22
7630510,30,323 8.10.2026 18:57
6810010,30,323 7.10.2026 20:50
2622110,30,320 30.09.2026 22:53
1122210,30,320 30.09.2026 06:58
3179510,30,320 2.10.2026 00:05
3746210,30,323 4.10.2026 08:55
7167210,30,323 8.10.2026 12:37
2115310,30,323 30.09.2026 21:32
6633710,30,320 7.10.2026 20:12
3412620,40,420 2.10.2026 16:25
7720410,40,323 8.10.2026 19:59
6052110,40,420 5.10.2026 22:03
1838110,40,420 30.09.2026 15:51
9075100,40,421 30.09.2026 05:42
3235410,40,420 2.10.2026 00:06
4100610,40,420 4.10.2026 22:07
3294110,40,420 2.10.2026 01:09
817510,40,420 29.09.2026 21:26
1232210,40,420 30.09.2026 07:00
1978410,40,4101 30.09.2026 20:42
5142810,40,420 5.10.2026 12:58
4560810,40,420 5.10.2026 09:47
3510110,40,420 2.10.2026 17:24
5714610,40,420 5.10.2026 20:19
7868410,40,4119 9.10.2026 13:15
6084160,40,426 29.09.2026 18:42
7534210,40,426 8.10.2026 17:17
2688410,40,420 30.09.2026 22:56
2554710,40,423 30.09.2026 22:40
2181310,40,4101 30.09.2026 21:34
770010,40,420 29.09.2026 20:13
7080010,40,423 8.10.2026 12:20
7261810,40,420 8.10.2026 14:01
8047110,40,420 9.10.2026 14:29
8156010,40,420 9.10.2026 17:45
2242610,40,423 30.09.2026 21:37
5546110,40,423 5.10.2026 17:58
6148110,40,423 5.10.2026 22:56
1525520,40,420 30.09.2026 11:15
4983810,40,420 5.10.2026 12:32
2758510,40,420 1.10.2026 19:13
1712810,40,420 30.09.2026 15:32
2047410,50,520 30.09.2026 21:24
2822610,50,520 1.10.2026 19:18
1774910,50,520 30.09.2026 15:42
7963310,50,520 9.10.2026 14:27
4635010,50,520 5.10.2026 09:48
7439810,50,520 8.10.2026 16:38
4183310,60,620 5.10.2026 00:27
7356410,60,623 8.10.2026 16:34 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 DBA.CollectionRunLog (StartUtc, EndUtc, SourceType, ServerID, DatabaseName, Status)
    VALUES ('2026-01-04 03:00', '2026-01-04 03:01', 'METADATA', 1, N'db', 'OK'), ('2026-01-05 02:59', '2026-01-05 03:01', 'METADATA', 1, N'db', 'OK')

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.