Pahalı sorgular0xA6D88CA099D92DB7
Demo modu

Sorgu 0xA6D88CA099D92DB7

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 8,7 ms
Ort. CPU 8,4 ms
Bekleme payı %3,7
Ort. mantıksal okuma 814
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. 12,7 ms29.09.2026: 107 çalışma, ort. 2,2 ms30.09.2026: 349 çalışma, ort. 2,4 ms1.10.2026: 49 çalışma, ort. 4,5 ms2.10.2026: 83 çalışma, ort. 1,7 ms3.10.2026: 1 çalışma, ort. 144,7 ms4.10.2026: 57 çalışma, ort. 57,2 ms5.10.2026: 211 çalışma, ort. 5,6 ms6.10.2026: 50 çalışma, ort. 19,4 ms7.10.2026: 49 çalışma, ort. 12,7 ms9.10.2026: 33 çalışma, ort. 23,5 ms max 349 çalışma max ort. süre 144,7 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 82531
  2. 9.10.2026 17:00 yeni plan plan 81536
  3. 9.10.2026 14:00 yeni plan plan 80957
  4. 9.10.2026 14:00 yeni plan plan 80493
  5. 9.10.2026 14:00 yeni plan plan 79591
  6. 9.10.2026 13:00 yeni plan plan 78648
  7. 8.10.2026 20:00 yeni plan plan 77601
  8. 8.10.2026 19:00 yeni plan plan 77162
  9. 8.10.2026 18:00 yeni plan plan 76256
  10. 8.10.2026 17:00 yeni plan plan 75319
  11. 8.10.2026 16:00 yeni plan plan 74420
  12. 8.10.2026 16:00 yeni plan plan 73545
  13. 8.10.2026 14:00 yeni plan plan 72565
  14. 8.10.2026 12:00 yeni plan plan 71653
  15. 8.10.2026 12:00 yeni plan plan 70772
  16. 8.10.2026 08:00 yeni plan plan 70228
  17. 7.10.2026 20:00 yeni plan plan 69764
  18. 7.10.2026 20:00 yeni plan plan 68893
  19. 7.10.2026 20:00 yeni plan plan 67297
  20. 7.10.2026 20:00 yeni plan plan 66810
  21. 7.10.2026 20:00 yeni plan plan 66359
  22. 7.10.2026 13:00 yeni plan plan 65315
  23. 6.10.2026 03:00 yeni plan plan 64552
  24. 6.10.2026 00:00 yeni plan plan 63948
  25. 5.10.2026 23:00 yeni plan plan 63041
  26. 5.10.2026 22:00 yeni plan plan 61428
  27. 5.10.2026 22:00 yeni plan plan 60543
  28. 5.10.2026 21:00 yeni plan plan 58023
  29. 5.10.2026 21:00 yeni plan plan 58885
  30. 5.10.2026 21:00 yeni plan plan 59706
  31. 5.10.2026 20:00 yeni plan plan 57127
  32. 5.10.2026 18:00 yeni plan plan 56281
  33. 5.10.2026 17:00 yeni plan plan 55433
  34. 5.10.2026 17:00 yeni plan plan 54612
  35. 5.10.2026 13:00 yeni plan plan 53740
  36. 5.10.2026 13:00 yeni plan plan 52921
  37. 5.10.2026 12:00 yeni plan plan 51394
  38. 5.10.2026 12:00 yeni plan plan 49860
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48966
  41. 5.10.2026 10:00 yeni plan plan 48084
  42. 5.10.2026 10:00 yeni plan plan 47281
  43. 5.10.2026 09:00 yeni plan plan 45587
  44. 5.10.2026 09:00 yeni plan plan 44784
  45. 5.10.2026 09:00 yeni plan plan 44352
  46. 5.10.2026 09:00 yeni plan plan 43567
  47. 5.10.2026 08:00 yeni plan plan 43226
  48. 5.10.2026 03:00 yeni plan plan 43037
  49. 5.10.2026 02:00 yeni plan plan 42617
  50. 5.10.2026 00:00 yeni plan plan 41810
  51. 4.10.2026 22:00 yeni plan plan 41396
  52. 4.10.2026 22:00 yeni plan plan 40968
  53. 4.10.2026 21:00 yeni plan plan 40560
  54. 4.10.2026 20:00 yeni plan plan 40438
  55. 4.10.2026 14:00 yeni plan plan 40400
  56. 4.10.2026 13:00 yeni plan plan 39994
  57. 4.10.2026 13:00 yeni plan plan 39248
  58. 4.10.2026 13:00 yeni plan plan 38858
  59. 4.10.2026 13:00 yeni plan plan 38477
  60. 4.10.2026 10:00 yeni plan plan 37986
  61. 4.10.2026 09:00 yeni plan plan 37812
  62. 4.10.2026 08:00 yeni plan plan 37430
  63. 3.10.2026 03:00 yeni plan plan 36983
  64. 2.10.2026 17:00 yeni plan plan 36511
  65. 2.10.2026 17:00 yeni plan plan 35796
  66. 2.10.2026 17:00 yeni plan plan 35050
  67. 2.10.2026 16:00 yeni plan plan 34106
  68. 2.10.2026 02:00 yeni plan plan 33661
  69. 2.10.2026 01:00 yeni plan plan 32963
  70. 2.10.2026 00:00 yeni plan plan 31741
  71. 1.10.2026 21:00 yeni plan plan 31083
  72. 1.10.2026 21:00 yeni plan plan 30687
  73. 1.10.2026 20:00 yeni plan plan 30257
  74. 1.10.2026 20:00 yeni plan plan 29607
  75. 1.10.2026 19:00 yeni plan plan 28882
  76. 1.10.2026 19:00 yeni plan plan 28203
  77. 1.10.2026 19:00 yeni plan plan 27532
  78. 30.09.2026 22:00 yeni plan plan 26831
  79. 30.09.2026 22:00 yeni plan plan 26185
  80. 30.09.2026 22:00 yeni plan plan 25505
  81. 30.09.2026 22:00 yeni plan plan 24555
  82. 30.09.2026 22:00 yeni plan plan 24261
  83. 30.09.2026 22:00 yeni plan plan 24061
  84. 30.09.2026 22:00 yeni plan plan 23731
  85. 30.09.2026 22:00 yeni plan plan 23085
  86. 30.09.2026 21:00 yeni plan plan 20447
  87. 30.09.2026 21:00 yeni plan plan 20749
  88. 30.09.2026 21:00 yeni plan plan 21114
  89. 30.09.2026 21:00 yeni plan plan 21764
  90. 30.09.2026 21:00 yeni plan plan 22407
  91. 30.09.2026 20:00 yeni plan plan 19750
  92. 30.09.2026 20:00 yeni plan plan 19344
  93. 30.09.2026 19:00 yeni plan plan 19031
  94. 30.09.2026 15:00 yeni plan plan 18362
  95. 30.09.2026 15:00 yeni plan plan 17730
  96. 30.09.2026 15:00 yeni plan plan 17078
  97. 30.09.2026 11:00 yeni plan plan 15552
  98. 30.09.2026 11:00 yeni plan plan 15219
  99. 30.09.2026 11:00 yeni plan plan 14581
  100. 30.09.2026 10:00 yeni plan plan 13975
  101. 30.09.2026 10:00 yeni plan plan 12879
  102. 30.09.2026 06:00 yeni plan plan 11965
  103. 30.09.2026 06:00 yeni plan plan 11190
  104. 30.09.2026 06:00 yeni plan plan 10627
  105. 30.09.2026 05:00 yeni plan plan 10064
  106. 30.09.2026 03:00 yeni plan plan 9484
  107. 30.09.2026 00:00 yeni plan plan 9028
  108. 29.09.2026 21:00 yeni plan plan 8572
  109. 29.09.2026 21:00 yeni plan plan 8144
  110. 29.09.2026 20:00 yeni plan plan 7664
  111. 29.09.2026 13:00 yeni plan plan 7027
  112. 29.09.2026 03:00 yeni plan plan 6769
  113. 28.09.2026 22:00 yeni plan plan 6684
  114. 28.09.2026 19:00 yeni plan plan 6559
  115. 28.09.2026 19:00 yeni plan plan 6473
  116. 28.09.2026 16:00 yeni plan plan 6066
  117. 28.09.2026 16:00 yeni plan plan 6025
  118. 28.09.2026 16:00 yeni plan plan 5993

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-285312,712,7 182,4917
2026-09-291072,22,2 28,8153
2026-09-303492,42,4 51,5188
2026-10-01494,14,5 101,7372
2026-10-02831,71,7 1,8113
2026-10-031140,3144,7 144,723.128
2026-10-045755,857,2 219,27.810
2026-10-052115,55,6 262,7390
2026-10-065018,519,4 527,71.222
2026-10-074911,112,7 408,2770
2026-10-093321,223,5 580,11.220

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
676910,50,54 29.09.2026 03:30 en iyi
1006481,51,5103 30.09.2026 05:49
1062781,51,5114 30.09.2026 06:32
814481,51,5114 29.09.2026 21:26
5628181,51,5102 5.10.2026 18:28
3366181,51,5105 2.10.2026 02:27
5712781,51,5102 5.10.2026 20:19
11190161,51,5103 30.09.2026 06:59
2960781,51,5124 1.10.2026 20:57
5970681,51,5115 5.10.2026 21:41
67297161,51,5103 7.10.2026 20:50
1903181,51,5104 30.09.2026 19:36
8049381,51,5115 9.10.2026 14:29
7716281,51,5117 8.10.2026 19:59
2683181,51,5113 30.09.2026 22:56
11965161,51,5103 30.09.2026 07:00
1397581,51,5104 30.09.2026 10:56
7864881,51,5104 9.10.2026 13:15
4728181,51,5116 5.10.2026 10:00
2308581,51,5104 30.09.2026 22:15
857281,51,5104 29.09.2026 21:50
3579681,51,5116 2.10.2026 17:32
2753281,51,5114 1.10.2026 19:13
1773081,61,6105 30.09.2026 15:42
7077281,61,6117 8.10.2026 12:20
3108381,61,6103 1.10.2026 21:13
2426181,61,6105 30.09.2026 22:35
2550581,61,6113 30.09.2026 22:40
1836281,61,6104 30.09.2026 15:51
1707881,61,6106 30.09.2026 15:32
6635981,61,6104 7.10.2026 20:12
2176481,61,6104 30.09.2026 21:34
2820381,61,6126 1.10.2026 19:19
5292181,61,6104 5.10.2026 13:19
2240781,61,6104 30.09.2026 21:37
4261781,61,6104 5.10.2026 02:58
3505081,61,6104 2.10.2026 17:24
3847781,61,6128 4.10.2026 13:29
8153681,61,6103 9.10.2026 17:45
7256581,61,6104 8.10.2026 14:01
7165381,61,6103 8.10.2026 12:37
23731161,61,6110 30.09.2026 22:19
8253181,61,6104 9.10.2026 19:25
4181081,61,6116 5.10.2026 00:27
6054381,61,6115 5.10.2026 22:04
12879161,61,6104 30.09.2026 10:52
4356781,61,6128 5.10.2026 09:01
4896681,61,6103 5.10.2026 10:42
6304181,61,6104 5.10.2026 23:04
7959181,61,6103 9.10.2026 14:27
5543381,61,6116 5.10.2026 17:58
6889381,61,6104 7.10.2026 20:51
7531981,61,6128 8.10.2026 17:17
45587161,61,6103 5.10.2026 09:49
3296381,61,6114 2.10.2026 01:09
5802381,61,6103 5.10.2026 21:02
1458181,71,7104 30.09.2026 11:02
1521981,71,7135 30.09.2026 11:08
63948481,71,7105 6.10.2026 05:50
5461281,71,7103 5.10.2026 17:49
36511241,71,7116 2.10.2026 18:17
5888581,71,7115 5.10.2026 21:38
7625681,71,7103 8.10.2026 18:57
7442081,71,7128 8.10.2026 16:38
4435281,71,7103 5.10.2026 09:09
61428161,71,7104 5.10.2026 22:56
3025781,71,7125 1.10.2026 20:58
6976481,71,7104 7.10.2026 20:53
766481,71,7103 29.09.2026 20:13
4808481,71,7103 5.10.2026 10:03
65591041,71,7115 29.09.2026 18:42
24555161,81,8115 30.09.2026 22:38
9028801,81,8107 30.09.2026 05:42
15552321,81,8117 30.09.2026 11:22
34106111,81,8118 2.10.2026 16:25
3743081,81,8116 4.10.2026 08:55
6531581,81,8130 7.10.2026 13:55
3924881,81,8103 4.10.2026 13:31
2618581,81,8103 30.09.2026 22:53
4096881,81,8103 4.10.2026 22:07
51394161,81,8129 5.10.2026 12:59
3999481,81,8104 4.10.2026 13:45
2888281,91,9127 1.10.2026 19:31
1975081,91,9114 30.09.2026 20:42
49860161,91,9124 5.10.2026 12:33
31741161,91,9110 2.10.2026 00:06
5374082,02,0103 5.10.2026 13:58
2044782,02,0114 30.09.2026 21:24
2111482,02,0105 30.09.2026 21:32
7354582,32,3104 8.10.2026 16:34
6066243,33,3129 28.09.2026 17:03
702714,34,31.003 29.09.2026 13:36
20749149,349,35.776 30.09.2026 21:30
6684349,849,63.145 29.09.2026 02:24
19344250,250,25.620 30.09.2026 20:30
24061154,054,04.681 30.09.2026 22:30
9484156,656,66.788 30.09.2026 03:30
64731115,4115,411.599 28.09.2026 19:21
60251140,0140,012.593 28.09.2026 16:25
306871144,5123,412.467 1.10.2026 21:13
379863168,6167,627.980 4.10.2026 12:30
378121172,1171,727.189 4.10.2026 09:30
369833178,3175,325.158 4.10.2026 08:30
388581178,6178,528.620 4.10.2026 13:30
404006179,7179,630.070 4.10.2026 19:30
404381196,4174,516.873 4.10.2026 20:30
430371203,7182,119.384 5.10.2026 03:30
59931205,3205,312.677 28.09.2026 16:24
413962216,1206,817.212 4.10.2026 23:30
405601234,9208,016.952 4.10.2026 21:30
447841277,5270,520.151 5.10.2026 09:30
432261361,7353,319.794 5.10.2026 08:59
645522443,8422,828.026 6.10.2026 22:15
668101543,6467,232.531 7.10.2026 20:40
776011664,1602,936.879 8.10.2026 20:03
809571724,7648,536.875 9.10.2026 14:52
7022811.038,8963,132.922 8.10.2026 08:30 en kötü

