Pahalı sorgular0xB45E54900DC36283
Demo modu

Sorgu 0xB45E54900DC36283

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

Ort. süre 37,8 ms▲ %103
Ort. CPU 37,1 ms▲ %107,8
Bekleme payı %1,8▼ %55,5
Ort. mantıksal okuma 2.800▲ %237,7
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

4.10.2026: 419 çalışma, ort. 35,7 ms5.10.2026: 1.215 çalışma, ort. 49,0 ms6.10.2026: 254 çalışma, ort. 2,4 ms7.10.2026: 538 çalışma, ort. 30,8 ms max 1.215 çalışma max ort. süre 49,0 ms 4.10.2026 7.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. 8.10.2026 14:00 yeni plan plan 72992
  2. 8.10.2026 14:00 yeni plan plan 72954
  3. 8.10.2026 12:00 yeni plan plan 72062
  4. 8.10.2026 12:00 yeni plan plan 71164
  5. 7.10.2026 20:00 yeni plan plan 66830
  6. 7.10.2026 10:00 plan değişimi P426 62548→64806
  7. 7.10.2026 10:00 yeni plan plan 64806
  8. 7.10.2026 10:00 yeni plan plan 64802
  9. 7.10.2026 10:00 yeni plan plan 64801
  10. 6.10.2026 00:00 yeni plan plan 64450
  11. 6.10.2026 00:00 yeni plan plan 64327
  12. 6.10.2026 00:00 yeni plan plan 64313
  13. 5.10.2026 22:00 plan değişimi P425 54132→62548
  14. 5.10.2026 22:00 yeni plan plan 62548
  15. 5.10.2026 22:00 yeni plan plan 60949
  16. 5.10.2026 22:00 yeni plan plan 60948
  17. 5.10.2026 21:00 yeni plan plan 58444
  18. 5.10.2026 21:00 yeni plan plan 58443
  19. 5.10.2026 20:00 yeni plan plan 57521
  20. 5.10.2026 20:00 yeni plan plan 57519
  21. 5.10.2026 18:00 yeni plan plan 56669
  22. 5.10.2026 17:00 yeni plan plan 55010
  23. 5.10.2026 13:00 yeni plan plan 54132
  24. 5.10.2026 13:00 yeni plan plan 53308
  25. 5.10.2026 13:00 yeni plan plan 53306
  26. 5.10.2026 12:00 yeni plan plan 49433
  27. 5.10.2026 10:00 yeni plan plan 49358
  28. 5.10.2026 10:00 yeni plan plan 48466
  29. 5.10.2026 10:00 yeni plan plan 48464
  30. 4.10.2026 08:00 yeni plan plan 37058
  31. 4.10.2026 08:00 yeni plan plan 37019
  32. 2.10.2026 18:00 yeni plan plan 36918
  33. 1.10.2026 21:00 yeni plan plan 30740
  34. 1.10.2026 21:00 yeni plan plan 30738
  35. 1.10.2026 21:00 yeni plan plan 30612
  36. 1.10.2026 21:00 yeni plan plan 30608
  37. 1.10.2026 19:00 yeni plan plan 29171
  38. 30.09.2026 22:00 yeni plan plan 25831
  39. 30.09.2026 22:00 yeni plan plan 25829
  40. 30.09.2026 22:00 yeni plan plan 25825
  41. 30.09.2026 22:00 yeni plan plan 25813
  42. 30.09.2026 22:00 yeni plan plan 25804
  43. 30.09.2026 21:00 yeni plan plan 20069
  44. 30.09.2026 20:00 yeni plan plan 20050
  45. 30.09.2026 15:00 yeni plan plan 18009
  46. 30.09.2026 11:00 yeni plan plan 16711
  47. 30.09.2026 11:00 yeni plan plan 14872
  48. 30.09.2026 11:00 yeni plan plan 14860
  49. 30.09.2026 11:00 yeni plan plan 14859
  50. 30.09.2026 11:00 yeni plan plan 14858
  51. 30.09.2026 11:00 yeni plan plan 14856
  52. 30.09.2026 11:00 yeni plan plan 14854
  53. 30.09.2026 11:00 yeni plan plan 14853
  54. 30.09.2026 10:00 yeni plan plan 12528
  55. 30.09.2026 06:00 yeni plan plan 10245
  56. 30.09.2026 05:00 yeni plan plan 9707
  57. 30.09.2026 05:00 yeni plan plan 9643
  58. 30.09.2026 05:00 yeni plan plan 9641
  59. 30.09.2026 05:00 yeni plan plan 9633
  60. 30.09.2026 05:00 yeni plan plan 9629

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0441935,535,7 63,71.984
2026-10-051.21548,249,0 89,32.707
2026-10-062542,42,4 3,0242
2026-10-0753829,730,8 87,24.854

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
57521541,81,8171 8.10.2026 18:58 en iyi
48464101,91,9172 5.10.2026 11:41
60949442,02,0176 8.10.2026 18:43
64327462,02,0180 8.10.2026 18:58
6480132,12,1219 8.10.2026 15:39
64450212,12,1198 8.10.2026 18:58
30740112,22,2203 5.10.2026 08:59
64313332,22,2252 8.10.2026 18:43
5501062,32,3164 5.10.2026 17:50
64802132,32,3271 8.10.2026 18:43
25831782,32,3201 5.10.2026 11:41
48466102,42,4194 5.10.2026 11:41
4935832,52,5211 5.10.2026 11:41
575192472,52,4251 8.10.2026 18:58
71164172,52,2279 8.10.2026 12:38
64806202,52,5270 –
58443292,82,8266 8.10.2026 15:39
609481742,82,8321 8.10.2026 18:43
30738482,92,9260 5.10.2026 08:59
258251733,03,0248 5.10.2026 11:07
72954703,03,0261 8.10.2026 18:58
306081683,03,0273 5.10.2026 11:41
53308133,13,1195 –
5666973,23,2276 5.10.2026 18:28
5844424,54,5190 –
3701916,46,4358 4.10.2026 08:15
53306114,514,5251 5.10.2026 13:20
5413234434,132,712.865 8.10.2026 18:43
729924561,861,82.285 8.10.2026 14:22
720625676,076,06.118 8.10.2026 14:19
3705871877,475,94.231 5.10.2026 12:24
6683028481,481,24.961 8.10.2026 19:22
4943330288,688,54.768 7.10.2026 20:39
625481695.459,65.451,9629.960 8.10.2026 19:21 en kötü

