Sorgu 0xB0E8D5F65CF71433
SQL-1 · DB-11· test_PlanChange.test esik alti ve kucuk mutlak fark elenir esigi gecen vaka olur · dönem 2026-09-12 → 2026-10-11 · 125 çalışma · Pahalı sorgulara dön
Ort. süre
1,2 ms
Ort. CPU
1,2 ms
Bekleme payı
%0
Ort. mantıksal okuma
118
En büyük bellek izni
–
Önceki dönemde çalışma yok; değişim hesaplanmadı.
Takip
YeniBu sorgu henüz analiz edilmedi.
Bilinen sorgu, ertele:
Günlük trend
Ç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.- 9.10.2026 19:00 yeni plan plan 82585
- 9.10.2026 17:00 yeni plan plan 81589
- 9.10.2026 14:00 yeni plan plan 79626
- 9.10.2026 14:00 yeni plan plan 80512
- 9.10.2026 13:00 yeni plan plan 78667
- 8.10.2026 19:00 yeni plan plan 77181
- 8.10.2026 18:00 yeni plan plan 76275
- 8.10.2026 17:00 yeni plan plan 75351
- 8.10.2026 16:00 yeni plan plan 73599
- 8.10.2026 16:00 yeni plan plan 74467
- 8.10.2026 14:00 yeni plan plan 72610
- 8.10.2026 12:00 yeni plan plan 70791
- 8.10.2026 12:00 yeni plan plan 71684
- 7.10.2026 20:00 yeni plan plan 66404
- 7.10.2026 20:00 yeni plan plan 67276
- 7.10.2026 20:00 yeni plan plan 68107
- 7.10.2026 20:00 yeni plan plan 68910
- 7.10.2026 20:00 yeni plan plan 69743
- 7.10.2026 13:00 yeni plan plan 65340
- 6.10.2026 00:00 yeni plan plan 63979
- 5.10.2026 23:00 yeni plan plan 63073
- 5.10.2026 22:00 yeni plan plan 60562
- 5.10.2026 22:00 yeni plan plan 61457
- 5.10.2026 22:00 yeni plan plan 62194
- 5.10.2026 21:00 yeni plan plan 58053
- 5.10.2026 21:00 yeni plan plan 58864
- 5.10.2026 21:00 yeni plan plan 59760
- 5.10.2026 20:00 yeni plan plan 57164
- 5.10.2026 18:00 yeni plan plan 56332
- 5.10.2026 17:00 yeni plan plan 54647
- 5.10.2026 17:00 yeni plan plan 55452
- 5.10.2026 13:00 yeni plan plan 52969
- 5.10.2026 13:00 yeni plan plan 53785
- 5.10.2026 12:00 yeni plan plan 49884
- 5.10.2026 12:00 yeni plan plan 50621
- 5.10.2026 12:00 yeni plan plan 51448
- 5.10.2026 12:00 yeni plan plan 52154
- 5.10.2026 10:00 yeni plan plan 47323
- 5.10.2026 10:00 yeni plan plan 48103
- 5.10.2026 10:00 yeni plan plan 48985
- 5.10.2026 09:00 yeni plan plan 43584
- 5.10.2026 09:00 yeni plan plan 44376
- 5.10.2026 09:00 yeni plan plan 45564
- 5.10.2026 09:00 yeni plan plan 46374
- 5.10.2026 02:00 yeni plan plan 42596
- 5.10.2026 00:00 yeni plan plan 41789
- 4.10.2026 22:00 yeni plan plan 41012
- 4.10.2026 13:00 yeni plan plan 38516
- 4.10.2026 13:00 yeni plan plan 39269
- 4.10.2026 13:00 yeni plan plan 40011
- 4.10.2026 08:00 yeni plan plan 37451
- 2.10.2026 17:00 yeni plan plan 35094
- 2.10.2026 17:00 yeni plan plan 35846
- 2.10.2026 17:00 yeni plan plan 36552
- 2.10.2026 16:00 yeni plan plan 34648
- 2.10.2026 02:00 yeni plan plan 33690
- 2.10.2026 01:00 yeni plan plan 32995
- 2.10.2026 00:00 yeni plan plan 31768
- 2.10.2026 00:00 yeni plan plan 32342
- 1.10.2026 21:00 yeni plan plan 31098
- 1.10.2026 20:00 yeni plan plan 29636
- 1.10.2026 20:00 yeni plan plan 30277
- 1.10.2026 19:00 yeni plan plan 27511
- 1.10.2026 19:00 yeni plan plan 28182
- 1.10.2026 19:00 yeni plan plan 28927
- 30.09.2026 22:00 yeni plan plan 23104
- 30.09.2026 22:00 yeni plan plan 23764
- 30.09.2026 22:00 yeni plan plan 24298
- 30.09.2026 22:00 yeni plan plan 24912
- 30.09.2026 22:00 yeni plan plan 25524
- 30.09.2026 22:00 yeni plan plan 26235
- 30.09.2026 22:00 yeni plan plan 26875
- 30.09.2026 21:00 yeni plan plan 20426
- 30.09.2026 21:00 yeni plan plan 21165
- 30.09.2026 21:00 yeni plan plan 21795
- 30.09.2026 21:00 yeni plan plan 22456
- 30.09.2026 20:00 yeni plan plan 19767
- 30.09.2026 19:00 yeni plan plan 19052
- 30.09.2026 15:00 yeni plan plan 17116
- 30.09.2026 15:00 yeni plan plan 17773
- 30.09.2026 15:00 yeni plan plan 18414
- 30.09.2026 11:00 yeni plan plan 14612
- 30.09.2026 11:00 yeni plan plan 15248
- 30.09.2026 11:00 yeni plan plan 15934
- 30.09.2026 11:00 yeni plan plan 16491
- 30.09.2026 10:00 yeni plan plan 12931
- 30.09.2026 10:00 yeni plan plan 13418
- 30.09.2026 10:00 yeni plan plan 13998
- 30.09.2026 07:00 yeni plan plan 12307
- 30.09.2026 06:00 yeni plan plan 10644
- 30.09.2026 06:00 yeni plan plan 11245
- 30.09.2026 06:00 yeni plan plan 11719
- 30.09.2026 05:00 yeni plan plan 10085
- 30.09.2026 00:00 yeni plan plan 9068
- 29.09.2026 21:00 yeni plan plan 8181
- 29.09.2026 21:00 yeni plan plan 8619
- 29.09.2026 20:00 yeni plan plan 7715
- 28.09.2026 16:00 yeni plan plan 6119
Günler
| Gün | Çalışma | Ort. CPU ms | Ort. süre ms | p95 ms | Ort. reads |
|---|---|---|---|---|---|
| 2026-09-28 | 6 | 1,2 | 1,2 | 1,3 | 120 |
| 2026-09-29 | 13 | 1,1 | 1,1 | 1,3 | 121 |
| 2026-09-30 | 43 | 1,2 | 1,2 | 1,6 | 118 |
| 2026-10-01 | 6 | 1,1 | 1,1 | 1,2 | 116 |
| 2026-10-02 | 10 | 1,1 | 1,1 | 1,2 | 119 |
| 2026-10-04 | 5 | 1,1 | 1,1 | 1,2 | 115 |
| 2026-10-05 | 26 | 1,2 | 1,2 | 1,5 | 117 |
| 2026-10-06 | 6 | 1,0 | 1,0 | 1,1 | 117 |
| 2026-10-07 | 6 | 1,0 | 1,0 | 1,1 | 121 |
| 2026-10-09 | 4 | 1,8 | 1,8 | 3,1 | 120 |
Planlar
QDS, dönem içinde; ham veri 14 gün saklanır| Plan | Çalışma | Ort. süre ms | Ort. CPU ms | Ort. reads | Son çalışma | |
|---|---|---|---|---|---|---|
| 68910 | 1 | 0,9 | 0,9 | 121 | 7.10.2026 20:51 | en iyi |
| 7715 | 1 | 0,9 | 0,9 | 112 | 29.09.2026 20:13 | |
| 10085 | 1 | 0,9 | 0,9 | 121 | 30.09.2026 05:49 | |
| 26875 | 1 | 0,9 | 0,9 | 115 | 30.09.2026 22:56 | |
| 37451 | 1 | 1,0 | 1,0 | 112 | 4.10.2026 08:55 | |
| 76275 | 1 | 1,0 | 1,0 | 117 | 8.10.2026 18:57 | |
| 75351 | 1 | 1,0 | 1,0 | 132 | 8.10.2026 17:17 | |
| 66404 | 1 | 1,0 | 1,0 | 122 | 7.10.2026 20:12 | |
| 41012 | 1 | 1,0 | 1,0 | 121 | 4.10.2026 22:07 | |
| 73599 | 1 | 1,0 | 1,0 | 122 | 8.10.2026 16:34 | |
| 32342 | 1 | 1,0 | 1,0 | 118 | 2.10.2026 00:06 | |
| 8181 | 1 | 1,0 | 1,0 | 113 | 29.09.2026 21:26 | |
| 70791 | 1 | 1,0 | 1,0 | 122 | 8.10.2026 12:20 | |
| 34648 | 1 | 1,0 | 1,0 | 123 | 2.10.2026 16:25 | |
| 63979 | 6 | 1,0 | 1,0 | 117 | 6.10.2026 05:50 | |
| 38516 | 1 | 1,0 | 1,0 | 112 | 4.10.2026 13:28 | |
| 65340 | 1 | 1,1 | 1,1 | 121 | 7.10.2026 13:55 | |
| 68107 | 1 | 1,1 | 1,1 | 113 | 7.10.2026 20:50 | |
| 32995 | 1 | 1,1 | 1,1 | 123 | 2.10.2026 01:09 | |
| 30277 | 1 | 1,1 | 1,1 | 112 | 1.10.2026 20:58 | |
| 10644 | 1 | 1,1 | 1,1 | 115 | 30.09.2026 06:32 | |
| 18414 | 1 | 1,1 | 1,1 | 123 | 30.09.2026 15:51 | |
| 46374 | 1 | 1,1 | 1,1 | 119 | 5.10.2026 09:49 | |
| 9068 | 10 | 1,1 | 1,1 | 120 | 30.09.2026 05:42 | |
| 36552 | 3 | 1,1 | 1,1 | 115 | 2.10.2026 18:17 | |
| 69743 | 1 | 1,1 | 1,1 | 127 | 7.10.2026 20:53 | |
| 56332 | 1 | 1,1 | 1,1 | 112 | 5.10.2026 18:28 | |
| 11245 | 1 | 1,1 | 1,1 | 117 | 30.09.2026 06:58 | |
| 33690 | 1 | 1,1 | 1,1 | 114 | 2.10.2026 02:27 | |
| 26235 | 1 | 1,1 | 1,1 | 115 | 30.09.2026 22:53 | |
| 71684 | 1 | 1,1 | 1,1 | 114 | 8.10.2026 12:37 | |
| 80512 | 1 | 1,1 | 1,1 | 113 | 9.10.2026 14:29 | |
| 67276 | 1 | 1,1 | 1,1 | 124 | 7.10.2026 20:49 | |
| 12307 | 1 | 1,1 | 1,1 | 112 | 30.09.2026 07:00 | |
| 49884 | 1 | 1,1 | 1,1 | 115 | 5.10.2026 12:32 | |
| 19767 | 1 | 1,1 | 1,1 | 114 | 30.09.2026 20:42 | |
| 57164 | 1 | 1,1 | 1,1 | 112 | 5.10.2026 20:19 | |
| 82585 | 1 | 1,1 | 1,1 | 121 | 9.10.2026 19:25 | |
| 14612 | 1 | 1,1 | 1,1 | 121 | 30.09.2026 11:02 | |
| 31098 | 1 | 1,1 | 1,1 | 112 | 1.10.2026 21:13 | |
| 60562 | 1 | 1,1 | 1,1 | 122 | 5.10.2026 22:03 | |
| 13998 | 1 | 1,1 | 1,1 | 114 | 30.09.2026 10:56 | |
| 47323 | 1 | 1,1 | 1,1 | 122 | 5.10.2026 10:00 | |
| 16491 | 1 | 1,1 | 1,1 | 115 | 30.09.2026 11:22 | |
| 43584 | 1 | 1,1 | 1,1 | 112 | 5.10.2026 09:00 | |
| 27511 | 1 | 1,1 | 1,1 | 121 | 1.10.2026 19:13 | |
| 44376 | 1 | 1,1 | 1,1 | 122 | 5.10.2026 09:09 | |
| 29636 | 1 | 1,1 | 1,1 | 114 | 1.10.2026 20:57 | |
| 55452 | 1 | 1,1 | 1,1 | 113 | 5.10.2026 17:58 | |
| 28927 | 1 | 1,1 | 1,1 | 122 | 1.10.2026 19:31 | |
| 24912 | 1 | 1,1 | 1,1 | 113 | 30.09.2026 22:38 | |
| 13418 | 1 | 1,1 | 1,1 | 112 | 30.09.2026 10:52 | |
| 21795 | 1 | 1,1 | 1,1 | 121 | 30.09.2026 21:34 | |
| 58053 | 1 | 1,1 | 1,1 | 114 | 5.10.2026 21:02 | |
| 40011 | 1 | 1,1 | 1,1 | 119 | 4.10.2026 13:45 | |
| 50621 | 1 | 1,1 | 1,1 | 114 | 5.10.2026 12:33 | |
| 54647 | 1 | 1,2 | 1,2 | 121 | 5.10.2026 17:49 | |
| 6119 | 16 | 1,2 | 1,2 | 123 | 29.09.2026 18:42 | |
| 8619 | 1 | 1,2 | 1,2 | 113 | 29.09.2026 21:50 | |
| 12931 | 1 | 1,2 | 1,2 | 113 | 30.09.2026 10:51 | |
| 21165 | 1 | 1,2 | 1,2 | 122 | 30.09.2026 21:32 | |
| 35846 | 1 | 1,2 | 1,2 | 113 | 2.10.2026 17:32 | |
| 19052 | 1 | 1,2 | 1,2 | 119 | 30.09.2026 19:36 | |
| 39269 | 1 | 1,2 | 1,2 | 113 | 4.10.2026 13:31 | |
| 23104 | 1 | 1,2 | 1,2 | 115 | 30.09.2026 22:15 | |
| 48103 | 1 | 1,2 | 1,2 | 122 | 5.10.2026 10:03 | |
| 17773 | 1 | 1,2 | 1,2 | 124 | 30.09.2026 15:42 | |
| 61457 | 1 | 1,2 | 1,2 | 129 | 5.10.2026 22:56 | |
| 62194 | 1 | 1,2 | 1,2 | 114 | 5.10.2026 22:56 | |
| 45564 | 1 | 1,2 | 1,2 | 124 | 5.10.2026 09:47 | |
| 48985 | 1 | 1,2 | 1,2 | 126 | 5.10.2026 10:42 | |
| 31768 | 1 | 1,2 | 1,2 | 131 | 2.10.2026 00:05 | |
| 35094 | 1 | 1,2 | 1,2 | 119 | 2.10.2026 17:24 | |
| 22456 | 1 | 1,2 | 1,2 | 113 | 30.09.2026 21:37 | |
| 79626 | 1 | 1,2 | 1,2 | 112 | 9.10.2026 14:27 | |
| 15934 | 2 | 1,2 | 1,2 | 123 | 30.09.2026 11:20 | |
| 42596 | 1 | 1,3 | 1,3 | 121 | 5.10.2026 02:58 | |
| 63073 | 1 | 1,3 | 1,3 | 112 | 5.10.2026 23:04 | |
| 28182 | 1 | 1,3 | 1,3 | 115 | 1.10.2026 19:18 | |
| 41789 | 1 | 1,3 | 1,3 | 112 | 5.10.2026 00:27 | |
| 17116 | 1 | 1,3 | 1,3 | 112 | 30.09.2026 15:32 | |
| 78667 | 1 | 1,3 | 1,3 | 128 | 9.10.2026 13:15 | |
| 15248 | 2 | 1,3 | 1,3 | 114 | 30.09.2026 11:15 | |
| 24298 | 2 | 1,3 | 1,3 | 120 | 30.09.2026 22:38 | |
| 52154 | 1 | 1,3 | 1,3 | 115 | 5.10.2026 12:59 | |
| 58864 | 1 | 1,3 | 1,3 | 113 | 5.10.2026 21:38 | |
| 53785 | 1 | 1,4 | 1,4 | 123 | 5.10.2026 13:58 | |
| 51448 | 1 | 1,4 | 1,4 | 116 | 5.10.2026 12:58 | |
| 72610 | 1 | 1,4 | 1,4 | 124 | 8.10.2026 14:01 | |
| 20426 | 1 | 1,5 | 1,5 | 112 | 30.09.2026 21:24 | |
| 59760 | 1 | 1,6 | 1,6 | 113 | 5.10.2026 21:41 | |
| 23764 | 2 | 1,6 | 1,6 | 112 | 30.09.2026 22:19 | |
| 52969 | 1 | 1,6 | 1,6 | 115 | 5.10.2026 13:19 | |
| 25524 | 1 | 1,6 | 1,6 | 122 | 30.09.2026 22:40 | |
| 74467 | 1 | 1,9 | 1,9 | 122 | 8.10.2026 16:38 | |
| 77181 | 1 | 2,0 | 2,0 | 121 | 8.10.2026 19:59 | |
| 11719 | 2 | 2,3 | 2,3 | 119 | 30.09.2026 06:59 | |
| 81589 | 1 | 3,4 | 3,4 | 126 | 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 yakalamaSorgu metni
SELECT query_id, OldPlanId, NewPlanId, ChangeUtc, ChangeEndUtc, Direction, DurationRatio, Pattern, Status INTO #actual FROM rag.PlanChangeCase
Bu sorgunun analizleri
Kayıt yok
Henüz analiz yok.