Pahalı sorgular0x042D6BAA9E94370C
Demo modu

Sorgu 0x042D6BAA9E94370C

SQL-1 · DB-11· rag.usp_PlanChange_Detect · dönem 2026-09-12 → 2026-10-11 · 189 çalışma · Pahalı sorgulara dön

Ort. süre 6,9 ms
Ort. CPU 3,7 ms
Bekleme payı %45,9
Ort. mantıksal okuma 724
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: 1 çalışma, ort. 2,2 ms30.09.2026: 36 çalışma, ort. 0,7 ms2.10.2026: 24 çalışma, ort. 0,8 ms3.10.2026: 1 çalışma, ort. 18,5 ms4.10.2026: 49 çalışma, ort. 5,6 ms5.10.2026: 18 çalışma, ort. 2,3 ms6.10.2026: 50 çalışma, ort. 4,0 ms7.10.2026: 9 çalışma, ort. 30,8 ms9.10.2026: 1 çalışma, ort. 442,1 ms max 50 çalışma max ort. süre 442,1 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 14:00 yeni plan plan 80950
  2. 8.10.2026 20:00 yeni plan plan 77595
  3. 8.10.2026 19:00 yeni plan plan 77155
  4. 8.10.2026 08:00 yeni plan plan 70222
  5. 7.10.2026 20:00 yeni plan plan 66352
  6. 7.10.2026 20:00 yeni plan plan 66804
  7. 7.10.2026 20:00 yeni plan plan 69757
  8. 6.10.2026 03:00 yeni plan plan 64546
  9. 6.10.2026 00:00 yeni plan plan 63941
  10. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  11. 5.10.2026 09:00 yeni plan plan 44345
  12. 5.10.2026 09:00 yeni plan plan 44778
  13. 5.10.2026 03:00 yeni plan plan 43031
  14. 5.10.2026 02:00 yeni plan plan 42610
  15. 4.10.2026 22:00 yeni plan plan 40961
  16. 4.10.2026 22:00 yeni plan plan 41390
  17. 4.10.2026 21:00 yeni plan plan 40553
  18. 4.10.2026 19:00 yeni plan plan 40434
  19. 4.10.2026 14:00 yeni plan plan 40394
  20. 4.10.2026 13:00 yeni plan plan 38470
  21. 4.10.2026 13:00 yeni plan plan 38852
  22. 4.10.2026 13:00 yeni plan plan 39987
  23. 4.10.2026 10:00 yeni plan plan 37979
  24. 4.10.2026 09:00 yeni plan plan 37806
  25. 4.10.2026 08:00 yeni plan plan 37423
  26. 3.10.2026 03:00 yeni plan plan 36977
  27. 2.10.2026 17:00 yeni plan plan 36504
  28. 30.09.2026 22:00 yeni plan plan 23724
  29. 30.09.2026 22:00 yeni plan plan 24055
  30. 30.09.2026 21:00 yeni plan plan 20440
  31. 30.09.2026 21:00 yeni plan plan 20743
  32. 30.09.2026 20:00 yeni plan plan 19338
  33. 30.09.2026 19:00 yeni plan plan 19024
  34. 28.09.2026 16:00 yeni plan plan 5986

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2811,82,2 2,2336
2026-09-30360,70,7 1,342
2026-10-02240,80,8 1,027
2026-10-03116,218,5 18,54.216
2026-10-04495,45,6 18,31.557
2026-10-05182,22,3 15,8601
2026-10-06502,74,0 97,0405
2026-10-0798,830,8 258,51.175
2026-10-091121,0442,1 442,112.273

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
1902480,60,627 30.09.2026 19:36 en iyi
23724160,60,627 30.09.2026 22:19
3998780,60,627 4.10.2026 13:45
4096180,60,627 4.10.2026 22:07
63941480,60,627 6.10.2026 05:50
3847080,70,727 4.10.2026 13:29
6635280,70,627 7.10.2026 20:12
4261080,70,727 5.10.2026 02:58
7715580,70,727 8.10.2026 19:59
4434580,70,727 5.10.2026 09:09
6975780,70,727 7.10.2026 20:53
3742380,70,727 4.10.2026 08:55
36504240,80,827 2.10.2026 18:17
2044080,90,927 30.09.2026 21:24
1933821,11,0166 30.09.2026 20:30
2074311,11,1180 30.09.2026 21:30
2405511,31,3133 30.09.2026 22:30
598612,21,8336 28.09.2026 16:24
40434212,012,04.142 4.10.2026 20:30
37979312,811,94.197 4.10.2026 12:30
37806114,313,94.448 4.10.2026 09:30
43031114,714,05.119 5.10.2026 03:30
38852114,914,44.585 4.10.2026 13:30
40394515,515,24.514 4.10.2026 18:30
44778116,015,25.266 5.10.2026 09:30
36977316,515,34.354 4.10.2026 08:30
41390216,715,24.694 4.10.2026 23:30
40553120,820,04.707 4.10.2026 21:30
64546283,452,09.490 6.10.2026 22:15
668041272,174,710.357 7.10.2026 20:40
809501442,1121,012.273 9.10.2026 14:52
7022211.303,2129,911.000 8.10.2026 08:30
7759512.635,0250,912.474 8.10.2026 20:03 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:4158,Memory:11,CPU:7
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 
(@altMin int,@start datetime)UPDATE c SET
            ChangeUtc = pr.ChangeUtc, ChangeEndUtc = pr.ChangeEndUtc, Direction = pr.Direction, DurationRatio = pr.Ratio,
            TotalLoadDeltaMs = pr.LoadMs, Pattern = CASE WHEN pr.Switches >= @altMin THEN 'Alternating' ELSE 'Switch' END,
            AlternatingSwitches = pr.Switches,
            query_hash = q.query_hash, ObjectName = q.ObjectName, SqlText = t.query_sql_text,
            OldQueryPlanHash = po.query_plan_hash, NewQueryPlanHash = pn.query_plan_hash,
            OldIsForced = po.is_forced_plan, NewIsForced = pn.is_forced_plan,
            OldCompat = po.compatibility_level, NewCompat = pn.compatibility_level,
            OldPlanXml = xo.PlanXmlCompressed, NewPlanXml = xn.PlanXmlCompressed,
            Status = CASE WHEN c.Status = 'Unsure' THEN 'Unsure' ELSE 'New' END,
            RulesVersion = NULL, EvidenceUpdatedUtc = @start
        FROM rag.PlanChangeCase AS c
        JOIN #pair AS pr ON pr.CaseID = c.CaseID
        LEFT JOIN perf.QdsQuery AS q ON q.ServerID = c.ServerID AND q.DatabaseName = c.DatabaseName AND q.query_id = c.query_id
        LEFT JOIN perf.QdsQueryText AS t ON t.TextHash = q.TextHash
        LEFT JOIN perf.QdsPlan AS po ON po.ServerID = c.ServerID AND po.DatabaseName = c.DatabaseName AND po.plan_id = c.OldPlanId
        LEFT JOIN perf.QdsPlan AS pn ON pn.ServerID = c.ServerID AND pn.DatabaseName = c.DatabaseName AND pn.plan_id = c.NewPlanId
        LEFT JOIN perf.QdsPlanXml AS xo ON xo.PlanHash = po.PlanHash
        LEFT JOIN perf.QdsPlanXml AS xn ON xn.PlanHash = pn.PlanHash

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.