Sorgu 0x7055A90F75F19274

SQL-1 · DB-11 · dönem 2026-10-03 → 2026-10-09 · 233 çalışma · Pahalı sorgulara dön

Ort. süre 511,9 ms

Ort. CPU 511,4 ms

Bekleme payı %0,1

Ort. mantıksal okuma 33.947

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

Ç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.

8.10.2026 20:00 yeni plan plan 77642
8.10.2026 12:00 yeni plan plan 71178
7.10.2026 20:00 yeni plan plan 70178
7.10.2026 14:00 plan değişimi P423 54153→65749
7.10.2026 14:00 yeni plan plan 65749
5.10.2026 14:00 yeni plan plan 54153
5.10.2026 10:00 yeni plan plan 48489

Günler

Gün	Çalışma	Ort. CPU ms	Ort. süre ms	p95 ms	Ort. reads
2026-10-05	135	228,9	229,1	522,3	26.656
2026-10-07	40	582,7	583,1	748,1	32.676
2026-10-09	58	1.119,8	1.121,2	1.306,8	51.795

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
48489	89	77,8	77,6	20.795	5.10.2026 11:50	en iyi
70178	30	101,6	101,6	15.016	8.10.2026 14:20
71178	30	103,9	103,7	15.722	8.10.2026 12:45
54153	46	521,7	521,6	37.994	5.10.2026 18:21
77642	32	955,4	954,2	47.580	9.10.2026 14:25
65749	148	1.081,4	1.077,9	47.349	9.10.2026 18:17	en kötü

Davranış

Wait kategorileri (QDS): CPU:797,Memory:268,Buffer IO:9
Session'da görülen wait'ler: –
Başka oturumları bloklama: 0
En büyük memory grant: –

Saat dağılımı

session yakalama

Sorgu metni

SQL

(@noStatus bit,@statuses2 nvarchar(4000),@statuses1 nvarchar(4000),@Confidence nvarchar(4000),@Direction nvarchar(4000),@Pattern nvarchar(4000),@ServerId int,@DatabaseName nvarchar(4000),@caseId bigint,@qHash varbinary(8000),@qId bigint,@qText nvarchar(4000),@asOf date,@Top int)WITH sel AS (
    SELECT c.*, ROW_NUMBER() OVER (PARTITION BY c.ServerID, c.DatabaseName, c.query_id ORDER BY c.DetectedUtc DESC, c.CaseID DESC) AS rn
    FROM rag.PlanChangeCase AS c
    WHERE (@noStatus = 1 OR c.Status IN (@statuses1,@statuses2))
      AND (@Confidence IS NULL OR c.Confidence = @Confidence)
      AND (@Direction IS NULL OR c.Direction = @Direction)
      AND (@Pattern IS NULL OR c.Pattern = @Pattern)
      AND (@ServerId IS NULL OR c.ServerID = @ServerId)
      AND (@DatabaseName IS NULL OR c.DatabaseName = @DatabaseName)
      AND (@caseId IS NULL OR c.CaseID = @caseId)
      AND (@qHash IS NULL OR c.query_hash = @qHash)
      AND (@qId IS NULL OR @qId IN (c.query_id, c.OldPlanId, c.NewPlanId))
      AND (@qText IS NULL OR c.SqlText LIKE @qText OR c.ObjectName LIKE @qText))
SELECT TOP (@Top) c.CaseID AS CaseId, c.ServerID AS ServerId, c.DatabaseName, c.query_id AS QueryId,
       LEFT(LTRIM(REPLACE(REPLACE(REPLACE(c.SqlText, CHAR(13), ' '), CHAR(10), ' '), CHAR(9), ' ')), 80) AS SqlSnippet,
       c.Direction, c.DurationRatio, c.TotalLoadDeltaMs, c.Confidence, c.Pattern,
       (SELECT STRING_AGG(x.Code, ', ') FROM (SELECT DISTINCT f.Code FROM rag.PlanChangeFinding AS f
         WHERE f.CaseID = c.CaseID AND f.Kind = 'Candidate' AND f.Supports = 1) AS x) AS Candidates,
       (SELECT COUNT(*) FROM rag.PlanChangeFinding AS f WHERE f.CaseID = c.CaseID AND f.Kind = 'Counter') AS CounterCount,
       c.Status, c.DetectedUtc,
       o.OtherCases, ISNULL(o.OtherAccepted, 0) AS OtherAccepted, ISNULL(o.OtherRejected, 0) AS OtherRejected, c.query_hash AS QueryHash, t.State AS TrackState, c.Source
FROM sel AS c
OUTER APPLY (SELECT COUNT(*) AS OtherCases,
                    SUM(IIF(p.Status IN ('Accepted', 'AutoAccepted'), 1, 0)) AS OtherAccepted,
                    SUM(IIF(p.Status = 'Rejected', 1, 0)) AS OtherRejected
             FROM rag.PlanChangeCase AS p
             WHERE p.ServerID = c.ServerID AND p.DatabaseName = c.DatabaseName AND p.query_id = c.query_id AND p.CaseID <> c.CaseID) AS o
OUTER APPLY (SELECT s.State FROM rag.fn_QueryTrackState(c.ServerID, c.DatabaseName, c.query_hash, ISNULL(@asOf, CAST(DBA.fn_Now() AS date))) AS s
             WHERE c.query_hash IS NOT NULL) AS t
WHERE c.rn = 1
ORDER BY c.TotalLoadDeltaMs DESC, c.CaseID

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.