Pahalı sorgular0x398F28114374C201
Demo modu

Sorgu 0x398F28114374C201

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

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

6.10.2026: 101.783 çalışma, ort. 24,7 ms7.10.2026: 62.789 çalışma, ort. 35,7 ms9.10.2026: 376 çalışma, ort. 30,4 ms max 101.783 çalışma max ort. süre 35,7 ms 6.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 17:00 yeni plan plan 81945
  2. 9.10.2026 13:00 yeni plan plan 78148
  3. 8.10.2026 21:00 yeni plan plan 78028
  4. 8.10.2026 20:00 yeni plan plan 77579
  5. 8.10.2026 20:00 yeni plan plan 77586
  6. 8.10.2026 13:00 yeni plan plan 72091
  7. 7.10.2026 20:00 plan değişimi P432 65794→66795
  8. 7.10.2026 20:00 yeni plan plan 66795
  9. 7.10.2026 16:00 plan değişimi P431 64452→65794
  10. 7.10.2026 16:00 yeni plan plan 65794
  11. 6.10.2026 00:00 plan değişimi P430 64329→64390
  12. 6.10.2026 00:00 yeni plan plan 64329
  13. 6.10.2026 00:00 yeni plan plan 64390
  14. 6.10.2026 00:00 yeni plan plan 64452

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-06101.78324,724,7 51,423.660
2026-10-0762.78935,635,7 43,237.464
2026-10-0937630,330,4 51,823.968

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
7802850,70,745 8.10.2026 21:18 en iyi
6439053.3991,11,1289 8.10.2026 12:48
644527.8091,31,3318 6.10.2026 16:58
667959885,05,0665 7.10.2026 20:48
775862237,06,9306 9.10.2026 18:16
781481988,28,1358 9.10.2026 18:18
720914.38511,111,1448 8.10.2026 14:00
6579429.25439,439,442.768 8.10.2026 18:43
6432979.22445,345,244.648 8.10.2026 19:18
7757915550,645,434.825 9.10.2026 17:19
819458253,853,750.981 9.10.2026 17:59 en kötü

Davranış

Wait kategorileri (QDS)
CPU:14170,Memory:2217,Buffer IO:268
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 
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @srv) AS ServerName,
       MAX(ObjectName) AS ObjectName,
       (SELECT TOP (1) SampleTextHash FROM perf.QueryDailyStats WHERE ServerID = @srv AND DatabaseName = @dbName AND query_hash = @hash
          AND StatDateUtc BETWEEN @from AND @to AND SampleTextHash IS NOT NULL ORDER BY StatDateUtc DESC) AS SampleTextHash,
       -- K2-5: wait kategorileri dönem toplamı (ilk 3), rollup'ın son günü değil
       (SELECT STRING_AGG(CONCAT(w.Category, N':', CAST(w.TotalMs AS nvarchar(20))), N',') WITHIN GROUP (ORDER BY w.TotalMs DESC)
        FROM (SELECT TOP (3) ws.wait_category_desc AS Category, SUM(ws.total_query_wait_time_ms) AS TotalMs
              FROM perf.QdsWaitStats AS ws
              JOIN perf.QdsPlan AS wp ON wp.ServerID = ws.ServerID AND wp.DatabaseName = ws.DatabaseName AND wp.plan_id = ws.plan_id
              JOIN perf.QdsQuery AS wq ON wq.ServerID = wp.ServerID AND wq.DatabaseName = wp.DatabaseName AND wq.query_id = wp.query_id
              WHERE ws.ServerID = @srv AND ws.DatabaseName = @dbName AND wq.query_hash = @hash
                AND ws.IntervalStartUtc >= @from AND ws.IntervalStartUtc < DATEADD(day, 1, @to)
                AND NOT EXISTS (SELECT 1 FROM perf.QdsQueryText AS it CROSS APPLY perf.fn_InternalQueryText(it.query_sql_text) AS iq WHERE it.TextHash = wq.TextHash)
              GROUP BY ws.wait_category_desc ORDER BY SUM(ws.total_query_wait_time_ms) DESC) AS w) AS TopWaitCategories,
       (SELECT TOP (1) SessionTopWaits FROM perf.QueryDailyStats WHERE ServerID = @srv AND DatabaseName = @dbName AND query_hash = @hash
          AND StatDateUtc BETWEEN @from AND @to AND SessionTopWaits IS NOT NULL ORDER BY StatDateUtc DESC) AS SessionTopWaits,
       ISNULL(SUM(CAST(BlockedOthersCount AS bigint)), 0) AS BlockedOthersCount, MAX(MaxGrantedMemoryKb) AS MaxGrantedMemoryKb
FROM perf.QueryDailyStats
WHERE ServerID = @srv AND DatabaseName = @dbName AND query_hash = @hash AND StatDateUtc BETWEEN @from AND @to

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.