Pahalı sorgular0x5C5EEFD77D5E06D7
Demo modu

Sorgu 0x5C5EEFD77D5E06D7

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

Ort. süre 325,1 ms▲ %5312,7
Ort. CPU 300,5 ms▲ %5910,7
Bekleme payı %7,6▼ %54,9
Ort. mantıksal okuma 405▲ %1565,7
En büyük bellek izni 10 MB

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

3.10.2026: 1 çalışma, ort. 2.117,0 ms4.10.2026: 57 çalışma, ort. 847,2 ms5.10.2026: 211 çalışma, ort. 67,1 ms6.10.2026: 50 çalışma, ort. 307,8 ms7.10.2026: 49 çalışma, ort. 469,9 ms9.10.2026: 33 çalışma, ort. 829,9 ms max 211 çalışma max ort. süre 2.117,0 ms 3.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 81522
  2. 9.10.2026 14:00 yeni plan plan 80938
  3. 9.10.2026 14:00 yeni plan plan 80479
  4. 9.10.2026 14:00 yeni plan plan 79577
  5. 9.10.2026 13:00 yeni plan plan 78634
  6. 8.10.2026 20:00 yeni plan plan 77590
  7. 8.10.2026 19:00 yeni plan plan 77148
  8. 8.10.2026 18:00 yeni plan plan 76242
  9. 8.10.2026 17:00 yeni plan plan 75305
  10. 8.10.2026 16:00 yeni plan plan 74406
  11. 8.10.2026 16:00 yeni plan plan 73531
  12. 8.10.2026 14:00 yeni plan plan 72551
  13. 8.10.2026 12:00 yeni plan plan 71639
  14. 8.10.2026 12:00 yeni plan plan 70758
  15. 8.10.2026 08:00 yeni plan plan 70211
  16. 7.10.2026 20:00 yeni plan plan 69750
  17. 7.10.2026 20:00 yeni plan plan 68879
  18. 7.10.2026 20:00 yeni plan plan 67283
  19. 7.10.2026 20:00 yeni plan plan 66788
  20. 7.10.2026 20:00 yeni plan plan 66345
  21. 7.10.2026 13:00 yeni plan plan 65301
  22. 6.10.2026 03:00 yeni plan plan 64541
  23. 6.10.2026 00:00 yeni plan plan 63934
  24. 5.10.2026 23:00 yeni plan plan 63027
  25. 5.10.2026 22:00 yeni plan plan 61414
  26. 5.10.2026 22:00 yeni plan plan 60529
  27. 5.10.2026 21:00 yeni plan plan 58009
  28. 5.10.2026 21:00 yeni plan plan 58871
  29. 5.10.2026 21:00 yeni plan plan 59692
  30. 5.10.2026 20:00 yeni plan plan 57113
  31. 5.10.2026 18:00 yeni plan plan 56267
  32. 5.10.2026 17:00 yeni plan plan 55419
  33. 5.10.2026 17:00 yeni plan plan 54598
  34. 5.10.2026 13:00 yeni plan plan 53726
  35. 5.10.2026 13:00 yeni plan plan 52907
  36. 5.10.2026 12:00 yeni plan plan 51380
  37. 5.10.2026 12:00 yeni plan plan 49846
  38. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  39. 5.10.2026 10:00 yeni plan plan 48952
  40. 5.10.2026 10:00 yeni plan plan 48070
  41. 5.10.2026 10:00 yeni plan plan 47267
  42. 5.10.2026 09:00 yeni plan plan 45573
  43. 5.10.2026 09:00 yeni plan plan 44773
  44. 5.10.2026 09:00 yeni plan plan 44338
  45. 5.10.2026 09:00 yeni plan plan 43556
  46. 5.10.2026 08:00 yeni plan plan 43212
  47. 5.10.2026 03:00 yeni plan plan 43026
  48. 5.10.2026 02:00 yeni plan plan 42603
  49. 5.10.2026 00:00 yeni plan plan 41796
  50. 4.10.2026 22:00 yeni plan plan 41385
  51. 4.10.2026 22:00 yeni plan plan 40954
  52. 4.10.2026 21:00 yeni plan plan 40546
  53. 4.10.2026 14:00 yeni plan plan 40389
  54. 4.10.2026 13:00 yeni plan plan 39980
  55. 4.10.2026 13:00 yeni plan plan 39234
  56. 4.10.2026 13:00 yeni plan plan 38847
  57. 4.10.2026 13:00 yeni plan plan 38463
  58. 4.10.2026 10:00 yeni plan plan 37972
  59. 4.10.2026 09:00 yeni plan plan 37801
  60. 4.10.2026 08:00 yeni plan plan 37416
  61. 3.10.2026 03:00 yeni plan plan 36972
  62. 2.10.2026 17:00 yeni plan plan 36497
  63. 2.10.2026 17:00 yeni plan plan 35782
  64. 2.10.2026 17:00 yeni plan plan 35036
  65. 2.10.2026 16:00 yeni plan plan 34092
  66. 2.10.2026 02:00 yeni plan plan 33647
  67. 2.10.2026 01:00 yeni plan plan 32949
  68. 2.10.2026 00:00 yeni plan plan 31727
  69. 1.10.2026 21:00 yeni plan plan 31072
  70. 1.10.2026 21:00 yeni plan plan 30669
  71. 1.10.2026 20:00 yeni plan plan 30243
  72. 1.10.2026 20:00 yeni plan plan 29593
  73. 1.10.2026 19:00 yeni plan plan 28868
  74. 1.10.2026 19:00 yeni plan plan 28189
  75. 1.10.2026 19:00 yeni plan plan 27518
  76. 30.09.2026 22:00 yeni plan plan 26817
  77. 30.09.2026 22:00 yeni plan plan 26171
  78. 30.09.2026 22:00 yeni plan plan 25491
  79. 30.09.2026 22:00 yeni plan plan 24541
  80. 30.09.2026 22:00 yeni plan plan 24247
  81. 30.09.2026 22:00 yeni plan plan 24050
  82. 30.09.2026 22:00 yeni plan plan 23717
  83. 30.09.2026 22:00 yeni plan plan 23071
  84. 30.09.2026 21:00 yeni plan plan 20433
  85. 30.09.2026 21:00 yeni plan plan 20738
  86. 30.09.2026 21:00 yeni plan plan 21100
  87. 30.09.2026 21:00 yeni plan plan 21750
  88. 30.09.2026 21:00 yeni plan plan 22393
  89. 30.09.2026 20:00 yeni plan plan 19736
  90. 30.09.2026 20:00 yeni plan plan 19333
  91. 30.09.2026 19:00 yeni plan plan 19017
  92. 30.09.2026 15:00 yeni plan plan 18348
  93. 30.09.2026 15:00 yeni plan plan 17716
  94. 30.09.2026 15:00 yeni plan plan 17064
  95. 30.09.2026 11:00 yeni plan plan 15538
  96. 30.09.2026 11:00 yeni plan plan 15205
  97. 30.09.2026 11:00 yeni plan plan 14567
  98. 30.09.2026 10:00 yeni plan plan 13961
  99. 30.09.2026 10:00 yeni plan plan 12865
  100. 30.09.2026 06:00 yeni plan plan 11951
  101. 30.09.2026 06:00 yeni plan plan 11176
  102. 30.09.2026 06:00 yeni plan plan 10613
  103. 30.09.2026 05:00 yeni plan plan 10050
  104. 30.09.2026 03:00 yeni plan plan 9473
  105. 30.09.2026 00:00 yeni plan plan 9014
  106. 29.09.2026 21:00 yeni plan plan 8558
  107. 29.09.2026 21:00 yeni plan plan 8130
  108. 29.09.2026 20:00 yeni plan plan 7650
  109. 28.09.2026 19:00 yeni plan plan 6548
  110. 28.09.2026 19:00 yeni plan plan 6459
  111. 28.09.2026 16:00 yeni plan plan 6055
  112. 28.09.2026 16:00 yeni plan plan 6011
  113. 28.09.2026 16:00 yeni plan plan 5979

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0312.117,02.117,0 2.117,04.933
2026-10-0457847,1847,2 3.598,61.669
2026-10-0521166,967,1 3.752,1105
2026-10-0650307,5307,8 8.175,7373
2026-10-0749371,5469,9 17.205,6210
2026-10-0933679,4829,9 21.862,0342

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
7957781,61,615 9.10.2026 14:27 en iyi
6634581,61,615 7.10.2026 20:12
5459881,61,615 5.10.2026 17:49
5800981,61,615 5.10.2026 21:02
5626781,71,715 5.10.2026 18:28
5969281,71,715 5.10.2026 21:41
6530181,71,715 7.10.2026 13:55
7075881,71,715 8.10.2026 12:20
6052981,71,715 5.10.2026 22:04
7530581,71,715 8.10.2026 17:17
4895281,71,715 5.10.2026 10:42
6975081,71,715 7.10.2026 20:53
5711381,71,715 5.10.2026 20:19
6887981,81,815 7.10.2026 20:51
3846381,81,815 4.10.2026 13:29
4095481,81,815 4.10.2026 22:07
5290781,81,815 5.10.2026 13:19
6302781,81,815 5.10.2026 23:04
67283161,81,815 7.10.2026 20:50
61414161,81,815 5.10.2026 22:56
7163981,81,815 8.10.2026 12:37
63934481,81,815 6.10.2026 05:50
3998081,81,815 4.10.2026 13:45
5887181,81,815 5.10.2026 21:38
4260381,81,815 5.10.2026 02:58
7440681,81,815 8.10.2026 16:38
4807081,81,815 5.10.2026 10:03
49846161,81,815 5.10.2026 12:33
4433881,81,815 5.10.2026 09:09
4726781,81,815 5.10.2026 10:00
8152281,81,815 9.10.2026 17:45
5372681,81,815 5.10.2026 13:58
5541981,91,915 5.10.2026 17:58
3923481,91,915 4.10.2026 13:31
45573161,91,915 5.10.2026 09:49
8047981,91,915 9.10.2026 14:29
7714881,91,915 8.10.2026 19:59
4355681,91,915 5.10.2026 09:01
4179681,91,915 5.10.2026 00:27
7624282,02,015 8.10.2026 18:57
7863482,02,015 9.10.2026 13:15
7255182,02,015 8.10.2026 14:01
3741682,12,115 4.10.2026 08:55
51380162,12,115 5.10.2026 12:59
7353182,72,715 8.10.2026 16:34
3697232.276,62.276,55.065 4.10.2026 08:30
3797232.509,32.508,95.333 4.10.2026 12:30
3884712.583,82.583,75.401 4.10.2026 13:30
3780112.731,72.731,55.236 4.10.2026 09:30
4038972.913,52.913,35.691 4.10.2026 20:30
4138523.272,43.272,25.980 4.10.2026 23:30
4302613.386,23.354,76.317 5.10.2026 03:30
4054613.722,03.721,55.853 4.10.2026 21:30
4477313.843,63.838,96.458 5.10.2026 09:30
4321216.551,06.550,66.391 5.10.2026 08:59
6454127.651,67.643,88.963 6.10.2026 22:15
70211113.951,113.935,09.842 8.10.2026 08:30
66788122.940,218.118,99.609 7.10.2026 20:40
80938127.327,022.361,510.826 9.10.2026 14:52
77590127.772,623.023,410.718 8.10.2026 20:03 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:8420,CPU:6545,Memory:48
Session'da görülen wait'ler
PAGEIOLATCH_SH:1
Başka oturumları bloklama
0
En büyük memory grant
10.664 KB

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 — 115: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)WITH iv AS (
            SELECT pr.ServerID, pr.DatabaseName, pr.query_id, pr.OldPlanId, pr.NewPlanId, rs.IntervalStartUtc,
                   SUM(CASE WHEN rs.plan_id = pr.NewPlanId THEN rs.count_executions ELSE 0 END) AS NewCnt,
                   SUM(CASE WHEN rs.plan_id = pr.OldPlanId THEN rs.count_executions ELSE 0 END) AS OldCnt
            FROM #pair AS pr
            JOIN perf.QdsRuntimeStats AS rs ON rs.ServerID = pr.ServerID AND rs.DatabaseName = pr.DatabaseName
                 AND rs.plan_id IN (pr.OldPlanId, pr.NewPlanId) AND rs.execution_type = 0
                 AND rs.IntervalStartUtc >= @from AND rs.IntervalStartUtc < @asOf
            GROUP BY pr.ServerID, pr.DatabaseName, pr.query_id, pr.OldPlanId, pr.NewPlanId, rs.IntervalStartUtc),
        d AS (
            SELECT *, CASE WHEN NewCnt > OldCnt THEN 1 ELSE 0 END AS Dom FROM iv WHERE NewCnt <> OldCnt),
        s AS (
            SELECT ServerID, DatabaseName, query_id, OldPlanId, NewPlanId,
                   CASE WHEN Dom <> LAG(Dom) OVER (PARTITION BY ServerID, DatabaseName, query_id, OldPlanId, NewPlanId ORDER BY IntervalStartUtc)
                        THEN 1 ELSE 0 END AS Sw
            FROM d)
        UPDATE pr SET Switches = x.n
        FROM #pair AS pr
        JOIN (SELECT ServerID, DatabaseName, query_id, OldPlanId, NewPlanId, SUM(Sw) AS n FROM s
              GROUP BY ServerID, DatabaseName, query_id, OldPlanId, NewPlanId) AS x
          ON x.ServerID = pr.ServerID AND x.DatabaseName = pr.DatabaseName AND x.query_id = pr.query_id
         AND x.OldPlanId = pr.OldPlanId AND x.NewPlanId = pr.NewPlanId

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.