Pahalı sorgular0x5C5EEFD77D5E06D7
Demo modu

Sorgu 0x5C5EEFD77D5E06D7

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

Ort. süre 128,8 ms
Ort. CPU 118,7 ms
Bekleme payı %7,8
Ort. mantıksal okuma 171
En büyük bellek izni 10 MB

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

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28532,32,3 8,526
2026-09-291072,02,0 8,519
2026-09-303491,91,9 11,618
2026-10-014941,955,0 1.830,698
2026-10-02831,81,8 2,015
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
2681781,51,515 30.09.2026 22:56 en iyi
855881,51,515 29.09.2026 21:50
3578281,61,615 2.10.2026 17:32
3364781,61,615 2.10.2026 02:27
813081,61,615 29.09.2026 21:26
3024381,61,615 1.10.2026 20:58
7957781,61,615 9.10.2026 14:27
1005081,61,615 30.09.2026 05:49
6634581,61,615 7.10.2026 20:12
5459881,61,615 5.10.2026 17:49
2307181,61,615 30.09.2026 22:15
5800981,61,615 5.10.2026 21:02
2886881,61,615 1.10.2026 19:31
1771681,71,715 30.09.2026 15:42
12865161,71,615 30.09.2026 10:52
2959381,71,715 1.10.2026 20:57
1706481,71,715 30.09.2026 15:32
2751881,71,715 1.10.2026 19:13
3503681,71,715 2.10.2026 17:24
11951161,71,715 30.09.2026 07:00
1456781,71,715 30.09.2026 11:02
5626781,71,715 5.10.2026 18:28
3107281,71,715 1.10.2026 21:13
5969281,71,715 5.10.2026 21:41
6530181,71,715 7.10.2026 13:55
2424781,71,715 30.09.2026 22:35
1834881,71,715 30.09.2026 15:51
7075881,71,715 8.10.2026 12:20
6052981,71,715 5.10.2026 22:04
7530581,71,715 8.10.2026 17:17
11176161,71,715 30.09.2026 06:59
4895281,71,715 5.10.2026 10:42
6975081,71,715 7.10.2026 20:53
2617181,71,715 30.09.2026 22:53
2818981,71,715 1.10.2026 19:19
5711381,71,715 5.10.2026 20:19
6887981,81,815 7.10.2026 20:51
6055241,81,815 28.09.2026 17:03
24541161,81,815 30.09.2026 22:38
3846381,81,815 4.10.2026 13:29
4095481,81,815 4.10.2026 22:07
5290781,81,815 5.10.2026 13:19
2239381,81,815 30.09.2026 21:37
6302781,81,815 5.10.2026 23:04
1973681,81,815 30.09.2026 20:42
67283161,81,815 7.10.2026 20:50
1901781,81,815 30.09.2026 19:36
34092111,81,815 2.10.2026 16:25
61414161,81,815 5.10.2026 22:56
1520581,81,815 30.09.2026 11:08
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
23717161,81,815 30.09.2026 22:19
2175081,81,815 30.09.2026 21:34
4807081,81,815 5.10.2026 10:03
8251781,81,815 9.10.2026 19:25
65481041,81,815 29.09.2026 18:42
49846161,81,815 5.10.2026 12:33
4433881,81,815 5.10.2026 09:09
4726781,81,815 5.10.2026 10:00
1396181,81,815 30.09.2026 10:56
36497241,81,815 2.10.2026 18:17
8152281,81,815 9.10.2026 17:45
5372681,81,815 5.10.2026 13:58
765081,81,815 29.09.2026 20:13
5541981,91,915 5.10.2026 17:58
3923481,91,915 4.10.2026 13:31
9014801,91,915 30.09.2026 05:42
15538321,91,915 30.09.2026 11:22
45573161,91,915 5.10.2026 09:49
1061381,91,715 30.09.2026 06:32
2549181,91,915 30.09.2026 22:40
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
31727162,02,015 2.10.2026 00:06
3294982,02,015 2.10.2026 01:09
7255182,02,015 8.10.2026 14:01
2110082,02,015 30.09.2026 21:32
3741682,12,115 4.10.2026 08:55
51380162,12,115 5.10.2026 12:59
2043382,22,215 30.09.2026 21:24
7353182,72,715 8.10.2026 16:34
645967,57,5147 29.09.2026 13:36
597917,87,8136 28.09.2026 16:24
601118,98,9136 28.09.2026 16:25
24050110,110,1222 30.09.2026 22:30
20738111,411,4241 30.09.2026 21:30
9473112,011,9240 30.09.2026 03:30
19333213,213,2242 30.09.2026 20:30
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
3066912.614,41.971,34.078 1.10.2026 21:13
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:7192,Memory:56
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.