Pahalı sorgular0x55FE786A40153A83
Demo modu

Sorgu 0x55FE786A40153A83

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

Ort. süre 0,3 ms
Ort. CPU 0,3 ms
Bekleme payı %0,2
Ort. mantıksal okuma 61
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

5.10.2026: 41.901 çalışma, ort. 0,3 ms6.10.2026: 160.372 çalışma, ort. 0,3 ms7.10.2026: 105.457 çalışma, ort. 0,4 ms9.10.2026: 166 çalışma, ort. 0,4 ms max 160.372 çalışma max ort. süre 0,4 ms 5.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. 9.10.2026 14:00 yeni plan plan 79074
  2. 5.10.2026 22:00 yeni plan plan 60968

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0541.9010,30,3 0,362
2026-10-06160.3720,30,3 0,561
2026-10-07105.4570,40,4 0,461
2026-10-091660,40,4 2,561

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
60968328.0240,30,361 9.10.2026 18:18 en iyi
7907410,70,790 9.10.2026 14:17 en kötü

Davranış

Wait kategorileri (QDS)
Memory:1752,Buffer IO:65,CPU:12
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 
(@ServerID int,@DatabaseName nvarchar(4000),@QueryHash varbinary(8),@first datetime,@last datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @ServerID) AS ServerName,
       MAX(ObjectName) AS ObjectName,
       (SELECT TOP (1) SampleTextHash FROM perf.QueryDailyStats
        WHERE ServerID = @ServerID AND DatabaseName = @DatabaseName AND query_hash = @QueryHash
          AND StatDateUtc BETWEEN @first AND @last AND SampleTextHash IS NOT NULL ORDER BY StatDateUtc DESC) AS SampleTextHash,
       (SELECT TOP (1) WorstPlanId FROM perf.QueryDailyStats
        WHERE ServerID = @ServerID AND DatabaseName = @DatabaseName AND query_hash = @QueryHash
          AND StatDateUtc BETWEEN @first AND @last AND WorstPlanId IS NOT NULL ORDER BY StatDateUtc DESC) AS WorstPlanId,
       MIN(StatDateUtc) AS FirstDay, MAX(StatDateUtc) AS LastDay, COUNT(*) AS DayCount,
       SUM(Executions) AS Executions, SUM(TotalCpuMs) AS TotalCpuMs, SUM(TotalDurationMs) AS TotalDurationMs,
       MAX(P95DurationMs) AS P95DurationMs, MAX(MaxDurationMs) AS MaxDurationMs, SUM(TotalLogicalReads) AS TotalLogicalReads, MAX(PlanCount) AS PlanCount,
       (SELECT TOP (1) TopWaitCategories FROM perf.QueryDailyStats
        WHERE ServerID = @ServerID AND DatabaseName = @DatabaseName AND query_hash = @QueryHash
          AND StatDateUtc BETWEEN @first AND @last AND TopWaitCategories IS NOT NULL ORDER BY StatDateUtc DESC) AS TopWaitCategories,
       (SELECT TOP (1) SessionTopWaits FROM perf.QueryDailyStats
        WHERE ServerID = @ServerID AND DatabaseName = @DatabaseName AND query_hash = @QueryHash
          AND StatDateUtc BETWEEN @first AND @last AND SessionTopWaits IS NOT NULL ORDER BY StatDateUtc DESC) AS SessionTopWaits,
       SUM(BlockedOthersCount) AS BlockedOthersCount, MAX(MaxGrantedMemoryKb) AS MaxGrantedMemoryKb
FROM perf.QueryDailyStats
WHERE ServerID = @ServerID AND DatabaseName = @DatabaseName AND query_hash = @QueryHash AND StatDateUtc BETWEEN @first AND @last
HAVING COUNT(*) > 0

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.