Pahalı sorgular0xB42B96D77BF20E30
Demo modu

Sorgu 0xB42B96D77BF20E30

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 1,4 ms
Ort. CPU 1,3 ms
Bekleme payı %4
Ort. mantıksal okuma 126
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. 2,3 ms29.09.2026: 13 çalışma, ort. 1,1 ms30.09.2026: 43 çalışma, ort. 1,2 ms1.10.2026: 6 çalışma, ort. 3,9 ms2.10.2026: 10 çalışma, ort. 1,3 ms4.10.2026: 5 çalışma, ort. 1,1 ms5.10.2026: 26 çalışma, ort. 1,2 ms6.10.2026: 6 çalışma, ort. 1,1 ms7.10.2026: 6 çalışma, ort. 1,0 ms9.10.2026: 4 çalışma, ort. 1,2 ms max 43 çalışma max ort. süre 3,9 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 82510
  2. 9.10.2026 17:00 yeni plan plan 81553
  3. 9.10.2026 14:00 yeni plan plan 79622
  4. 9.10.2026 14:00 yeni plan plan 80524
  5. 9.10.2026 13:00 yeni plan plan 78627
  6. 8.10.2026 19:00 yeni plan plan 77214
  7. 8.10.2026 18:00 yeni plan plan 76297
  8. 8.10.2026 17:00 yeni plan plan 75336
  9. 8.10.2026 16:00 yeni plan plan 73579
  10. 8.10.2026 16:00 yeni plan plan 74471
  11. 8.10.2026 14:00 yeni plan plan 72582
  12. 8.10.2026 12:00 yeni plan plan 70754
  13. 8.10.2026 12:00 yeni plan plan 71678
  14. 7.10.2026 20:00 yeni plan plan 66400
  15. 7.10.2026 20:00 yeni plan plan 67320
  16. 7.10.2026 20:00 yeni plan plan 68112
  17. 7.10.2026 20:00 yeni plan plan 68947
  18. 7.10.2026 20:00 yeni plan plan 69794
  19. 7.10.2026 13:00 yeni plan plan 65362
  20. 6.10.2026 00:00 yeni plan plan 63983
  21. 5.10.2026 23:00 yeni plan plan 63079
  22. 5.10.2026 22:00 yeni plan plan 60568
  23. 5.10.2026 22:00 yeni plan plan 61407
  24. 5.10.2026 22:00 yeni plan plan 62187
  25. 5.10.2026 21:00 yeni plan plan 58040
  26. 5.10.2026 21:00 yeni plan plan 58904
  27. 5.10.2026 21:00 yeni plan plan 59742
  28. 5.10.2026 20:00 yeni plan plan 57152
  29. 5.10.2026 18:00 yeni plan plan 56300
  30. 5.10.2026 17:00 yeni plan plan 54666
  31. 5.10.2026 17:00 yeni plan plan 55412
  32. 5.10.2026 13:00 yeni plan plan 52973
  33. 5.10.2026 13:00 yeni plan plan 53759
  34. 5.10.2026 12:00 yeni plan plan 49879
  35. 5.10.2026 12:00 yeni plan plan 50614
  36. 5.10.2026 12:00 yeni plan plan 51419
  37. 5.10.2026 12:00 yeni plan plan 52164
  38. 5.10.2026 10:00 yeni plan plan 47301
  39. 5.10.2026 10:00 yeni plan plan 48133
  40. 5.10.2026 10:00 yeni plan plan 48989
  41. 5.10.2026 09:00 yeni plan plan 43597
  42. 5.10.2026 09:00 yeni plan plan 44371
  43. 5.10.2026 09:00 yeni plan plan 45621
  44. 5.10.2026 09:00 yeni plan plan 46378
  45. 5.10.2026 02:00 yeni plan plan 42636
  46. 5.10.2026 00:00 yeni plan plan 41864
  47. 4.10.2026 22:00 yeni plan plan 40985
  48. 4.10.2026 13:00 yeni plan plan 38527
  49. 4.10.2026 13:00 yeni plan plan 39289
  50. 4.10.2026 13:00 yeni plan plan 40046
  51. 4.10.2026 08:00 yeni plan plan 37482
  52. 2.10.2026 17:00 yeni plan plan 35090
  53. 2.10.2026 17:00 yeni plan plan 35842
  54. 2.10.2026 17:00 yeni plan plan 36558
  55. 2.10.2026 16:00 yeni plan plan 34644
  56. 2.10.2026 02:00 yeni plan plan 33700
  57. 2.10.2026 01:00 yeni plan plan 32999
  58. 2.10.2026 00:00 yeni plan plan 31772
  59. 2.10.2026 00:00 yeni plan plan 32335
  60. 1.10.2026 21:00 yeni plan plan 31102
  61. 1.10.2026 20:00 yeni plan plan 29586
  62. 1.10.2026 20:00 yeni plan plan 30293
  63. 1.10.2026 19:00 yeni plan plan 27553
  64. 1.10.2026 19:00 yeni plan plan 28249
  65. 1.10.2026 19:00 yeni plan plan 28901
  66. 30.09.2026 22:00 yeni plan plan 23131
  67. 30.09.2026 22:00 yeni plan plan 23768
  68. 30.09.2026 22:00 yeni plan plan 24240
  69. 30.09.2026 22:00 yeni plan plan 24920
  70. 30.09.2026 22:00 yeni plan plan 25557
  71. 30.09.2026 22:00 yeni plan plan 26226
  72. 30.09.2026 22:00 yeni plan plan 26810
  73. 30.09.2026 21:00 yeni plan plan 20466
  74. 30.09.2026 21:00 yeni plan plan 21169
  75. 30.09.2026 21:00 yeni plan plan 21799
  76. 30.09.2026 21:00 yeni plan plan 22461
  77. 30.09.2026 20:00 yeni plan plan 19804
  78. 30.09.2026 19:00 yeni plan plan 19010
  79. 30.09.2026 15:00 yeni plan plan 17120
  80. 30.09.2026 15:00 yeni plan plan 17777
  81. 30.09.2026 15:00 yeni plan plan 18389
  82. 30.09.2026 11:00 yeni plan plan 14563
  83. 30.09.2026 11:00 yeni plan plan 15261
  84. 30.09.2026 11:00 yeni plan plan 15938
  85. 30.09.2026 11:00 yeni plan plan 16460
  86. 30.09.2026 10:00 yeni plan plan 12899
  87. 30.09.2026 10:00 yeni plan plan 13443
  88. 30.09.2026 10:00 yeni plan plan 14012
  89. 30.09.2026 07:00 yeni plan plan 12335
  90. 30.09.2026 06:00 yeni plan plan 10692
  91. 30.09.2026 06:00 yeni plan plan 11207
  92. 30.09.2026 06:00 yeni plan plan 11723
  93. 30.09.2026 05:00 yeni plan plan 10090
  94. 30.09.2026 00:00 yeni plan plan 9057
  95. 29.09.2026 21:00 yeni plan plan 8169
  96. 29.09.2026 21:00 yeni plan plan 8589
  97. 29.09.2026 20:00 yeni plan plan 7707
  98. 28.09.2026 16:00 yeni plan plan 6092

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2861,12,3 4,1125
2026-09-29131,11,1 1,4125
2026-09-30431,21,2 1,8125
2026-10-0163,93,9 13,6127
2026-10-02101,31,3 1,5124
2026-10-0451,11,1 1,3125
2026-10-05261,21,2 1,5127
2026-10-0661,11,1 1,2127
2026-10-0761,01,0 1,0124
2026-10-0941,21,2 1,2133

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
6979410,90,9118 7.10.2026 20:53 en iyi
858910,90,9119 29.09.2026 21:50
3299911,01,0138 2.10.2026 01:09
6640011,01,0122 7.10.2026 20:12
4098511,01,0119 4.10.2026 22:07
7533611,01,0138 8.10.2026 17:17
5375911,01,0128 5.10.2026 13:58
6732011,01,0118 7.10.2026 20:49
1009011,01,0128 30.09.2026 05:49
6894711,01,0128 7.10.2026 20:51
7357911,01,0119 8.10.2026 16:34
6536211,01,0129 7.10.2026 13:55
7075411,01,0142 8.10.2026 12:19
4813311,01,0118 5.10.2026 10:03
6811211,01,0128 7.10.2026 20:50
8251011,01,0119 9.10.2026 19:25
6307911,01,0130 5.10.2026 23:04
7258211,11,0128 8.10.2026 14:01
7629711,11,1128 8.10.2026 18:57
3852711,11,1138 4.10.2026 13:29
816911,11,1121 29.09.2026 21:26
3029311,11,1129 1.10.2026 20:58
5630011,11,1120 5.10.2026 18:28
1980411,11,1118 30.09.2026 20:42
7962211,11,1139 9.10.2026 14:27
6398361,11,1127 6.10.2026 05:50
3110211,11,1118 1.10.2026 21:13
6056811,11,1128 5.10.2026 22:03
7167811,11,1131 8.10.2026 12:37
770711,11,1119 29.09.2026 20:13
1120711,11,1118 30.09.2026 06:58
4437111,11,1118 5.10.2026 09:09
3655831,11,1130 2.10.2026 18:17
1401211,11,1128 30.09.2026 10:56
7721411,11,1119 8.10.2026 19:59
4562111,11,1136 5.10.2026 09:48
2246111,11,1129 30.09.2026 21:37
9057101,11,1129 30.09.2026 05:42
2179911,11,1119 30.09.2026 21:34
2890111,11,1138 1.10.2026 19:31
5297311,11,1119 5.10.2026 13:19
2492011,11,1118 30.09.2026 22:38
3748211,11,1121 4.10.2026 08:55
1344311,11,1126 30.09.2026 10:52
2376821,11,1126 30.09.2026 22:19
1456311,11,1128 30.09.2026 11:02
8052411,11,1132 9.10.2026 14:29
3464411,11,1118 2.10.2026 16:25
4898911,21,2130 5.10.2026 10:42
1777711,21,2122 30.09.2026 15:42
2555711,21,2118 30.09.2026 22:40
5890411,21,2118 5.10.2026 21:38
2313111,21,2125 30.09.2026 22:15
4987911,21,2134 5.10.2026 12:32
1526121,21,2122 30.09.2026 11:15
2116911,21,2129 30.09.2026 21:32
2824911,21,2129 1.10.2026 19:19
8155311,21,2130 9.10.2026 17:45
4359711,21,2118 5.10.2026 09:01
5974211,21,2129 5.10.2026 21:41
7862711,21,2130 9.10.2026 13:15
5466611,21,2119 5.10.2026 17:49
4730111,21,2129 5.10.2026 10:00
5141911,21,2118 5.10.2026 12:58
2958611,21,2118 1.10.2026 20:57
1233511,21,2129 30.09.2026 07:00
3370011,21,2121 2.10.2026 02:27
1289911,21,2121 30.09.2026 10:51
1712011,21,2124 30.09.2026 15:32
1593821,21,2122 30.09.2026 11:20
6140711,31,3153 5.10.2026 22:55
2046611,31,3118 30.09.2026 21:24
4004611,31,3128 4.10.2026 13:45
2424021,31,3131 30.09.2026 22:38
1172321,31,3122 30.09.2026 06:59
3928911,31,3121 4.10.2026 13:31
5541211,31,3119 5.10.2026 17:58
5061411,41,4129 5.10.2026 12:33
4263611,41,4119 5.10.2026 02:58
4186411,41,4139 5.10.2026 00:27
5216411,41,4132 5.10.2026 12:59
1901011,41,4129 30.09.2026 19:36
3233511,41,4119 2.10.2026 00:06
3584211,51,5118 2.10.2026 17:32
1838911,51,5121 30.09.2026 15:51
3177211,51,5118 2.10.2026 00:05
5804011,51,5128 5.10.2026 21:02
6218711,51,5131 5.10.2026 22:56
4637811,51,5119 5.10.2026 09:49
3509011,61,6119 2.10.2026 17:24
6092161,61,1126 29.09.2026 18:42
2681011,61,6121 30.09.2026 22:56
5715211,61,6129 5.10.2026 20:19
1646011,71,7121 30.09.2026 11:22
2622611,91,9134 30.09.2026 22:53
7447112,02,0128 8.10.2026 16:38
1069212,02,0131 30.09.2026 06:32
27553117,717,7128 1.10.2026 19:13 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:6
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 
SELECT PlanRole, Executions, Aborted, Failed, AvgDurationMs, MaxDurationMs, AvgCpuMs, AvgLogicalReads, AvgRows, FirstUtc
    INTO #actual FROM rag.PlanChangeMetric

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.