Pahalı sorgular0x1242248F1F4E0779
Demo modu

Sorgu 0x1242248F1F4E0779

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,2 ms
Ort. CPU 1,2 ms
Bekleme payı %0,8
Ort. mantıksal okuma 95
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,2 ms30.09.2026: 349 çalışma, ort. 1,2 ms1.10.2026: 49 çalışma, ort. 1,3 ms2.10.2026: 83 çalışma, ort. 1,1 ms3.10.2026: 1 çalışma, ort. 1,2 ms4.10.2026: 57 çalışma, ort. 1,2 ms5.10.2026: 211 çalışma, ort. 1,2 ms6.10.2026: 50 çalışma, ort. 1,1 ms7.10.2026: 49 çalışma, ort. 1,1 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 82529
  2. 9.10.2026 17:00 yeni plan plan 81534
  3. 9.10.2026 14:00 yeni plan plan 80955
  4. 9.10.2026 14:00 yeni plan plan 80491
  5. 9.10.2026 14:00 yeni plan plan 79589
  6. 9.10.2026 13:00 yeni plan plan 78646
  7. 8.10.2026 19:00 yeni plan plan 77160
  8. 8.10.2026 18:00 yeni plan plan 76254
  9. 8.10.2026 17:00 yeni plan plan 75317
  10. 8.10.2026 16:00 yeni plan plan 74418
  11. 8.10.2026 16:00 yeni plan plan 73543
  12. 8.10.2026 14:00 yeni plan plan 72563
  13. 8.10.2026 12:00 yeni plan plan 71651
  14. 8.10.2026 12:00 yeni plan plan 70770
  15. 7.10.2026 20:00 yeni plan plan 69762
  16. 7.10.2026 20:00 yeni plan plan 68891
  17. 7.10.2026 20:00 yeni plan plan 67295
  18. 7.10.2026 20:00 yeni plan plan 66357
  19. 7.10.2026 13:00 yeni plan plan 65313
  20. 6.10.2026 00:00 yeni plan plan 63946
  21. 5.10.2026 23:00 yeni plan plan 63039
  22. 5.10.2026 22:00 yeni plan plan 60541
  23. 5.10.2026 22:00 yeni plan plan 61426
  24. 5.10.2026 21:00 yeni plan plan 59704
  25. 5.10.2026 21:00 yeni plan plan 58883
  26. 5.10.2026 21:00 yeni plan plan 58021
  27. 5.10.2026 20:00 yeni plan plan 57125
  28. 5.10.2026 18:00 yeni plan plan 56279
  29. 5.10.2026 17:00 yeni plan plan 55431
  30. 5.10.2026 17:00 yeni plan plan 54610
  31. 5.10.2026 13:00 yeni plan plan 53738
  32. 5.10.2026 13:00 yeni plan plan 52919
  33. 5.10.2026 12:00 yeni plan plan 51392
  34. 5.10.2026 12:00 yeni plan plan 49858
  35. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  36. 5.10.2026 10:00 yeni plan plan 48964
  37. 5.10.2026 10:00 yeni plan plan 48082
  38. 5.10.2026 10:00 yeni plan plan 47279
  39. 5.10.2026 09:00 yeni plan plan 45585
  40. 5.10.2026 09:00 yeni plan plan 44350
  41. 5.10.2026 08:00 yeni plan plan 43224
  42. 5.10.2026 02:00 yeni plan plan 42615
  43. 5.10.2026 00:00 yeni plan plan 41808
  44. 4.10.2026 22:00 yeni plan plan 40966
  45. 4.10.2026 21:00 yeni plan plan 40558
  46. 4.10.2026 13:00 yeni plan plan 39992
  47. 4.10.2026 13:00 yeni plan plan 39246
  48. 4.10.2026 13:00 yeni plan plan 38475
  49. 4.10.2026 10:00 yeni plan plan 37984
  50. 4.10.2026 08:00 yeni plan plan 37428
  51. 2.10.2026 17:00 yeni plan plan 36509
  52. 2.10.2026 17:00 yeni plan plan 35794
  53. 2.10.2026 17:00 yeni plan plan 35048
  54. 2.10.2026 16:00 yeni plan plan 34104
  55. 2.10.2026 02:00 yeni plan plan 33659
  56. 2.10.2026 01:00 yeni plan plan 32961
  57. 2.10.2026 00:00 yeni plan plan 31739
  58. 1.10.2026 21:00 yeni plan plan 30685
  59. 1.10.2026 20:00 yeni plan plan 30255
  60. 1.10.2026 20:00 yeni plan plan 29605
  61. 1.10.2026 19:00 yeni plan plan 28880
  62. 1.10.2026 19:00 yeni plan plan 28201
  63. 1.10.2026 19:00 yeni plan plan 27530
  64. 30.09.2026 22:00 yeni plan plan 26829
  65. 30.09.2026 22:00 yeni plan plan 26183
  66. 30.09.2026 22:00 yeni plan plan 25503
  67. 30.09.2026 22:00 yeni plan plan 24553
  68. 30.09.2026 22:00 yeni plan plan 24259
  69. 30.09.2026 22:00 yeni plan plan 23729
  70. 30.09.2026 22:00 yeni plan plan 23083
  71. 30.09.2026 21:00 yeni plan plan 20445
  72. 30.09.2026 21:00 yeni plan plan 21112
  73. 30.09.2026 21:00 yeni plan plan 21762
  74. 30.09.2026 21:00 yeni plan plan 22405
  75. 30.09.2026 20:00 yeni plan plan 19748
  76. 30.09.2026 19:00 yeni plan plan 19029
  77. 30.09.2026 15:00 yeni plan plan 18360
  78. 30.09.2026 15:00 yeni plan plan 17728
  79. 30.09.2026 15:00 yeni plan plan 17076
  80. 30.09.2026 11:00 yeni plan plan 15550
  81. 30.09.2026 11:00 yeni plan plan 15217
  82. 30.09.2026 11:00 yeni plan plan 14579
  83. 30.09.2026 10:00 yeni plan plan 13973
  84. 30.09.2026 10:00 yeni plan plan 12877
  85. 30.09.2026 06:00 yeni plan plan 11963
  86. 30.09.2026 06:00 yeni plan plan 11188
  87. 30.09.2026 06:00 yeni plan plan 10625
  88. 30.09.2026 05:00 yeni plan plan 10062
  89. 30.09.2026 00:00 yeni plan plan 9026
  90. 29.09.2026 21:00 yeni plan plan 8570
  91. 29.09.2026 21:00 yeni plan plan 8142
  92. 29.09.2026 20:00 yeni plan plan 7662
  93. 28.09.2026 19:00 yeni plan plan 6471
  94. 28.09.2026 16:00 yeni plan plan 6023
  95. 28.09.2026 16:00 yeni plan plan 5991

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28531,11,1 1,292
2026-09-291071,21,2 1,593
2026-09-303491,21,2 1,593
2026-10-01491,11,3 1,893
2026-10-02831,11,1 1,295
2026-10-0311,21,2 1,2209
2026-10-04571,21,2 2,0120
2026-10-052111,21,2 1,795
2026-10-06501,11,1 1,999
2026-10-07491,11,1 1,395
2026-10-09331,21,2 2,197

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
3798430,90,9170 4.10.2026 12:30 en iyi
1006281,01,093 30.09.2026 05:49
6889181,01,094 7.10.2026 20:51
7441881,01,092 8.10.2026 16:38
6303981,01,095 5.10.2026 23:04
7165181,01,092 8.10.2026 12:37
5373881,01,092 5.10.2026 13:58
814281,01,092 29.09.2026 21:26
11963161,01,092 30.09.2026 07:00
857081,01,093 29.09.2026 21:50
34104111,01,096 2.10.2026 16:25
11188161,01,092 30.09.2026 06:59
3365981,01,093 2.10.2026 02:27
8252981,01,095 9.10.2026 19:25
766281,11,191 29.09.2026 20:13
63946501,11,199 6.10.2026 22:15
1062581,11,191 30.09.2026 06:32
3504881,11,197 2.10.2026 17:24
3579481,11,194 2.10.2026 17:32
4727981,11,194 5.10.2026 10:00
7256381,11,192 8.10.2026 14:01
6023251,11,193 28.09.2026 17:03
39992151,11,1130 4.10.2026 20:30
2820181,11,192 1.10.2026 19:19
2753081,11,194 1.10.2026 19:13
2960581,11,191 1.10.2026 20:57
7077081,11,194 8.10.2026 12:20
2682981,11,192 30.09.2026 22:56
61426161,11,197 5.10.2026 22:56
2618381,11,194 30.09.2026 22:53
2888081,11,194 1.10.2026 19:31
36509271,11,1105 4.10.2026 08:30
67295161,11,192 7.10.2026 20:50
9026811,11,194 30.09.2026 05:42
7625481,11,194 8.10.2026 18:57
8153481,21,290 9.10.2026 17:45
4808281,21,294 5.10.2026 10:03
45585161,21,292 5.10.2026 09:49
4261591,21,2106 5.10.2026 03:30
8049181,21,293 9.10.2026 14:29
4896481,21,293 5.10.2026 10:42
19029101,21,290 30.09.2026 20:30
5802181,21,293 5.10.2026 21:02
6531381,21,293 7.10.2026 13:55
64711101,21,293 29.09.2026 18:42
3296181,21,196 2.10.2026 01:09
5627981,21,293 5.10.2026 18:28
7864681,21,295 9.10.2026 13:15
599111,21,295 28.09.2026 16:24
5291981,21,291 5.10.2026 13:19
1707681,21,292 30.09.2026 15:32
49858161,21,292 5.10.2026 12:33
12877161,21,291 30.09.2026 10:52
3742891,21,2105 4.10.2026 09:30
5712581,21,292 5.10.2026 20:19
5543181,21,293 5.10.2026 17:58
4180881,21,291 5.10.2026 00:27
3924681,21,293 4.10.2026 13:31
31739161,21,295 2.10.2026 00:06
23729171,21,292 30.09.2026 22:30
5888381,31,390 5.10.2026 21:38
7958981,31,395 9.10.2026 14:27
1397381,31,393 30.09.2026 10:56
1521781,31,392 30.09.2026 11:08
1772881,31,394 30.09.2026 15:42
2308381,31,394 30.09.2026 22:15
2240581,31,392 30.09.2026 21:37
24553161,31,393 30.09.2026 22:38
6054181,31,394 5.10.2026 22:04
2111281,31,392 30.09.2026 21:32
7531781,31,393 8.10.2026 17:17
2550381,31,392 30.09.2026 22:40
40966101,31,3118 4.10.2026 23:30
1974881,31,394 30.09.2026 20:42
1836081,31,394 30.09.2026 15:51
6635791,41,4104 7.10.2026 20:40
1457981,41,494 30.09.2026 11:02
15550321,41,492 30.09.2026 11:22
2425981,41,495 30.09.2026 22:35
5970481,41,492 5.10.2026 21:41
3847591,41,4106 4.10.2026 13:30
4322491,41,4105 5.10.2026 09:01
2176281,41,494 30.09.2026 21:34
5461081,51,594 5.10.2026 17:49
51392161,51,593 5.10.2026 12:59
3025581,51,294 1.10.2026 20:58
6976291,61,6108 8.10.2026 08:30
2044591,61,694 30.09.2026 21:30
4435091,81,8106 5.10.2026 09:30
4055811,91,9210 4.10.2026 21:30
3068591,91,292 1.10.2026 21:13
7354381,91,993 8.10.2026 16:34
7716091,91,9105 8.10.2026 20:03
8095512,32,3206 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
CPU:7
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 pr.CaseID, r.PlanRole, r.plan_id, pr.ServerID, pr.DatabaseName
        INTO #role
        FROM #pair AS pr
        CROSS APPLY (VALUES ('Old', pr.OldPlanId), ('New', pr.NewPlanId)) AS r (PlanRole, plan_id)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.