Pahalı sorgular0xC53BE8B76E191624
Demo modu

Sorgu 0xC53BE8B76E191624

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

Ort. süre 0,7 ms
Ort. CPU 0,7 ms
Bekleme payı %2,9
Ort. mantıksal okuma 35
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: 52 çalışma, ort. 0,6 ms29.09.2026: 107 çalışma, ort. 0,7 ms30.09.2026: 313 çalışma, ort. 0,7 ms1.10.2026: 49 çalışma, ort. 1,0 ms2.10.2026: 59 çalışma, ort. 0,6 ms4.10.2026: 8 çalışma, ort. 0,7 ms5.10.2026: 193 çalışma, ort. 0,8 ms7.10.2026: 40 çalışma, ort. 0,7 ms9.10.2026: 32 çalışma, ort. 0,6 ms max 313 çalışma max ort. süre 1,0 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. 9.10.2026 19:00 yeni plan plan 82524
  2. 9.10.2026 17:00 yeni plan plan 81529
  3. 9.10.2026 14:00 yeni plan plan 80486
  4. 9.10.2026 14:00 yeni plan plan 79584
  5. 9.10.2026 13:00 yeni plan plan 78641
  6. 8.10.2026 18:00 yeni plan plan 76249
  7. 8.10.2026 17:00 yeni plan plan 75312
  8. 8.10.2026 16:00 yeni plan plan 74413
  9. 8.10.2026 16:00 yeni plan plan 73538
  10. 8.10.2026 14:00 yeni plan plan 72558
  11. 8.10.2026 12:00 yeni plan plan 71646
  12. 8.10.2026 12:00 yeni plan plan 70765
  13. 7.10.2026 20:00 yeni plan plan 68886
  14. 7.10.2026 20:00 yeni plan plan 67290
  15. 7.10.2026 13:00 yeni plan plan 65308
  16. 5.10.2026 23:00 yeni plan plan 63034
  17. 5.10.2026 22:00 yeni plan plan 61421
  18. 5.10.2026 22:00 yeni plan plan 60536
  19. 5.10.2026 21:00 yeni plan plan 58016
  20. 5.10.2026 21:00 yeni plan plan 58878
  21. 5.10.2026 21:00 yeni plan plan 59699
  22. 5.10.2026 20:00 yeni plan plan 57120
  23. 5.10.2026 18:00 yeni plan plan 56274
  24. 5.10.2026 17:00 yeni plan plan 55426
  25. 5.10.2026 17:00 yeni plan plan 54605
  26. 5.10.2026 13:00 yeni plan plan 53733
  27. 5.10.2026 13:00 yeni plan plan 52914
  28. 5.10.2026 12:00 yeni plan plan 51387
  29. 5.10.2026 12:00 yeni plan plan 49853
  30. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  31. 5.10.2026 10:00 yeni plan plan 48959
  32. 5.10.2026 10:00 yeni plan plan 48077
  33. 5.10.2026 10:00 yeni plan plan 47274
  34. 5.10.2026 09:00 yeni plan plan 45580
  35. 5.10.2026 09:00 yeni plan plan 43561
  36. 5.10.2026 08:00 yeni plan plan 43219
  37. 5.10.2026 00:00 yeni plan plan 41803
  38. 4.10.2026 13:00 yeni plan plan 39241
  39. 2.10.2026 17:00 yeni plan plan 35789
  40. 2.10.2026 17:00 yeni plan plan 35043
  41. 2.10.2026 16:00 yeni plan plan 34099
  42. 2.10.2026 02:00 yeni plan plan 33654
  43. 2.10.2026 01:00 yeni plan plan 32956
  44. 2.10.2026 00:00 yeni plan plan 31734
  45. 1.10.2026 21:00 yeni plan plan 31077
  46. 1.10.2026 21:00 yeni plan plan 30680
  47. 1.10.2026 20:00 yeni plan plan 30250
  48. 1.10.2026 20:00 yeni plan plan 29600
  49. 1.10.2026 19:00 yeni plan plan 28875
  50. 1.10.2026 19:00 yeni plan plan 28196
  51. 1.10.2026 19:00 yeni plan plan 27525
  52. 30.09.2026 22:00 yeni plan plan 26824
  53. 30.09.2026 22:00 yeni plan plan 26178
  54. 30.09.2026 22:00 yeni plan plan 25498
  55. 30.09.2026 22:00 yeni plan plan 24548
  56. 30.09.2026 22:00 yeni plan plan 24254
  57. 30.09.2026 22:00 yeni plan plan 23078
  58. 30.09.2026 21:00 yeni plan plan 22400
  59. 30.09.2026 21:00 yeni plan plan 21757
  60. 30.09.2026 21:00 yeni plan plan 21107
  61. 30.09.2026 20:00 yeni plan plan 19743
  62. 30.09.2026 15:00 yeni plan plan 17071
  63. 30.09.2026 15:00 yeni plan plan 17723
  64. 30.09.2026 15:00 yeni plan plan 18355
  65. 30.09.2026 11:00 yeni plan plan 15545
  66. 30.09.2026 11:00 yeni plan plan 15212
  67. 30.09.2026 11:00 yeni plan plan 14574
  68. 30.09.2026 10:00 yeni plan plan 13968
  69. 30.09.2026 10:00 yeni plan plan 12872
  70. 30.09.2026 06:00 yeni plan plan 11958
  71. 30.09.2026 06:00 yeni plan plan 11183
  72. 30.09.2026 06:00 yeni plan plan 10620
  73. 30.09.2026 05:00 yeni plan plan 10057
  74. 30.09.2026 03:00 yeni plan plan 9478
  75. 30.09.2026 00:00 yeni plan plan 9021
  76. 29.09.2026 21:00 yeni plan plan 8565
  77. 29.09.2026 21:00 yeni plan plan 8137
  78. 29.09.2026 20:00 yeni plan plan 7657
  79. 28.09.2026 19:00 yeni plan plan 6553
  80. 28.09.2026 19:00 yeni plan plan 6466
  81. 28.09.2026 16:00 yeni plan plan 6060
  82. 28.09.2026 16:00 yeni plan plan 6018

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28520,60,6 1,640
2026-09-291070,60,7 5,029
2026-09-303130,70,7 1,028
2026-10-01490,81,0 14,354
2026-10-02590,60,6 0,727
2026-10-0480,70,7 0,727
2026-10-051930,80,8 0,850
2026-10-07400,70,7 0,727
2026-10-09320,60,6 0,727

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
2682480,50,527 30.09.2026 22:56 en iyi
1062080,50,527 30.09.2026 06:32
856580,50,527 29.09.2026 21:50
813780,50,527 29.09.2026 21:26
1005780,50,527 30.09.2026 05:49
3025080,50,527 1.10.2026 20:58
11958160,50,527 30.09.2026 07:00
2752580,60,627 1.10.2026 19:13
2887580,60,627 1.10.2026 19:31
3365480,60,627 2.10.2026 02:27
1707180,60,627 30.09.2026 15:32
6060240,60,627 28.09.2026 17:03
765780,60,627 29.09.2026 20:13
2960080,60,627 1.10.2026 20:57
4895980,60,627 5.10.2026 10:42
34099110,60,630 2.10.2026 16:25
3295680,60,627 2.10.2026 01:09
7958480,60,627 9.10.2026 14:27
65531040,60,627 29.09.2026 18:42
2617880,60,627 30.09.2026 22:53
7864180,60,627 9.10.2026 13:15
24548160,60,627 30.09.2026 22:38
67290160,60,627 7.10.2026 20:50
3504380,60,627 2.10.2026 17:24
2307880,60,627 30.09.2026 22:15
5460580,60,627 5.10.2026 17:49
8048680,60,627 9.10.2026 14:29
12872160,60,627 30.09.2026 10:52
7076580,60,627 8.10.2026 12:20
11183160,60,627 30.09.2026 06:59
5712080,60,627 5.10.2026 20:19
3107780,60,627 1.10.2026 21:13
2240080,60,627 30.09.2026 21:37
2819680,60,627 1.10.2026 19:19
5801680,60,627 5.10.2026 21:02
7531280,60,627 8.10.2026 17:17
1396880,60,627 30.09.2026 10:56
8252480,60,627 9.10.2026 19:25
5542680,60,627 5.10.2026 17:58
1974380,60,627 30.09.2026 20:42
4727480,60,627 5.10.2026 10:00
5969980,60,627 5.10.2026 21:41
3578980,60,627 2.10.2026 17:32
4356180,70,727 5.10.2026 09:01
7164680,70,727 8.10.2026 12:37
5627480,70,727 5.10.2026 18:28
6303480,70,727 5.10.2026 23:04
1835580,70,727 30.09.2026 15:51
5373380,70,727 5.10.2026 13:58
6888680,70,727 7.10.2026 20:51
2425480,70,727 30.09.2026 22:35
5291480,70,727 5.10.2026 13:19
6053680,70,727 5.10.2026 22:04
61421160,70,727 5.10.2026 22:56
7441380,70,727 8.10.2026 16:38
9021800,70,727 30.09.2026 05:42
6530880,70,727 7.10.2026 13:55
7255880,70,727 8.10.2026 14:01
2549880,70,727 30.09.2026 22:40
2175780,70,727 30.09.2026 21:34
45580160,70,727 5.10.2026 09:49
4807780,70,727 5.10.2026 10:03
1772380,70,727 30.09.2026 15:42
8152980,70,727 9.10.2026 17:45
1521280,70,727 30.09.2026 11:08
31734160,70,727 2.10.2026 00:06
5887880,70,727 5.10.2026 21:38
3924180,70,727 4.10.2026 13:31
15545320,70,727 30.09.2026 11:22
4180380,70,727 5.10.2026 00:27
49853160,80,827 5.10.2026 12:33
51387160,80,827 5.10.2026 12:59
7353880,80,827 8.10.2026 16:34
2110780,80,827 30.09.2026 21:32
7624980,80,827 8.10.2026 18:57
1457481,11,127 30.09.2026 11:02
601811,41,4204 28.09.2026 16:25
646662,31,6152 29.09.2026 13:36
947813,51,6255 30.09.2026 03:30
43219115,615,64.561 5.10.2026 08:59
30680120,110,51.343 1.10.2026 21:13 en kötü

