Pahalı sorgular0x33122C4563C82DC8
Demo modu

Sorgu 0x33122C4563C82DC8

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 1,0 ms
Ort. CPU 1,0 ms
Bekleme payı %0,5
Ort. mantıksal okuma 54
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: 53 çalışma, ort. 0,9 ms29.09.2026: 107 çalışma, ort. 0,9 ms30.09.2026: 349 çalışma, ort. 0,9 ms1.10.2026: 49 çalışma, ort. 0,9 ms2.10.2026: 83 çalışma, ort. 0,9 ms3.10.2026: 1 çalışma, ort. 5,2 ms4.10.2026: 57 çalışma, ort. 2,5 ms5.10.2026: 211 çalışma, ort. 1,0 ms6.10.2026: 50 çalışma, ort. 1,2 ms7.10.2026: 49 çalışma, ort. 1,0 ms9.10.2026: 33 çalışma, ort. 1,2 ms max 349 çalışma max ort. süre 5,2 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 82530
  2. 9.10.2026 17:00 yeni plan plan 81535
  3. 9.10.2026 14:00 yeni plan plan 80956
  4. 9.10.2026 14:00 yeni plan plan 80492
  5. 9.10.2026 14:00 yeni plan plan 79590
  6. 9.10.2026 13:00 yeni plan plan 78647
  7. 8.10.2026 20:00 yeni plan plan 77600
  8. 8.10.2026 19:00 yeni plan plan 77161
  9. 8.10.2026 18:00 yeni plan plan 76255
  10. 8.10.2026 17:00 yeni plan plan 75318
  11. 8.10.2026 16:00 yeni plan plan 74419
  12. 8.10.2026 16:00 yeni plan plan 73544
  13. 8.10.2026 14:00 yeni plan plan 72564
  14. 8.10.2026 12:00 yeni plan plan 71652
  15. 8.10.2026 12:00 yeni plan plan 70771
  16. 8.10.2026 08:00 yeni plan plan 70227
  17. 7.10.2026 20:00 yeni plan plan 69763
  18. 7.10.2026 20:00 yeni plan plan 68892
  19. 7.10.2026 20:00 yeni plan plan 67296
  20. 7.10.2026 20:00 yeni plan plan 66809
  21. 7.10.2026 20:00 yeni plan plan 66358
  22. 7.10.2026 13:00 yeni plan plan 65314
  23. 6.10.2026 03:00 yeni plan plan 64551
  24. 6.10.2026 00:00 yeni plan plan 63947
  25. 5.10.2026 23:00 yeni plan plan 63040
  26. 5.10.2026 22:00 yeni plan plan 61427
  27. 5.10.2026 22:00 yeni plan plan 60542
  28. 5.10.2026 21:00 yeni plan plan 58022
  29. 5.10.2026 21:00 yeni plan plan 58884
  30. 5.10.2026 21:00 yeni plan plan 59705
  31. 5.10.2026 20:00 yeni plan plan 57126
  32. 5.10.2026 18:00 yeni plan plan 56280
  33. 5.10.2026 17:00 yeni plan plan 55432
  34. 5.10.2026 17:00 yeni plan plan 54611
  35. 5.10.2026 13:00 yeni plan plan 53739
  36. 5.10.2026 13:00 yeni plan plan 52920
  37. 5.10.2026 12:00 yeni plan plan 51393
  38. 5.10.2026 12:00 yeni plan plan 49859
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48965
  41. 5.10.2026 10:00 yeni plan plan 48083
  42. 5.10.2026 10:00 yeni plan plan 47280
  43. 5.10.2026 09:00 yeni plan plan 45586
  44. 5.10.2026 09:00 yeni plan plan 44783
  45. 5.10.2026 09:00 yeni plan plan 44351
  46. 5.10.2026 09:00 yeni plan plan 43566
  47. 5.10.2026 08:00 yeni plan plan 43225
  48. 5.10.2026 03:00 yeni plan plan 43036
  49. 5.10.2026 02:00 yeni plan plan 42616
  50. 5.10.2026 00:00 yeni plan plan 41809
  51. 4.10.2026 22:00 yeni plan plan 41395
  52. 4.10.2026 22:00 yeni plan plan 40967
  53. 4.10.2026 21:00 yeni plan plan 40559
  54. 4.10.2026 14:00 yeni plan plan 40399
  55. 4.10.2026 13:00 yeni plan plan 39993
  56. 4.10.2026 13:00 yeni plan plan 39247
  57. 4.10.2026 13:00 yeni plan plan 38857
  58. 4.10.2026 13:00 yeni plan plan 38476
  59. 4.10.2026 10:00 yeni plan plan 37985
  60. 4.10.2026 09:00 yeni plan plan 37811
  61. 4.10.2026 08:00 yeni plan plan 37429
  62. 3.10.2026 03:00 yeni plan plan 36982
  63. 2.10.2026 17:00 yeni plan plan 36510
  64. 2.10.2026 17:00 yeni plan plan 35795
  65. 2.10.2026 17:00 yeni plan plan 35049
  66. 2.10.2026 16:00 yeni plan plan 34105
  67. 2.10.2026 02:00 yeni plan plan 33660
  68. 2.10.2026 01:00 yeni plan plan 32962
  69. 2.10.2026 00:00 yeni plan plan 31740
  70. 1.10.2026 21:00 yeni plan plan 31082
  71. 1.10.2026 21:00 yeni plan plan 30686
  72. 1.10.2026 20:00 yeni plan plan 30256
  73. 1.10.2026 20:00 yeni plan plan 29606
  74. 1.10.2026 19:00 yeni plan plan 28881
  75. 1.10.2026 19:00 yeni plan plan 28202
  76. 1.10.2026 19:00 yeni plan plan 27531
  77. 30.09.2026 22:00 yeni plan plan 26830
  78. 30.09.2026 22:00 yeni plan plan 26184
  79. 30.09.2026 22:00 yeni plan plan 25504
  80. 30.09.2026 22:00 yeni plan plan 24554
  81. 30.09.2026 22:00 yeni plan plan 24260
  82. 30.09.2026 22:00 yeni plan plan 24060
  83. 30.09.2026 22:00 yeni plan plan 23730
  84. 30.09.2026 22:00 yeni plan plan 23084
  85. 30.09.2026 21:00 yeni plan plan 20446
  86. 30.09.2026 21:00 yeni plan plan 20748
  87. 30.09.2026 21:00 yeni plan plan 21113
  88. 30.09.2026 21:00 yeni plan plan 21763
  89. 30.09.2026 21:00 yeni plan plan 22406
  90. 30.09.2026 20:00 yeni plan plan 19749
  91. 30.09.2026 20:00 yeni plan plan 19343
  92. 30.09.2026 19:00 yeni plan plan 19030
  93. 30.09.2026 15:00 yeni plan plan 18361
  94. 30.09.2026 15:00 yeni plan plan 17729
  95. 30.09.2026 15:00 yeni plan plan 17077
  96. 30.09.2026 11:00 yeni plan plan 15551
  97. 30.09.2026 11:00 yeni plan plan 15218
  98. 30.09.2026 11:00 yeni plan plan 14580
  99. 30.09.2026 10:00 yeni plan plan 13974
  100. 30.09.2026 10:00 yeni plan plan 12878
  101. 30.09.2026 06:00 yeni plan plan 11964
  102. 30.09.2026 06:00 yeni plan plan 11189
  103. 30.09.2026 06:00 yeni plan plan 10626
  104. 30.09.2026 05:00 yeni plan plan 10063
  105. 30.09.2026 03:00 yeni plan plan 9483
  106. 30.09.2026 00:00 yeni plan plan 9027
  107. 29.09.2026 21:00 yeni plan plan 8571
  108. 29.09.2026 21:00 yeni plan plan 8143
  109. 29.09.2026 20:00 yeni plan plan 7663
  110. 28.09.2026 19:00 yeni plan plan 6558
  111. 28.09.2026 19:00 yeni plan plan 6472
  112. 28.09.2026 16:00 yeni plan plan 6065
  113. 28.09.2026 16:00 yeni plan plan 6024
  114. 28.09.2026 16:00 yeni plan plan 5992

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,90,9 1,231
2026-09-291070,80,9 1,426
2026-09-303490,90,9 1,134
2026-10-01490,90,9 4,033
2026-10-02830,90,9 1,039
2026-10-0314,95,2 5,2745
2026-10-04572,52,5 8,1275
2026-10-052111,01,0 10,142
2026-10-06501,21,2 10,179
2026-10-07491,01,0 8,261
2026-10-09331,21,2 10,380

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
857180,80,824 29.09.2026 21:50 en iyi
2308480,80,835 30.09.2026 22:15
1062680,80,836 30.09.2026 06:32
5712680,80,824 5.10.2026 20:19
1903080,80,824 30.09.2026 19:36
6635880,80,823 7.10.2026 20:12
5888480,80,823 5.10.2026 21:38
2753180,80,824 1.10.2026 19:13
7165280,80,824 8.10.2026 12:37
1772980,80,825 30.09.2026 15:42
8253080,80,823 9.10.2026 19:25
814380,80,825 29.09.2026 21:26
7864780,80,824 9.10.2026 13:15
2176380,80,825 30.09.2026 21:34
4261680,80,824 5.10.2026 02:58
7716180,80,824 8.10.2026 19:59
5543280,80,824 5.10.2026 17:58
7531880,80,825 8.10.2026 17:17
1006380,80,835 30.09.2026 05:49
6304080,80,835 5.10.2026 23:04
3366080,80,826 2.10.2026 02:27
3847680,80,823 4.10.2026 13:29
7441980,80,824 8.10.2026 16:38
2683080,80,824 30.09.2026 22:56
5802280,80,824 5.10.2026 21:02
5628080,80,823 5.10.2026 18:28
1521880,80,823 30.09.2026 11:08
3579580,80,836 2.10.2026 17:32
6889280,80,836 7.10.2026 20:51
3108280,80,825 1.10.2026 21:13
6976380,80,824 7.10.2026 20:53
67296160,80,830 7.10.2026 20:50
1397480,80,854 30.09.2026 10:56
2550480,80,824 30.09.2026 22:40
11964160,80,850 30.09.2026 07:00
7959080,80,824 9.10.2026 14:27
3504980,80,855 2.10.2026 17:24
2240680,80,835 30.09.2026 21:37
3296280,80,835 2.10.2026 01:09
5461180,80,837 5.10.2026 17:49
11189160,80,841 30.09.2026 06:59
4896580,80,824 5.10.2026 10:42
63947480,80,826 6.10.2026 05:50
2426080,80,834 30.09.2026 22:35
6065240,80,824 28.09.2026 17:03
5292080,80,861 5.10.2026 13:19
24554160,80,829 30.09.2026 22:38
12878160,80,855 30.09.2026 10:52
2888180,80,823 1.10.2026 19:31
36510240,80,842 2.10.2026 18:17
23730160,80,824 30.09.2026 22:19
4808380,80,823 5.10.2026 10:03
34105110,80,846 2.10.2026 16:25
1974980,80,824 30.09.2026 20:42
766380,80,824 29.09.2026 20:13
61427160,90,930 5.10.2026 22:56
8153580,90,924 9.10.2026 17:45
1707780,90,935 30.09.2026 15:32
2820280,90,924 1.10.2026 19:19
4180980,90,923 5.10.2026 00:27
4728080,90,923 5.10.2026 10:00
1836180,90,935 30.09.2026 15:51
6054280,90,923 5.10.2026 22:04
1458080,90,944 30.09.2026 11:02
45586160,90,923 5.10.2026 09:49
9027800,90,932 30.09.2026 05:42
3999380,90,923 4.10.2026 13:45
7077180,90,923 8.10.2026 12:20
49859160,90,930 5.10.2026 12:33
65581040,90,926 29.09.2026 18:42
3025680,90,926 1.10.2026 20:58
3924780,90,936 4.10.2026 13:31
5970580,90,923 5.10.2026 21:41
5373980,90,950 5.10.2026 13:58
4356680,90,936 5.10.2026 09:01
51393160,90,930 5.10.2026 12:59
4096780,90,924 4.10.2026 22:07
15551321,01,031 30.09.2026 11:22
2960681,01,025 1.10.2026 20:57
8049281,01,025 9.10.2026 14:29
2618481,01,023 30.09.2026 22:53
647261,01,055 29.09.2026 13:36
6531481,01,025 7.10.2026 13:55
7256481,01,024 8.10.2026 14:01
2044681,01,044 30.09.2026 21:24
3742981,01,024 4.10.2026 08:55
4435181,01,024 5.10.2026 09:09
2074811,11,173 30.09.2026 21:30
31740161,11,132 2.10.2026 00:06
7625581,11,124 8.10.2026 18:57
948311,11,178 30.09.2026 03:30
1934321,11,174 30.09.2026 20:30
599211,21,2100 28.09.2026 16:24
2406011,21,265 30.09.2026 22:30
602411,21,284 28.09.2026 16:25
2111381,21,234 30.09.2026 21:32
7354481,41,436 8.10.2026 16:34
3068615,45,0456 1.10.2026 21:13
3885715,45,4831 4.10.2026 13:30
4303615,45,4962 5.10.2026 03:30
3781115,45,4817 4.10.2026 09:30
3798535,85,8825 4.10.2026 12:30
4039975,95,9885 4.10.2026 20:30
4139526,86,8920 4.10.2026 23:30
4055916,86,8903 4.10.2026 21:30
3698237,17,0773 4.10.2026 08:30
6455129,39,11.350 6.10.2026 22:15
66809110,610,41.644 7.10.2026 20:40
43225111,311,3974 5.10.2026 08:59
80956112,612,61.875 9.10.2026 14:52
44783114,814,8990 5.10.2026 09:30
77600123,915,31.824 8.10.2026 20:03
70227132,023,71.696 8.10.2026 08:30 en kötü

