Pahalı sorgular0xEBCCDDF732DED0B3
Demo modu

Sorgu 0xEBCCDDF732DED0B3

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

Ort. süre 192,7 ms
Ort. CPU 187,1 ms
Bekleme payı %2,9
Ort. mantıksal okuma 1.742
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: 53 çalışma, ort. 18,0 ms29.09.2026: 84 çalışma, ort. 10,7 ms30.09.2026: 19 çalışma, ort. 215,6 ms1.10.2026: 4 çalışma, ort. 739,1 ms3.10.2026: 1 çalışma, ort. 801,4 ms4.10.2026: 17 çalışma, ort. 734,1 ms5.10.2026: 3 çalışma, ort. 1.061,6 ms6.10.2026: 2 çalışma, ort. 1.500,0 ms7.10.2026: 1 çalışma, ort. 2.775,6 ms9.10.2026: 1 çalışma, ort. 4.506,3 ms max 84 çalışma max ort. süre 4.506,3 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. 6.10.2026 02:00 tanım değişti rag.usp_PlanChange_Detect
  2. 4.10.2026 11:00 yeni plan plan 8077
  3. 3.10.2026 03:00 yeni plan plan 7973
  4. 1.10.2026 21:00 yeni plan plan 7752
  5. 30.09.2026 07:00 yeni plan plan 7479
  6. 30.09.2026 06:00 yeni plan plan 7408
  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-298410,710,7 187,6313
2026-09-3019214,3215,6 265,41.703
2026-10-014735,7739,1 1.070,06.049
2026-10-031797,6801,4 801,411.609
2026-10-0417730,0734,1 863,27.443
2026-10-0531.061,51.061,6 1.592,57.831
2026-10-0621.483,11.500,0 1.520,116.580
2026-10-0712.661,32.775,6 2.775,611.588
2026-10-0913.730,84.506,3 4.506,313.091

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
59743176,0175,91.807 28.09.2026 19:21
74082181,3178,21.660 30.09.2026 06:30
66807184,0183,81.622 30.09.2026 03:30
747917218,4217,31.710 1.10.2026 19:05
80773763,9756,88.574 4.10.2026 13:30
797318787,5784,67.551 5.10.2026 09:30
775291.887,11.720,011.670 9.10.2026 14:51 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:1076,CPU:589,Memory:577
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.