Davranış

Wait kategorileri (QDS)
CPU:9,Buffer IO:6
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 
(@altMin int,@start datetime)UPDATE c SET
            ChangeUtc = pr.ChangeUtc, ChangeEndUtc = pr.ChangeEndUtc, Direction = pr.Direction, DurationRatio = pr.Ratio,
            TotalLoadDeltaMs = pr.LoadMs, Pattern = CASE WHEN pr.Switches >= @altMin THEN 'Alternating' ELSE 'Switch' END,
            AlternatingSwitches = pr.Switches,
            query_hash = q.query_hash, ObjectName = q.ObjectName, SqlText = t.query_sql_text,
            OldQueryPlanHash = po.query_plan_hash, NewQueryPlanHash = pn.query_plan_hash,
            OldIsForced = po.is_forced_plan, NewIsForced = pn.is_forced_plan,
            OldCompat = po.compatibility_level, NewCompat = pn.compatibility_level,
            OldPlanXml = xo.PlanXmlCompressed, NewPlanXml = xn.PlanXmlCompressed,
            Status = CASE WHEN c.Status = 'Unsure' THEN 'Unsure' ELSE 'New' END,
            RulesVersion = NULL, EvidenceUpdatedUtc = @start
        FROM rag.PlanChangeCase AS c
        JOIN #pair AS pr ON pr.CaseID = c.CaseID
        LEFT JOIN perf.QdsQuery AS q ON q.ServerID = c.ServerID AND q.DatabaseName = c.DatabaseName AND q.query_id = c.query_id
        LEFT JOIN perf.QdsQueryText AS t ON t.TextHash = q.TextHash
        LEFT JOIN perf.QdsPlan AS po ON po.ServerID = c.ServerID AND po.DatabaseName = c.DatabaseName AND po.plan_id = c.OldPlanId
        LEFT JOIN perf.QdsPlan AS pn ON pn.ServerID = c.ServerID AND pn.DatabaseName = c.DatabaseName AND pn.plan_id = c.NewPlanId
        LEFT JOIN perf.QdsPlanXml AS xo ON xo.PlanHash = po.PlanHash
        LEFT JOIN perf.QdsPlanXml AS xn ON xn.PlanHash = pn.PlanHash

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.