Davranış

Wait kategorileri (QDS)
Idle:275,Other Disk IO:70,CPU:59
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,@asOf datetime)INSERT rag.PlanChangeSeries (CaseID, PlanRole, IntervalStartUtc, Executions, AvgDurationMs, AvgCpuMs, AvgLogicalReads, AvgRows, TotalWaitMs)
        SELECT r.CaseID, r.PlanRole, rs.IntervalStartUtc, SUM(rs.count_executions),
               SUM(rs.avg_duration * rs.count_executions) / NULLIF(SUM(rs.count_executions), 0) / 1000.0,
               SUM(rs.avg_cpu_time * rs.count_executions) / NULLIF(SUM(rs.count_executions), 0) / 1000.0,
               SUM(rs.avg_logical_io_reads * rs.count_executions) / NULLIF(SUM(rs.count_executions), 0),
               SUM(rs.avg_rowcount * rs.count_executions) / NULLIF(SUM(rs.count_executions), 0),
               (SELECT SUM(ws.total_query_wait_time_ms) FROM perf.QdsWaitStats AS ws
                WHERE ws.ServerID = r.ServerID AND ws.DatabaseName = r.DatabaseName AND ws.plan_id = r.plan_id
                  AND ws.IntervalStartUtc = rs.IntervalStartUtc)
        FROM #role AS r
        JOIN perf.QdsRuntimeStats AS rs ON rs.ServerID = r.ServerID AND rs.DatabaseName = r.DatabaseName AND rs.plan_id = r.plan_id
             AND rs.execution_type = 0 AND rs.IntervalStartUtc >= @from AND rs.IntervalStartUtc < @asOf
        GROUP BY r.CaseID, r.PlanRole, r.ServerID, r.DatabaseName, r.plan_id, rs.IntervalStartUtc

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.