Pahalı sorgular0xEBCCDDF732DED0B3
Demo modu

Sorgu 0xEBCCDDF732DED0B3

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

Ort. süre 37,0 ms
Ort. CPU 36,4 ms
Bekleme payı %1,8
Ort. mantıksal okuma 475
En büyük bellek izni 0 MB

Ö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: 53 çalışma, ort. 18,0 ms29.09.2026: 107 çalışma, ort. 7,3 ms30.09.2026: 349 çalışma, ort. 5,8 ms1.10.2026: 49 çalışma, ort. 39,3 ms2.10.2026: 83 çalışma, ort. 2,4 ms3.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 349 çalışma max ort. süre 1.142,7 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. 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-09-285318,018,0 181,0377
2026-09-291077,37,3 187,1282
2026-09-303495,85,8 249,0266
2026-10-014930,239,3 1.545,0466
2026-10-02832,42,4 2,6247
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
60531282,32,3244 29.09.2026 18:42 en iyi
76459472,42,4242 9.10.2026 19:25
66805170,2169,91.564 29.09.2026 13:36
59743176,0175,91.807 28.09.2026 19:21
94715240,7239,61.965 30.09.2026 22:30
30664271.458,61.359,58.867 9.10.2026 14:51
3884111.703,51.703,314.084 4.10.2026 13:30 en kötü

Davranış

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

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 — 117: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.