Pahalı sorgular0xD8BE4FFC0601F7EF
Demo modu

Sorgu 0xD8BE4FFC0601F7EF

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 20,6 ms
Ort. CPU 20,4 ms
Bekleme payı %1
Ort. mantıksal okuma 350
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. 9,2 ms29.09.2026: 107 çalışma, ort. 4,1 ms30.09.2026: 349 çalışma, ort. 3,6 ms1.10.2026: 49 çalışma, ort. 4,1 ms2.10.2026: 83 çalışma, ort. 2,9 ms3.10.2026: 1 çalışma, ort. 324,7 ms4.10.2026: 57 çalışma, ort. 136,2 ms5.10.2026: 211 çalışma, ort. 11,9 ms6.10.2026: 50 çalışma, ort. 51,3 ms7.10.2026: 49 çalışma, ort. 53,1 ms9.10.2026: 33 çalışma, ort. 93,4 ms max 349 çalışma max ort. süre 324,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 82533
  2. 9.10.2026 17:00 yeni plan plan 81538
  3. 9.10.2026 14:00 yeni plan plan 80959
  4. 9.10.2026 14:00 yeni plan plan 80495
  5. 9.10.2026 14:00 yeni plan plan 79593
  6. 9.10.2026 13:00 yeni plan plan 78650
  7. 8.10.2026 20:00 yeni plan plan 77603
  8. 8.10.2026 19:00 yeni plan plan 77164
  9. 8.10.2026 18:00 yeni plan plan 76258
  10. 8.10.2026 17:00 yeni plan plan 75321
  11. 8.10.2026 16:00 yeni plan plan 74422
  12. 8.10.2026 16:00 yeni plan plan 73547
  13. 8.10.2026 14:00 yeni plan plan 72567
  14. 8.10.2026 12:00 yeni plan plan 71655
  15. 8.10.2026 12:00 yeni plan plan 70774
  16. 8.10.2026 08:00 yeni plan plan 70230
  17. 7.10.2026 20:00 yeni plan plan 69766
  18. 7.10.2026 20:00 yeni plan plan 68895
  19. 7.10.2026 20:00 yeni plan plan 67299
  20. 7.10.2026 20:00 yeni plan plan 66812
  21. 7.10.2026 20:00 yeni plan plan 66361
  22. 7.10.2026 13:00 yeni plan plan 65317
  23. 6.10.2026 03:00 yeni plan plan 64554
  24. 6.10.2026 00:00 yeni plan plan 63950
  25. 5.10.2026 23:00 yeni plan plan 63043
  26. 5.10.2026 22:00 yeni plan plan 61430
  27. 5.10.2026 22:00 yeni plan plan 60545
  28. 5.10.2026 21:00 yeni plan plan 58025
  29. 5.10.2026 21:00 yeni plan plan 58887
  30. 5.10.2026 21:00 yeni plan plan 59708
  31. 5.10.2026 20:00 yeni plan plan 57129
  32. 5.10.2026 18:00 yeni plan plan 56283
  33. 5.10.2026 17:00 yeni plan plan 55435
  34. 5.10.2026 17:00 yeni plan plan 54614
  35. 5.10.2026 13:00 yeni plan plan 53742
  36. 5.10.2026 13:00 yeni plan plan 52923
  37. 5.10.2026 12:00 yeni plan plan 51396
  38. 5.10.2026 12:00 yeni plan plan 49862
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48968
  41. 5.10.2026 10:00 yeni plan plan 48086
  42. 5.10.2026 10:00 yeni plan plan 47283
  43. 5.10.2026 09:00 yeni plan plan 45589
  44. 5.10.2026 09:00 yeni plan plan 44786
  45. 5.10.2026 09:00 yeni plan plan 44354
  46. 5.10.2026 09:00 yeni plan plan 43569
  47. 5.10.2026 08:00 yeni plan plan 43228
  48. 5.10.2026 03:00 yeni plan plan 43039
  49. 5.10.2026 02:00 yeni plan plan 42619
  50. 5.10.2026 00:00 yeni plan plan 41812
  51. 4.10.2026 22:00 yeni plan plan 41398
  52. 4.10.2026 22:00 yeni plan plan 40970
  53. 4.10.2026 21:00 yeni plan plan 40562
  54. 4.10.2026 14:00 yeni plan plan 40402
  55. 4.10.2026 13:00 yeni plan plan 39996
  56. 4.10.2026 13:00 yeni plan plan 39250
  57. 4.10.2026 13:00 yeni plan plan 38860
  58. 4.10.2026 13:00 yeni plan plan 38479
  59. 4.10.2026 10:00 yeni plan plan 37988
  60. 4.10.2026 09:00 yeni plan plan 37814
  61. 4.10.2026 08:00 yeni plan plan 37432
  62. 3.10.2026 03:00 yeni plan plan 36985
  63. 2.10.2026 17:00 yeni plan plan 36513
  64. 2.10.2026 17:00 yeni plan plan 35798
  65. 2.10.2026 17:00 yeni plan plan 35052
  66. 2.10.2026 16:00 yeni plan plan 34108
  67. 2.10.2026 02:00 yeni plan plan 33663
  68. 2.10.2026 01:00 yeni plan plan 32965
  69. 2.10.2026 00:00 yeni plan plan 31743
  70. 1.10.2026 21:00 yeni plan plan 31085
  71. 1.10.2026 21:00 yeni plan plan 30689
  72. 1.10.2026 20:00 yeni plan plan 30259
  73. 1.10.2026 20:00 yeni plan plan 29609
  74. 1.10.2026 19:00 yeni plan plan 28884
  75. 1.10.2026 19:00 yeni plan plan 28205
  76. 1.10.2026 19:00 yeni plan plan 27534
  77. 30.09.2026 22:00 yeni plan plan 26833
  78. 30.09.2026 22:00 yeni plan plan 26187
  79. 30.09.2026 22:00 yeni plan plan 25507
  80. 30.09.2026 22:00 yeni plan plan 24557
  81. 30.09.2026 22:00 yeni plan plan 24263
  82. 30.09.2026 22:00 yeni plan plan 24063
  83. 30.09.2026 22:00 yeni plan plan 23733
  84. 30.09.2026 22:00 yeni plan plan 23087
  85. 30.09.2026 21:00 yeni plan plan 20449
  86. 30.09.2026 21:00 yeni plan plan 20751
  87. 30.09.2026 21:00 yeni plan plan 21116
  88. 30.09.2026 21:00 yeni plan plan 21766
  89. 30.09.2026 21:00 yeni plan plan 22409
  90. 30.09.2026 20:00 yeni plan plan 19752
  91. 30.09.2026 20:00 yeni plan plan 19346
  92. 30.09.2026 19:00 yeni plan plan 19033
  93. 30.09.2026 15:00 yeni plan plan 18364
  94. 30.09.2026 15:00 yeni plan plan 17732
  95. 30.09.2026 15:00 yeni plan plan 17080
  96. 30.09.2026 11:00 yeni plan plan 15554
  97. 30.09.2026 11:00 yeni plan plan 15221
  98. 30.09.2026 11:00 yeni plan plan 14583
  99. 30.09.2026 10:00 yeni plan plan 13977
  100. 30.09.2026 10:00 yeni plan plan 12881
  101. 30.09.2026 06:00 yeni plan plan 11967
  102. 30.09.2026 06:00 yeni plan plan 11192
  103. 30.09.2026 06:00 yeni plan plan 10629
  104. 30.09.2026 05:00 yeni plan plan 10066
  105. 30.09.2026 03:00 yeni plan plan 9486
  106. 30.09.2026 00:00 yeni plan plan 9030
  107. 29.09.2026 21:00 yeni plan plan 8574
  108. 29.09.2026 21:00 yeni plan plan 8146
  109. 29.09.2026 20:00 yeni plan plan 7666
  110. 28.09.2026 19:00 yeni plan plan 6561
  111. 28.09.2026 19:00 yeni plan plan 6475
  112. 28.09.2026 16:00 yeni plan plan 6068
  113. 28.09.2026 16:00 yeni plan plan 6027
  114. 28.09.2026 16:00 yeni plan plan 5995

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28539,29,2 82,9227
2026-09-291074,04,1 39,4145
2026-09-303493,63,6 36,5142
2026-10-01493,64,1 40,4153
2026-10-02832,92,9 3,4135
2026-10-031324,7324,7 324,74.596
2026-10-0457136,1136,2 565,12.087
2026-10-0521111,911,9 609,4246
2026-10-065050,851,3 1.284,4814
2026-10-074951,153,1 1.857,0525
2026-10-093392,293,4 2.387,5825

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
3505282,52,5135 2.10.2026 17:24 en iyi
2960982,62,6134 1.10.2026 20:57
6889582,62,6136 7.10.2026 20:51
2683382,62,6135 30.09.2026 22:56
3579882,62,6135 2.10.2026 17:32
7532182,62,6134 8.10.2026 17:17
2888482,72,7136 1.10.2026 19:31
7256782,72,7136 8.10.2026 14:01
857482,72,7134 29.09.2026 21:50
3847982,72,7134 4.10.2026 13:29
4728382,72,7133 5.10.2026 10:00
67299162,72,7134 7.10.2026 20:50
5712982,72,7133 5.10.2026 20:19
11967162,72,7134 30.09.2026 07:00
6976682,72,7137 7.10.2026 20:53
5543582,72,7134 5.10.2026 17:58
34108112,72,7136 2.10.2026 16:25
6531782,72,7137 7.10.2026 13:55
7716482,72,7134 8.10.2026 19:59
1062982,72,6133 30.09.2026 06:32
814682,72,7133 29.09.2026 21:26
3999682,72,7133 4.10.2026 13:45
7077482,72,7135 8.10.2026 12:20
7959382,72,7136 9.10.2026 14:27
1397782,72,7137 30.09.2026 10:56
4808682,72,7135 5.10.2026 10:03
5461482,72,7136 5.10.2026 17:49
4896882,82,8134 5.10.2026 10:42
63950482,82,8135 6.10.2026 05:50
4356982,82,8132 5.10.2026 09:01
6636182,82,8134 7.10.2026 20:12
5628382,82,8132 5.10.2026 18:28
3366382,82,8133 2.10.2026 02:27
5802582,82,8136 5.10.2026 21:02
36513242,82,8135 2.10.2026 18:17
4181282,82,8133 5.10.2026 00:27
766682,82,8134 29.09.2026 20:13
2176682,82,8136 30.09.2026 21:34
8049582,82,8135 9.10.2026 14:29
4435482,82,8134 5.10.2026 09:09
8253382,82,8136 9.10.2026 19:25
3108582,82,8134 1.10.2026 21:13
11192162,82,8133 30.09.2026 06:59
3025982,82,8134 1.10.2026 20:58
6304382,92,9138 5.10.2026 23:04
6068242,92,9134 28.09.2026 17:03
24557162,92,9133 30.09.2026 22:38
7165582,92,9135 8.10.2026 12:37
5970882,92,9134 5.10.2026 21:41
2550782,92,9136 30.09.2026 22:40
1773282,92,9135 30.09.2026 15:42
5292382,92,9133 5.10.2026 13:19
2820582,92,7135 1.10.2026 19:19
1836482,92,9136 30.09.2026 15:51
45589162,92,9133 5.10.2026 09:49
5888782,92,9133 5.10.2026 21:38
2308782,92,8133 30.09.2026 22:15
61430163,03,0139 5.10.2026 22:56
23733163,03,0134 30.09.2026 22:19
1522183,03,0135 30.09.2026 11:08
6054583,03,0133 5.10.2026 22:04
49862163,03,0135 5.10.2026 12:33
1708083,03,0136 30.09.2026 15:32
9030803,13,1135 30.09.2026 05:42
7442283,13,1135 8.10.2026 16:38
12881163,12,9136 30.09.2026 10:52
2111683,13,1134 30.09.2026 21:32
5374283,13,1136 5.10.2026 13:58
2426383,13,1136 30.09.2026 22:35
15554323,13,1134 30.09.2026 11:22
1903383,23,2134 30.09.2026 19:36
2240983,23,2134 30.09.2026 21:37
4261983,23,2131 5.10.2026 02:58
1458383,33,3136 30.09.2026 11:02
3296583,33,3137 2.10.2026 01:09
7865083,33,3141 9.10.2026 13:15
1006683,33,2133 30.09.2026 05:49
7625883,33,3138 8.10.2026 18:57
8153883,43,4134 9.10.2026 17:45
65611043,53,4135 29.09.2026 18:42
4097083,53,5137 4.10.2026 22:07
31743163,53,5135 2.10.2026 00:06
2044983,53,5133 30.09.2026 21:24
3925083,63,6132 4.10.2026 13:31
51396163,63,4135 5.10.2026 12:59
3743283,73,7130 4.10.2026 08:55
2618783,83,8136 30.09.2026 22:53
2753484,22,8137 1.10.2026 19:13
7354784,64,6134 8.10.2026 16:34
1975285,65,6135 30.09.2026 20:42
24063121,121,1476 30.09.2026 22:30
20751136,236,2664 30.09.2026 21:30
19346237,037,0618 30.09.2026 20:30
6475644,144,1754 29.09.2026 13:36
9486155,355,3865 30.09.2026 03:30
30689155,944,91.035 1.10.2026 21:13
6027179,179,11.276 28.09.2026 16:25
5995184,984,91.267 28.09.2026 16:24
369853375,1375,15.390 4.10.2026 08:30
379883391,7390,36.122 4.10.2026 12:30
378141396,9396,96.210 4.10.2026 09:30
404027451,5451,27.025 4.10.2026 20:30
388601469,3469,36.348 4.10.2026 13:30
430391474,7474,67.841 5.10.2026 03:30
413982532,5532,37.351 4.10.2026 23:30
405621565,1565,17.230 4.10.2026 21:30
447861643,1643,18.161 5.10.2026 09:30
432281777,3776,37.906 5.10.2026 08:59
6455421.216,11.203,717.104 6.10.2026 22:15
6681212.475,02.374,719.224 7.10.2026 20:40
8095912.983,52.943,922.860 9.10.2026 14:52
7760313.327,33.210,721.674 8.10.2026 20:03
7023013.681,73.668,620.474 8.10.2026 08:30 en kötü

Davranış

Wait kategorileri (QDS)
CPU:318,Memory:189,Buffer IO:48
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 
SELECT r.CaseID, r.PlanRole, r.ServerID, r.DatabaseName, TRY_CAST(CAST(DECOMPRESS(x.PlanXmlCompressed) AS nvarchar(max)) AS xml) AS PlanXml
        INTO #px
        FROM #role AS r
        JOIN perf.QdsPlan AS p ON p.ServerID = r.ServerID AND p.DatabaseName = r.DatabaseName AND p.plan_id = r.plan_id
        JOIN perf.QdsPlanXml AS x ON x.PlanHash = p.PlanHash

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.