Davranış

Wait kategorileri (QDS)
CPU:12,Buffer IO:8,Memory: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 
INSERT rag.PlanChangeMetric (CaseID, PlanRole, Executions, Aborted, Failed, AvgDurationMs, MaxDurationMs, StdevDurationMs,
               AvgCpuMs, MaxCpuMs, AvgLogicalReads, MaxLogicalReads, AvgPhysicalReads, AvgWrites, AvgMemoryKb, AvgTempdbKb, AvgDop,
               AvgRows, MaxRows, FirstUtc, LastUtc)
        SELECT r.CaseID, r.PlanRole, p.Execs, p.Aborted, p.Failed,
               p.SumDur / p.Execs / 1000.0, p.MaxDur / 1000.0,
               SQRT(CASE WHEN p.SumSq / p.Execs - SQUARE(p.SumDur / p.Execs) > 0 THEN p.SumSq / p.Execs - SQUARE(p.SumDur / p.Execs) ELSE 0 END) / 1000.0,
               p.SumCpu / p.Execs / 1000.0, p.MaxCpu / 1000.0, p.SumReads / p.Execs, p.MaxReads, p.SumPhys / p.Execs, p.SumWrites / p.Execs,
               p.SumMem / p.Execs * 8, p.SumTempdb / p.Execs * 8, p.SumDop / p.Execs, p.SumRows / p.Execs, p.MaxRows, p.FirstUtc, p.LastUtc
        FROM #role AS r
        JOIN #ps AS p ON p.ServerID = r.ServerID AND p.DatabaseName = r.DatabaseName AND p.plan_id = r.plan_id

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.