Davranış

Wait kategorileri (QDS)
CPU:4526,Memory:1047,Preemptive:4
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,@to datetime,@srv int,@dbName nvarchar(4000),@minExec bigint,@len int,@regMin bigint,@regression bit,@regRatio float,@candidates bit,@qHash varbinary(8000),@qId bigint,@qText nvarchar(4000))WITH cur AS (
    SELECT ServerID, DatabaseName, query_hash,
           ISNULL(SUM(Executions), 0) AS Executions, ISNULL(SUM(TotalCpuMs), 0) AS TotalCpuMs, ISNULL(SUM(TotalDurationMs), 0) AS TotalDurationMs,
           MAX(P95DurationMs) AS P95DurationMs, ISNULL(SUM(TotalLogicalReads), 0) AS TotalLogicalReads,
           ISNULL(SUM(CAST(BlockedOthersCount AS bigint)), 0) AS BlockedOthersCount, ISNULL(MAX(PlanCount), 0) AS PlanCount,
           COUNT(*) AS DayCount, MAX(ObjectName) AS ObjectName
    FROM perf.QueryDailyStats
    WHERE StatDateUtc BETWEEN @from AND @to
      AND (@srv IS NULL OR ServerID = @srv) AND (@dbName IS NULL OR DatabaseName = @dbName)
    GROUP BY ServerID, DatabaseName, query_hash
    HAVING ISNULL(SUM(Executions), 0) >= @minExec
),
prev AS (   -- önceki eşit uzunluktaki dönem (kötüleşme)
    SELECT ServerID, DatabaseName, query_hash, SUM(Executions) AS Executions, SUM(TotalDurationMs) AS TotalDurationMs
    FROM perf.QueryDailyStats
    WHERE StatDateUtc BETWEEN DATEADD(day, -@len, @from) AND DATEADD(day, -1, @from)
      AND (@srv IS NULL OR ServerID = @srv) AND (@dbName IS NULL OR DatabaseName = @dbName)
    GROUP BY ServerID, DatabaseName, query_hash
),
ranked AS (
    SELECT c.*,
           CASE WHEN c.Executions >= @regMin AND p.Executions >= @regMin AND p.TotalDurationMs > 0
                THEN (c.TotalDurationMs / c.Executions) / (p.TotalDurationMs / p.Executions) END AS RegressionRatio
    FROM cur AS c
    LEFT JOIN prev AS p ON p.ServerID = c.ServerID AND p.DatabaseName = c.DatabaseName AND p.query_hash = c.query_hash
)
SELECT c.*, ISNULL(t.State, 'New') AS State, qc.Reasons AS CandidateReasons
INTO #r
FROM ranked AS c
LEFT JOIN #t AS t ON t.ServerID = c.ServerID AND t.DatabaseName = c.DatabaseName AND t.QueryHash = c.query_hash
LEFT JOIN rag.QueryCandidate AS qc ON qc.ServerID = c.ServerID AND qc.DatabaseName = c.DatabaseName AND qc.QueryHash = c.query_hash
WHERE (@regression = 0 OR c.RegressionRatio >= @regRatio)
  AND (@candidates = 0 OR qc.Reasons IS NOT NULL)
  AND (@qHash IS NULL OR c.query_hash = @qHash)
  AND (@qId IS NULL OR EXISTS (SELECT 1 FROM perf.QdsQuery AS q
                               WHERE q.ServerID = c.ServerID AND q.DatabaseName = c.DatabaseName AND q.query_hash = c.query_hash AND q.query_id = @qId))
  -- Metin: nesne adı ya da dönemdeki örnek metinlerden biri (yalnız süzülmüş dönem satırlarında; ham metin taranmaz)
  AND (@qText IS NULL OR c.ObjectName LIKE @qText
       OR EXISTS (SELECT 1 FROM perf.QueryDailyStats AS d
                  LEFT JOIN perf.QdsQueryText AS qt ON qt.TextHash = d.SampleTextHash
                  LEFT JOIN perf.SqlText AS st ON st.TextHash = d.SampleTextHash
                  WHERE d.ServerID = c.ServerID AND d.DatabaseName = c.DatabaseName AND d.query_hash = c.query_hash
                    AND d.StatDateUtc BETWEEN @from AND @to AND d.SampleTextHash IS NOT NULL
                    AND (qt.query_sql_text LIKE @qText OR st.SqlText LIKE @qText))) option (PLAN PER VALUE(ObjectID = 0, QueryVariantID = 8, optional_predicate(@qHash IS NULL),optional_predicate(@dbName IS NULL),optional_predicate(@srv IS NULL)))

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.