Pahalı sorgular0x9CB4ABE07BF7AFD5
Demo modu

Sorgu 0x9CB4ABE07BF7AFD5

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,1 ms
Ort. CPU 1,1 ms
Bekleme payı %0,4
Ort. mantıksal okuma 103
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. 1,1 ms29.09.2026: 107 çalışma, ort. 1,1 ms30.09.2026: 349 çalışma, ort. 1,1 ms1.10.2026: 49 çalışma, ort. 1,2 ms2.10.2026: 83 çalışma, ort. 1,1 ms3.10.2026: 1 çalışma, ort. 1,3 ms4.10.2026: 57 çalışma, ort. 1,2 ms5.10.2026: 211 çalışma, ort. 1,1 ms6.10.2026: 50 çalışma, ort. 1,0 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 1,3 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 82537
  2. 9.10.2026 17:00 yeni plan plan 81542
  3. 9.10.2026 14:00 yeni plan plan 80963
  4. 9.10.2026 14:00 yeni plan plan 80499
  5. 9.10.2026 14:00 yeni plan plan 79597
  6. 9.10.2026 13:00 yeni plan plan 78654
  7. 8.10.2026 19:00 yeni plan plan 77168
  8. 8.10.2026 18:00 yeni plan plan 76262
  9. 8.10.2026 17:00 yeni plan plan 75325
  10. 8.10.2026 16:00 yeni plan plan 74426
  11. 8.10.2026 16:00 yeni plan plan 73551
  12. 8.10.2026 14:00 yeni plan plan 72571
  13. 8.10.2026 12:00 yeni plan plan 71659
  14. 8.10.2026 12:00 yeni plan plan 70778
  15. 7.10.2026 20:00 yeni plan plan 69770
  16. 7.10.2026 20:00 yeni plan plan 68899
  17. 7.10.2026 20:00 yeni plan plan 67303
  18. 7.10.2026 20:00 yeni plan plan 66365
  19. 7.10.2026 13:00 yeni plan plan 65321
  20. 6.10.2026 00:00 yeni plan plan 63954
  21. 5.10.2026 23:00 yeni plan plan 63047
  22. 5.10.2026 22:00 yeni plan plan 60549
  23. 5.10.2026 22:00 yeni plan plan 61434
  24. 5.10.2026 21:00 yeni plan plan 59712
  25. 5.10.2026 21:00 yeni plan plan 58891
  26. 5.10.2026 21:00 yeni plan plan 58029
  27. 5.10.2026 20:00 yeni plan plan 57133
  28. 5.10.2026 18:00 yeni plan plan 56287
  29. 5.10.2026 17:00 yeni plan plan 55439
  30. 5.10.2026 17:00 yeni plan plan 54618
  31. 5.10.2026 13:00 yeni plan plan 53746
  32. 5.10.2026 13:00 yeni plan plan 52927
  33. 5.10.2026 12:00 yeni plan plan 51400
  34. 5.10.2026 12:00 yeni plan plan 49866
  35. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  36. 5.10.2026 10:00 yeni plan plan 48972
  37. 5.10.2026 10:00 yeni plan plan 48090
  38. 5.10.2026 10:00 yeni plan plan 47287
  39. 5.10.2026 09:00 yeni plan plan 45593
  40. 5.10.2026 09:00 yeni plan plan 44358
  41. 5.10.2026 08:00 yeni plan plan 43232
  42. 5.10.2026 02:00 yeni plan plan 42623
  43. 5.10.2026 00:00 yeni plan plan 41816
  44. 4.10.2026 22:00 yeni plan plan 40974
  45. 4.10.2026 21:00 yeni plan plan 40566
  46. 4.10.2026 13:00 yeni plan plan 40000
  47. 4.10.2026 13:00 yeni plan plan 39254
  48. 4.10.2026 13:00 yeni plan plan 38483
  49. 4.10.2026 10:00 yeni plan plan 37992
  50. 4.10.2026 08:00 yeni plan plan 37436
  51. 2.10.2026 17:00 yeni plan plan 36517
  52. 2.10.2026 17:00 yeni plan plan 35802
  53. 2.10.2026 17:00 yeni plan plan 35056
  54. 2.10.2026 16:00 yeni plan plan 34112
  55. 2.10.2026 02:00 yeni plan plan 33667
  56. 2.10.2026 01:00 yeni plan plan 32969
  57. 2.10.2026 00:00 yeni plan plan 31747
  58. 1.10.2026 21:00 yeni plan plan 30696
  59. 1.10.2026 20:00 yeni plan plan 30263
  60. 1.10.2026 20:00 yeni plan plan 29613
  61. 1.10.2026 19:00 yeni plan plan 28888
  62. 1.10.2026 19:00 yeni plan plan 28209
  63. 1.10.2026 19:00 yeni plan plan 27538
  64. 30.09.2026 22:00 yeni plan plan 26837
  65. 30.09.2026 22:00 yeni plan plan 26191
  66. 30.09.2026 22:00 yeni plan plan 25511
  67. 30.09.2026 22:00 yeni plan plan 24561
  68. 30.09.2026 22:00 yeni plan plan 24267
  69. 30.09.2026 22:00 yeni plan plan 23737
  70. 30.09.2026 22:00 yeni plan plan 23091
  71. 30.09.2026 21:00 yeni plan plan 20453
  72. 30.09.2026 21:00 yeni plan plan 21120
  73. 30.09.2026 21:00 yeni plan plan 21770
  74. 30.09.2026 21:00 yeni plan plan 22413
  75. 30.09.2026 20:00 yeni plan plan 19756
  76. 30.09.2026 19:00 yeni plan plan 19037
  77. 30.09.2026 15:00 yeni plan plan 18368
  78. 30.09.2026 15:00 yeni plan plan 17736
  79. 30.09.2026 15:00 yeni plan plan 17084
  80. 30.09.2026 11:00 yeni plan plan 15558
  81. 30.09.2026 11:00 yeni plan plan 15225
  82. 30.09.2026 11:00 yeni plan plan 14587
  83. 30.09.2026 10:00 yeni plan plan 13981
  84. 30.09.2026 10:00 yeni plan plan 12885
  85. 30.09.2026 06:00 yeni plan plan 11971
  86. 30.09.2026 06:00 yeni plan plan 11196
  87. 30.09.2026 06:00 yeni plan plan 10633
  88. 30.09.2026 05:00 yeni plan plan 10070
  89. 30.09.2026 00:00 yeni plan plan 9034
  90. 29.09.2026 21:00 yeni plan plan 8578
  91. 29.09.2026 21:00 yeni plan plan 8150
  92. 29.09.2026 20:00 yeni plan plan 7670
  93. 28.09.2026 19:00 yeni plan plan 6479
  94. 28.09.2026 16:00 yeni plan plan 6031
  95. 28.09.2026 16:00 yeni plan plan 5999

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28531,11,1 1,299
2026-09-291071,11,1 1,5100
2026-09-303491,11,1 1,3100
2026-10-01491,11,2 1,7101
2026-10-02831,11,1 1,2102
2026-10-0311,31,3 1,3227
2026-10-04571,21,2 1,9126
2026-10-052111,11,1 1,4102
2026-10-06501,01,0 1,3105
2026-10-07491,01,0 1,1102
2026-10-09331,21,2 3,2105

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
3799230,80,8165 4.10.2026 12:30 en iyi
6889980,90,999 7.10.2026 20:51
8253780,90,998 9.10.2026 19:25
7442680,90,9100 8.10.2026 16:38
7165980,90,9101 8.10.2026 12:37
1007080,90,999 30.09.2026 05:49
7532581,01,0100 8.10.2026 17:17
34112111,01,099 2.10.2026 16:25
3580281,01,0102 2.10.2026 17:32
815081,01,099 29.09.2026 21:26
11196161,01,098 30.09.2026 06:59
857881,01,099 29.09.2026 21:50
7257181,01,0102 8.10.2026 14:01
6304781,01,0102 5.10.2026 23:04
2961381,01,099 1.10.2026 20:57
1063381,01,098 30.09.2026 06:32
2888881,01,0101 1.10.2026 19:31
6636591,01,0112 7.10.2026 20:40
4897281,01,0100 5.10.2026 10:42
7077881,01,099 8.10.2026 12:20
2753881,01,0101 1.10.2026 19:13
67303161,01,098 7.10.2026 20:50
1773681,01,099 30.09.2026 15:42
40000151,01,0135 4.10.2026 20:30
2820981,01,0102 1.10.2026 19:19
5971281,01,0101 5.10.2026 21:41
4728781,01,0101 5.10.2026 10:00
61434161,01,0104 5.10.2026 22:56
2619181,01,098 30.09.2026 22:53
36517271,01,0112 4.10.2026 08:30
3848391,01,0112 4.10.2026 13:30
1398181,01,0105 30.09.2026 10:56
767081,01,098 29.09.2026 20:13
63954501,01,0105 6.10.2026 22:15
5802981,01,0101 5.10.2026 21:02
3366781,01,098 2.10.2026 02:27
7355181,01,0100 8.10.2026 16:34
7959781,01,0103 9.10.2026 14:27
5374681,11,1101 5.10.2026 13:58
8049981,11,1102 9.10.2026 14:29
5713381,11,198 5.10.2026 20:19
2309181,11,1100 30.09.2026 22:15
6054981,11,199 5.10.2026 22:04
2683781,11,1102 30.09.2026 22:56
8154281,11,198 9.10.2026 17:45
5628781,11,198 5.10.2026 18:28
9034811,11,1100 30.09.2026 05:42
7626281,11,1102 8.10.2026 18:57
4262391,11,1114 5.10.2026 03:30
2241381,11,1100 30.09.2026 21:37
5889181,11,197 5.10.2026 21:38
5292781,11,197 5.10.2026 13:19
2551181,11,199 30.09.2026 22:40
2177081,11,1103 30.09.2026 21:34
5461881,11,1102 5.10.2026 17:49
4181681,11,198 5.10.2026 00:27
2426781,11,1102 30.09.2026 22:35
12885161,11,1103 30.09.2026 10:52
1836881,11,1102 30.09.2026 15:51
1708481,11,198 30.09.2026 15:32
6031251,11,1102 28.09.2026 17:03
45593161,11,1100 5.10.2026 09:49
24561161,11,1101 30.09.2026 22:38
3505681,11,1104 2.10.2026 17:24
2112081,11,199 30.09.2026 21:32
11971161,11,199 30.09.2026 07:00
6977091,11,1116 8.10.2026 08:30
1458781,11,1101 30.09.2026 11:02
1522581,11,1103 30.09.2026 11:08
599911,11,1102 28.09.2026 16:24
1975681,11,199 30.09.2026 20:42
23737171,11,1100 30.09.2026 22:30
6532181,11,1100 7.10.2026 13:55
64791101,11,1100 29.09.2026 18:42
15558321,21,2102 30.09.2026 11:22
5543981,21,2100 5.10.2026 17:58
3296981,21,2106 2.10.2026 01:09
31747161,21,2104 2.10.2026 00:06
3026381,21,2101 1.10.2026 20:58
4435891,21,2111 5.10.2026 09:30
40974101,21,2125 4.10.2026 23:30
49866161,21,299 5.10.2026 12:33
7865481,31,3102 9.10.2026 13:15
19037101,31,395 30.09.2026 20:30
3743691,31,3110 4.10.2026 09:30
4323291,31,3112 5.10.2026 09:01
51400161,31,3100 5.10.2026 12:59
4809081,41,4101 5.10.2026 10:03
4056611,51,5223 4.10.2026 21:30
7716891,61,0112 8.10.2026 20:03
3925481,91,998 4.10.2026 13:31
3069691,91,4101 1.10.2026 21:13
2045392,02,098 30.09.2026 21:30
8096313,63,6218 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
CPU:8
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 
(@hours int)SELECT pr.CaseID, pr.ServerID, pr.DatabaseName, DATEADD(hour, -@hours, pr.ChangeUtc) AS WinStart, pr.ChangeUtc, pr.ChangeEndUtc
        INTO #win FROM #pair AS pr

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.