Pahalı sorgular0xEBCCDDF732DED0B3
Demo modu

Sorgu 0xEBCCDDF732DED0B3

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

Ort. süre 81,5 ms▲ %788,3
Ort. CPU 80,9 ms▲ %855,4
Bekleme payı %0,7▼ %90,5
Ort. mantıksal okuma 770▲ %164,9
En büyük bellek izni –

Değişim: önceki dönem 2026-09-26 → 2026-10-02 ile karşılaştırma (çalışma ağırlıklı ortalama).

Takip

Yeni

Bu sorgu henüz analiz edilmedi.

Bilinen sorgu, ertele:

Günlük trend

3.10.2026: 1 çalışma, ort. 1.142,7 ms4.10.2026: 57 çalışma, ort. 301,8 ms5.10.2026: 211 çalışma, ort. 18,8 ms6.10.2026: 50 çalışma, ort. 58,5 ms7.10.2026: 49 çalışma, ort. 75,4 ms9.10.2026: 33 çalışma, ort. 113,9 ms max 211 çalışma max ort. süre 1.142,7 ms 3.10.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. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  2. 4.10.2026 13:00 yeni plan plan 38841
  3. 1.10.2026 21:00 plan değişimi P408 7645→30664
  4. 1.10.2026 21:00 yeni plan plan 30664
  5. 30.09.2026 03:00 yeni plan plan 9471
  6. 29.09.2026 20:00 yeni plan plan 7645
  7. 28.09.2026 22:00 yeni plan plan 6680
  8. 28.09.2026 16:00 yeni plan plan 5974
  9. 28.09.2026 16:00 yeni plan plan 6053

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0311.139,21.142,7 1.142,713.193
2026-10-0457301,6301,8 1.189,32.507
2026-10-0521118,818,8 1.159,9353
2026-10-065058,458,5 1.446,1675
2026-10-074974,175,4 3.231,3476
2026-10-0933109,5113,9 3.131,9638

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
76454402,42,4243 9.10.2026 17:45 en iyi
30664261.444,91.359,08.776 9.10.2026 14:51
3884111.703,51.703,314.084 4.10.2026 13:30 en kötü

Davranış

Wait kategorileri (QDS)
CPU:1991,Memory:525,Buffer IO:300
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 
(@from datetime,@asOf datetime,@ServerID int,@DatabaseName nvarchar(128),@minExec int)SELECT rs.ServerID, rs.DatabaseName, p.query_id, rs.plan_id,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.count_executions ELSE 0 END) AS Execs,
               SUM(CASE WHEN rs.execution_type = 3 THEN rs.count_executions ELSE 0 END) AS Aborted,
               SUM(CASE WHEN rs.execution_type = 4 THEN rs.count_executions ELSE 0 END) AS Failed,
               MIN(CASE WHEN rs.execution_type = 0 THEN rs.IntervalStartUtc END) AS FirstUtc,
               MAX(CASE WHEN rs.execution_type = 0 THEN rs.IntervalEndUtc END) AS LastUtc,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_duration * rs.count_executions END) AS SumDur,
               MAX(CASE WHEN rs.execution_type = 0 THEN rs.max_duration END) AS MaxDur,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.count_executions * (SQUARE(ISNULL(rs.stdev_duration, 0)) + SQUARE(rs.avg_duration)) END) AS SumSq,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_cpu_time * rs.count_executions END) AS SumCpu,
               MAX(CASE WHEN rs.execution_type = 0 THEN rs.max_cpu_time END) AS MaxCpu,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_logical_io_reads * rs.count_executions END) AS SumReads,
               MAX(CASE WHEN rs.execution_type = 0 THEN rs.max_logical_io_reads END) AS MaxReads,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_physical_io_reads * rs.count_executions END) AS SumPhys,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_logical_io_writes * rs.count_executions END) AS SumWrites,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_query_max_used_memory * rs.count_executions END) AS SumMem,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_tempdb_space_used * rs.count_executions END) AS SumTempdb,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_dop * rs.count_executions END) AS SumDop,
               SUM(CASE WHEN rs.execution_type = 0 THEN rs.avg_rowcount * rs.count_executions END) AS SumRows,
               MAX(CASE WHEN rs.execution_type = 0 THEN rs.max_rowcount END) AS MaxRows
        INTO #ps
        FROM perf.QdsRuntimeStats AS rs
        JOIN perf.QdsPlan AS p ON p.ServerID = rs.ServerID AND p.DatabaseName = rs.DatabaseName AND p.plan_id = rs.plan_id
        JOIN DBA.MonitoredDatabase AS md ON md.ServerID = rs.ServerID AND md.DatabaseName = rs.DatabaseName
        WHERE md.IsActive = 1 AND md.CollectQds = 1
          AND rs.IntervalStartUtc >= @from AND rs.IntervalStartUtc < @asOf
          AND (@ServerID IS NULL OR rs.ServerID = @ServerID)
          AND (@DatabaseName IS NULL OR rs.DatabaseName = @DatabaseName)
        GROUP BY rs.ServerID, rs.DatabaseName, p.query_id, rs.plan_id
        HAVING SUM(CASE WHEN rs.execution_type = 0 THEN rs.count_executions ELSE 0 END) >= @minExec

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.