Sorgu 0x1935DD4FD113B763
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
1,1 ms
Ort. CPU
1,1 ms
Bekleme payı
%0,1
Ort. mantıksal okuma
106
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 82554
- 9.10.2026 17:00 yeni plan plan 81561
- 9.10.2026 14:00 yeni plan plan 79634
- 9.10.2026 14:00 yeni plan plan 80472
- 9.10.2026 13:00 yeni plan plan 78685
- 8.10.2026 19:00 yeni plan plan 77205
- 8.10.2026 18:00 yeni plan plan 76306
- 8.10.2026 17:00 yeni plan plan 75343
- 8.10.2026 16:00 yeni plan plan 73565
- 8.10.2026 16:00 yeni plan plan 74399
- 8.10.2026 14:00 yeni plan plan 72619
- 8.10.2026 12:00 yeni plan plan 70801
- 8.10.2026 12:00 yeni plan plan 71673
- 7.10.2026 20:00 yeni plan plan 66338
- 7.10.2026 20:00 yeni plan plan 67351
- 7.10.2026 20:00 yeni plan plan 68101
- 7.10.2026 20:00 yeni plan plan 68943
- 7.10.2026 20:00 yeni plan plan 69801
- 7.10.2026 13:00 yeni plan plan 65335
- 6.10.2026 00:00 yeni plan plan 63970
- 5.10.2026 23:00 yeni plan plan 63093
- 5.10.2026 22:00 yeni plan plan 60522
- 5.10.2026 22:00 yeni plan plan 61482
- 5.10.2026 22:00 yeni plan plan 62204
- 5.10.2026 21:00 yeni plan plan 58048
- 5.10.2026 21:00 yeni plan plan 58934
- 5.10.2026 21:00 yeni plan plan 59756
- 5.10.2026 20:00 yeni plan plan 57147
- 5.10.2026 18:00 yeni plan plan 56260
- 5.10.2026 17:00 yeni plan plan 54634
- 5.10.2026 17:00 yeni plan plan 55462
- 5.10.2026 13:00 yeni plan plan 52946
- 5.10.2026 13:00 yeni plan plan 53719
- 5.10.2026 12:00 yeni plan plan 49839
- 5.10.2026 12:00 yeni plan plan 50630
- 5.10.2026 12:00 yeni plan plan 51429
- 5.10.2026 12:00 yeni plan plan 52142
- 5.10.2026 10:00 yeni plan plan 47332
- 5.10.2026 10:00 yeni plan plan 48127
- 5.10.2026 10:00 yeni plan plan 48997
- 5.10.2026 09:00 yeni plan plan 43618
- 5.10.2026 09:00 yeni plan plan 44331
- 5.10.2026 09:00 yeni plan plan 45609
- 5.10.2026 09:00 yeni plan plan 46351
- 5.10.2026 02:00 yeni plan plan 42662
- 5.10.2026 00:00 yeni plan plan 41834
- 4.10.2026 22:00 yeni plan plan 41007
- 4.10.2026 13:00 yeni plan plan 38523
- 4.10.2026 13:00 yeni plan plan 39298
- 4.10.2026 13:00 yeni plan plan 40042
- 4.10.2026 08:00 yeni plan plan 37463
- 2.10.2026 17:00 yeni plan plan 35102
- 2.10.2026 17:00 yeni plan plan 35838
- 2.10.2026 17:00 yeni plan plan 36534
- 2.10.2026 16:00 yeni plan plan 34127
- 2.10.2026 02:00 yeni plan plan 33681
- 2.10.2026 01:00 yeni plan plan 32942
- 2.10.2026 00:00 yeni plan plan 31796
- 2.10.2026 00:00 yeni plan plan 32355
- 1.10.2026 21:00 yeni plan plan 31134
- 1.10.2026 20:00 yeni plan plan 29646
- 1.10.2026 20:00 yeni plan plan 30300
- 1.10.2026 19:00 yeni plan plan 27586
- 1.10.2026 19:00 yeni plan plan 28227
- 1.10.2026 19:00 yeni plan plan 28861
- 30.09.2026 22:00 yeni plan plan 23064
- 30.09.2026 22:00 yeni plan plan 23755
- 30.09.2026 22:00 yeni plan plan 24293
- 30.09.2026 22:00 yeni plan plan 24934
- 30.09.2026 22:00 yeni plan plan 25548
- 30.09.2026 22:00 yeni plan plan 26222
- 30.09.2026 22:00 yeni plan plan 26885
- 30.09.2026 21:00 yeni plan plan 20475
- 30.09.2026 21:00 yeni plan plan 21154
- 30.09.2026 21:00 yeni plan plan 21814
- 30.09.2026 21:00 yeni plan plan 22427
- 30.09.2026 20:00 yeni plan plan 19785
- 30.09.2026 19:00 yeni plan plan 19078
- 30.09.2026 15:00 yeni plan plan 17129
- 30.09.2026 15:00 yeni plan plan 17750
- 30.09.2026 15:00 yeni plan plan 18382
- 30.09.2026 11:00 yeni plan plan 14607
- 30.09.2026 11:00 yeni plan plan 15256
- 30.09.2026 11:00 yeni plan plan 15930
- 30.09.2026 11:00 yeni plan plan 16485
- 30.09.2026 10:00 yeni plan plan 12914
- 30.09.2026 10:00 yeni plan plan 13437
- 30.09.2026 10:00 yeni plan plan 14008
- 30.09.2026 07:00 yeni plan plan 12323
- 30.09.2026 06:00 yeni plan plan 10670
- 30.09.2026 06:00 yeni plan plan 11223
- 30.09.2026 06:00 yeni plan plan 11730
- 30.09.2026 05:00 yeni plan plan 10043
- 30.09.2026 00:00 yeni plan plan 9076
- 29.09.2026 21:00 yeni plan plan 8176
- 29.09.2026 21:00 yeni plan plan 8626
- 29.09.2026 20:00 yeni plan plan 7701
- 28.09.2026 16:00 yeni plan plan 6085
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 | 102 |
| 2026-09-29 | 13 | 1,3 | 1,3 | 1,7 | 104 |
| 2026-09-30 | 43 | 1,1 | 1,1 | 1,2 | 105 |
| 2026-10-01 | 6 | 1,1 | 1,1 | 1,2 | 102 |
| 2026-10-02 | 11 | 1,1 | 1,1 | 1,3 | 113 |
| 2026-10-04 | 5 | 1,1 | 1,1 | 1,3 | 106 |
| 2026-10-05 | 26 | 1,2 | 1,2 | 1,4 | 106 |
| 2026-10-06 | 6 | 1,0 | 1,0 | 1,0 | 108 |
| 2026-10-07 | 6 | 1,0 | 1,0 | 1,1 | 108 |
| 2026-10-09 | 4 | 1,2 | 1,2 | 1,4 | 104 |
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 | |
|---|---|---|---|---|---|---|
| 53719 | 1 | 0,9 | 0,9 | 110 | 5.10.2026 13:58 | en iyi |
| 8176 | 1 | 0,9 | 0,9 | 100 | 29.09.2026 21:26 | |
| 35102 | 1 | 0,9 | 0,9 | 115 | 2.10.2026 17:24 | |
| 75343 | 1 | 0,9 | 0,9 | 100 | 8.10.2026 17:17 | |
| 73565 | 1 | 0,9 | 0,9 | 110 | 8.10.2026 16:34 | |
| 63093 | 1 | 1,0 | 1,0 | 107 | 5.10.2026 23:04 | |
| 69801 | 1 | 1,0 | 1,0 | 118 | 7.10.2026 20:53 | |
| 8626 | 1 | 1,0 | 1,0 | 101 | 29.09.2026 21:50 | |
| 11223 | 1 | 1,0 | 1,0 | 101 | 30.09.2026 06:58 | |
| 29646 | 1 | 1,0 | 1,0 | 101 | 1.10.2026 20:57 | |
| 27586 | 1 | 1,0 | 1,0 | 101 | 1.10.2026 19:13 | |
| 35838 | 1 | 1,0 | 1,0 | 115 | 2.10.2026 17:32 | |
| 31796 | 1 | 1,0 | 1,0 | 107 | 2.10.2026 00:05 | |
| 68101 | 1 | 1,0 | 1,0 | 115 | 7.10.2026 20:50 | |
| 71673 | 1 | 1,0 | 1,0 | 100 | 8.10.2026 12:37 | |
| 68943 | 1 | 1,0 | 0,9 | 101 | 7.10.2026 20:51 | |
| 42662 | 1 | 1,0 | 1,0 | 107 | 5.10.2026 02:58 | |
| 19785 | 1 | 1,0 | 1,0 | 103 | 30.09.2026 20:42 | |
| 63970 | 6 | 1,0 | 1,0 | 108 | 6.10.2026 05:50 | |
| 36534 | 3 | 1,0 | 1,0 | 115 | 2.10.2026 18:17 | |
| 37463 | 1 | 1,0 | 1,0 | 103 | 4.10.2026 08:55 | |
| 76306 | 1 | 1,0 | 1,0 | 107 | 8.10.2026 18:57 | |
| 65335 | 1 | 1,0 | 1,0 | 101 | 7.10.2026 13:55 | |
| 24934 | 1 | 1,0 | 1,0 | 107 | 30.09.2026 22:38 | |
| 67351 | 1 | 1,0 | 1,0 | 107 | 7.10.2026 20:49 | |
| 82554 | 1 | 1,0 | 1,0 | 100 | 9.10.2026 19:25 | |
| 72619 | 1 | 1,0 | 1,0 | 101 | 8.10.2026 14:01 | |
| 7701 | 1 | 1,0 | 1,0 | 100 | 29.09.2026 20:13 | |
| 9076 | 10 | 1,0 | 1,0 | 107 | 30.09.2026 05:42 | |
| 41007 | 1 | 1,0 | 1,0 | 108 | 4.10.2026 22:07 | |
| 40042 | 1 | 1,0 | 1,0 | 110 | 4.10.2026 13:45 | |
| 38523 | 1 | 1,1 | 1,1 | 100 | 4.10.2026 13:29 | |
| 10043 | 1 | 1,1 | 1,1 | 101 | 30.09.2026 05:49 | |
| 66338 | 1 | 1,1 | 1,1 | 107 | 7.10.2026 20:12 | |
| 18382 | 1 | 1,1 | 1,1 | 100 | 30.09.2026 15:51 | |
| 10670 | 1 | 1,1 | 1,1 | 100 | 30.09.2026 06:32 | |
| 47332 | 1 | 1,1 | 1,1 | 101 | 5.10.2026 10:00 | |
| 61482 | 1 | 1,1 | 1,1 | 106 | 5.10.2026 22:56 | |
| 43618 | 1 | 1,1 | 1,1 | 106 | 5.10.2026 09:01 | |
| 14008 | 1 | 1,1 | 1,1 | 107 | 30.09.2026 10:56 | |
| 32942 | 1 | 1,1 | 1,1 | 122 | 2.10.2026 01:09 | |
| 21814 | 1 | 1,1 | 1,1 | 109 | 30.09.2026 21:34 | |
| 48997 | 1 | 1,1 | 1,1 | 123 | 5.10.2026 10:42 | |
| 34127 | 2 | 1,1 | 1,1 | 116 | 2.10.2026 16:25 | |
| 13437 | 1 | 1,1 | 1,1 | 101 | 30.09.2026 10:52 | |
| 23755 | 2 | 1,1 | 1,1 | 103 | 30.09.2026 22:19 | |
| 12323 | 1 | 1,1 | 1,1 | 103 | 30.09.2026 07:00 | |
| 15256 | 2 | 1,1 | 1,1 | 107 | 30.09.2026 11:15 | |
| 78685 | 1 | 1,1 | 1,1 | 100 | 9.10.2026 13:15 | |
| 31134 | 1 | 1,1 | 1,1 | 107 | 1.10.2026 21:13 | |
| 24293 | 2 | 1,1 | 1,1 | 102 | 30.09.2026 22:38 | |
| 14607 | 1 | 1,1 | 1,1 | 108 | 30.09.2026 11:02 | |
| 12914 | 1 | 1,1 | 1,1 | 101 | 30.09.2026 10:51 | |
| 57147 | 1 | 1,1 | 1,1 | 100 | 5.10.2026 20:19 | |
| 45609 | 1 | 1,1 | 1,1 | 111 | 5.10.2026 09:48 | |
| 30300 | 1 | 1,1 | 1,1 | 100 | 1.10.2026 20:58 | |
| 32355 | 1 | 1,1 | 1,1 | 108 | 2.10.2026 00:06 | |
| 80472 | 1 | 1,1 | 1,1 | 108 | 9.10.2026 14:29 | |
| 21154 | 1 | 1,1 | 1,1 | 110 | 30.09.2026 21:32 | |
| 58048 | 1 | 1,1 | 1,1 | 107 | 5.10.2026 21:02 | |
| 48127 | 1 | 1,1 | 1,1 | 118 | 5.10.2026 10:03 | |
| 28861 | 1 | 1,1 | 1,1 | 100 | 1.10.2026 19:31 | |
| 49839 | 1 | 1,1 | 1,1 | 103 | 5.10.2026 12:32 | |
| 60522 | 1 | 1,1 | 1,1 | 108 | 5.10.2026 22:03 | |
| 77205 | 1 | 1,1 | 1,1 | 103 | 8.10.2026 19:59 | |
| 59756 | 1 | 1,1 | 1,1 | 101 | 5.10.2026 21:41 | |
| 19078 | 1 | 1,1 | 1,1 | 108 | 30.09.2026 19:36 | |
| 22427 | 1 | 1,2 | 1,2 | 107 | 30.09.2026 21:37 | |
| 15930 | 2 | 1,2 | 1,2 | 102 | 30.09.2026 11:20 | |
| 17750 | 1 | 1,2 | 1,2 | 114 | 30.09.2026 15:42 | |
| 20475 | 1 | 1,2 | 1,2 | 100 | 30.09.2026 21:24 | |
| 41834 | 1 | 1,2 | 1,2 | 102 | 5.10.2026 00:27 | |
| 28227 | 1 | 1,2 | 1,2 | 103 | 1.10.2026 19:18 | |
| 17129 | 1 | 1,2 | 1,2 | 102 | 30.09.2026 15:32 | |
| 25548 | 1 | 1,2 | 1,2 | 107 | 30.09.2026 22:40 | |
| 11730 | 2 | 1,2 | 1,2 | 104 | 30.09.2026 06:59 | |
| 46351 | 1 | 1,2 | 1,2 | 101 | 5.10.2026 09:48 | |
| 16485 | 1 | 1,2 | 1,2 | 104 | 30.09.2026 11:22 | |
| 50630 | 1 | 1,2 | 1,2 | 109 | 5.10.2026 12:33 | |
| 26222 | 1 | 1,2 | 1,2 | 100 | 30.09.2026 22:53 | |
| 79634 | 1 | 1,2 | 1,2 | 107 | 9.10.2026 14:27 | |
| 51429 | 1 | 1,2 | 1,2 | 110 | 5.10.2026 12:58 | |
| 26885 | 1 | 1,3 | 1,3 | 100 | 30.09.2026 22:56 | |
| 6085 | 16 | 1,3 | 1,3 | 104 | 29.09.2026 18:42 | |
| 62204 | 1 | 1,3 | 1,3 | 116 | 5.10.2026 22:56 | |
| 52142 | 1 | 1,3 | 1,3 | 100 | 5.10.2026 12:59 | |
| 44331 | 1 | 1,3 | 1,3 | 100 | 5.10.2026 09:09 | |
| 39298 | 1 | 1,3 | 1,3 | 107 | 4.10.2026 13:31 | |
| 56260 | 1 | 1,3 | 1,3 | 100 | 5.10.2026 18:28 | |
| 52946 | 1 | 1,3 | 1,3 | 100 | 5.10.2026 13:19 | |
| 58934 | 1 | 1,3 | 1,3 | 100 | 5.10.2026 21:38 | |
| 55462 | 1 | 1,4 | 1,4 | 101 | 5.10.2026 17:58 | |
| 23064 | 1 | 1,4 | 1,4 | 103 | 30.09.2026 22:15 | |
| 54634 | 1 | 1,4 | 1,4 | 100 | 5.10.2026 17:49 | |
| 33681 | 1 | 1,4 | 1,4 | 100 | 2.10.2026 02:27 | |
| 81561 | 1 | 1,4 | 1,4 | 101 | 9.10.2026 17:45 | |
| 74399 | 1 | 1,5 | 1,4 | 108 | 8.10.2026 16:38 | |
| 70801 | 1 | 1,9 | 1,9 | 104 | 8.10.2026 12:20 | 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 EventType, EarliestUtc, LatestUtc, ObjectName, UsedByOldPlan, UsedByNewPlan, OrderUncertain INTO #actual FROM rag.PlanChangeEvent
Bu sorgunun analizleri
Kayıt yok
Henüz analiz yok.