Pahalı sorgular0x35EC50522E5E076E
Demo modu

Sorgu 0x35EC50522E5E076E

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 0,3 ms
Ort. CPU 0,3 ms
Bekleme payı %0,9
Ort. mantıksal okuma 9
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,3 ms29.09.2026: 107 çalışma, ort. 0,3 ms30.09.2026: 349 çalışma, ort. 0,3 ms1.10.2026: 49 çalışma, ort. 0,3 ms2.10.2026: 83 çalışma, ort. 0,3 ms3.10.2026: 1 çalışma, ort. 0,8 ms4.10.2026: 57 çalışma, ort. 0,3 ms5.10.2026: 211 çalışma, ort. 0,4 ms6.10.2026: 50 çalışma, ort. 0,3 ms7.10.2026: 49 çalışma, ort. 0,3 ms9.10.2026: 33 çalışma, ort. 0,4 ms max 349 çalışma max ort. süre 0,8 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 82523
  2. 9.10.2026 17:00 yeni plan plan 81528
  3. 9.10.2026 14:00 yeni plan plan 80949
  4. 9.10.2026 14:00 yeni plan plan 80485
  5. 9.10.2026 14:00 yeni plan plan 79583
  6. 9.10.2026 13:00 yeni plan plan 78640
  7. 8.10.2026 20:00 yeni plan plan 77594
  8. 8.10.2026 19:00 yeni plan plan 77154
  9. 8.10.2026 18:00 yeni plan plan 76248
  10. 8.10.2026 17:00 yeni plan plan 75311
  11. 8.10.2026 16:00 yeni plan plan 74412
  12. 8.10.2026 16:00 yeni plan plan 73537
  13. 8.10.2026 14:00 yeni plan plan 72557
  14. 8.10.2026 12:00 yeni plan plan 71645
  15. 8.10.2026 12:00 yeni plan plan 70764
  16. 8.10.2026 08:00 yeni plan plan 70221
  17. 7.10.2026 20:00 yeni plan plan 69756
  18. 7.10.2026 20:00 yeni plan plan 68885
  19. 7.10.2026 20:00 yeni plan plan 67289
  20. 7.10.2026 20:00 yeni plan plan 66803
  21. 7.10.2026 20:00 yeni plan plan 66351
  22. 7.10.2026 13:00 yeni plan plan 65307
  23. 6.10.2026 22:00 yeni plan plan 64773
  24. 6.10.2026 03:00 yeni plan plan 64545
  25. 6.10.2026 00:00 yeni plan plan 63940
  26. 5.10.2026 23:00 yeni plan plan 63033
  27. 5.10.2026 22:00 yeni plan plan 61420
  28. 5.10.2026 22:00 yeni plan plan 60535
  29. 5.10.2026 21:00 yeni plan plan 58015
  30. 5.10.2026 21:00 yeni plan plan 58877
  31. 5.10.2026 21:00 yeni plan plan 59698
  32. 5.10.2026 20:00 yeni plan plan 57119
  33. 5.10.2026 18:00 yeni plan plan 56273
  34. 5.10.2026 17:00 yeni plan plan 55425
  35. 5.10.2026 17:00 yeni plan plan 54604
  36. 5.10.2026 13:00 yeni plan plan 53732
  37. 5.10.2026 13:00 yeni plan plan 52913
  38. 5.10.2026 12:00 yeni plan plan 51386
  39. 5.10.2026 12:00 yeni plan plan 49852
  40. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  41. 5.10.2026 10:00 yeni plan plan 48958
  42. 5.10.2026 10:00 yeni plan plan 48076
  43. 5.10.2026 10:00 yeni plan plan 47273
  44. 5.10.2026 09:00 yeni plan plan 45579
  45. 5.10.2026 09:00 yeni plan plan 44777
  46. 5.10.2026 09:00 yeni plan plan 44344
  47. 5.10.2026 09:00 yeni plan plan 43560
  48. 5.10.2026 08:00 yeni plan plan 43218
  49. 5.10.2026 03:00 yeni plan plan 43030
  50. 5.10.2026 02:00 yeni plan plan 42609
  51. 5.10.2026 00:00 yeni plan plan 41802
  52. 4.10.2026 22:00 yeni plan plan 41389
  53. 4.10.2026 22:00 yeni plan plan 40960
  54. 4.10.2026 21:00 yeni plan plan 40552
  55. 4.10.2026 14:00 yeni plan plan 40393
  56. 4.10.2026 13:00 yeni plan plan 39986
  57. 4.10.2026 13:00 yeni plan plan 39240
  58. 4.10.2026 13:00 yeni plan plan 38851
  59. 4.10.2026 13:00 yeni plan plan 38469
  60. 4.10.2026 10:00 yeni plan plan 37978
  61. 4.10.2026 09:00 yeni plan plan 37805
  62. 4.10.2026 08:00 yeni plan plan 37422
  63. 4.10.2026 08:00 yeni plan plan 37034
  64. 3.10.2026 03:00 yeni plan plan 36976
  65. 2.10.2026 17:00 yeni plan plan 36503
  66. 2.10.2026 17:00 yeni plan plan 35788
  67. 2.10.2026 17:00 yeni plan plan 35042
  68. 2.10.2026 16:00 yeni plan plan 34098
  69. 2.10.2026 02:00 yeni plan plan 33653
  70. 2.10.2026 01:00 yeni plan plan 32955
  71. 2.10.2026 00:00 yeni plan plan 31733
  72. 1.10.2026 21:00 yeni plan plan 31076
  73. 1.10.2026 21:00 yeni plan plan 30679
  74. 1.10.2026 20:00 yeni plan plan 30249
  75. 1.10.2026 20:00 yeni plan plan 29599
  76. 1.10.2026 19:00 yeni plan plan 28874
  77. 1.10.2026 19:00 yeni plan plan 28195
  78. 1.10.2026 19:00 yeni plan plan 27524
  79. 30.09.2026 22:00 yeni plan plan 26823
  80. 30.09.2026 22:00 yeni plan plan 26177
  81. 30.09.2026 22:00 yeni plan plan 25497
  82. 30.09.2026 22:00 yeni plan plan 24547
  83. 30.09.2026 22:00 yeni plan plan 24253
  84. 30.09.2026 22:00 yeni plan plan 24054
  85. 30.09.2026 22:00 yeni plan plan 23723
  86. 30.09.2026 22:00 yeni plan plan 23077
  87. 30.09.2026 21:00 yeni plan plan 20439
  88. 30.09.2026 21:00 yeni plan plan 20742
  89. 30.09.2026 21:00 yeni plan plan 21106
  90. 30.09.2026 21:00 yeni plan plan 21756
  91. 30.09.2026 21:00 yeni plan plan 22399
  92. 30.09.2026 20:00 yeni plan plan 19742
  93. 30.09.2026 20:00 yeni plan plan 19337
  94. 30.09.2026 19:00 yeni plan plan 19023
  95. 30.09.2026 15:00 yeni plan plan 18354
  96. 30.09.2026 15:00 yeni plan plan 17722
  97. 30.09.2026 15:00 yeni plan plan 17070
  98. 30.09.2026 11:00 yeni plan plan 15544
  99. 30.09.2026 11:00 yeni plan plan 15211
  100. 30.09.2026 11:00 yeni plan plan 14573
  101. 30.09.2026 10:00 yeni plan plan 13967
  102. 30.09.2026 10:00 yeni plan plan 12871
  103. 30.09.2026 06:00 yeni plan plan 11957
  104. 30.09.2026 06:00 yeni plan plan 11182
  105. 30.09.2026 06:00 yeni plan plan 10619
  106. 30.09.2026 05:00 yeni plan plan 10056
  107. 30.09.2026 03:00 yeni plan plan 9477
  108. 30.09.2026 00:00 yeni plan plan 9020
  109. 29.09.2026 21:00 yeni plan plan 8564
  110. 29.09.2026 21:00 yeni plan plan 8136
  111. 29.09.2026 20:00 yeni plan plan 7656
  112. 28.09.2026 19:00 yeni plan plan 6552
  113. 28.09.2026 19:00 yeni plan plan 6465
  114. 28.09.2026 16:00 yeni plan plan 6059
  115. 28.09.2026 16:00 yeni plan plan 6017
  116. 28.09.2026 16:00 yeni plan plan 5985

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,30,3 0,38
2026-09-291070,30,3 0,48
2026-09-303490,30,3 0,48
2026-10-01490,30,3 1,212
2026-10-02830,30,3 0,49
2026-10-0310,70,8 0,8186
2026-10-04570,30,3 0,412
2026-10-052110,40,4 0,49
2026-10-06500,30,3 0,713
2026-10-07490,30,3 0,410
2026-10-09330,40,4 2,412

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
1933720,10,15 30.09.2026 20:30 en iyi
3797830,10,115 4.10.2026 12:30
601710,10,14 28.09.2026 16:25
4039370,10,118 4.10.2026 20:30
646560,10,17 29.09.2026 13:36
2405410,10,14 30.09.2026 22:30
4138920,10,120 4.10.2026 23:30
3885110,10,114 4.10.2026 13:30
2074210,10,16 30.09.2026 21:30
4477710,10,118 5.10.2026 09:30
598510,20,220 28.09.2026 16:24
4303010,20,220 5.10.2026 03:30
4055210,20,212 4.10.2026 21:30
3703420,20,228 4.10.2026 08:30
3780510,20,224 4.10.2026 09:30
947710,20,216 30.09.2026 03:30
856480,20,28 29.09.2026 21:50
2682380,20,28 30.09.2026 22:56
813680,30,38 29.09.2026 21:26
1005680,30,38 30.09.2026 05:49
2887480,30,38 1.10.2026 19:31
4321810,30,316 5.10.2026 08:59
2959980,30,38 1.10.2026 20:57
6059240,30,38 28.09.2026 17:03
11957160,30,38 30.09.2026 07:00
3365380,30,38 2.10.2026 02:27
1396780,30,38 30.09.2026 10:56
2617780,30,38 30.09.2026 22:53
34098110,30,39 2.10.2026 16:25
3578880,30,38 2.10.2026 17:32
765680,30,38 29.09.2026 20:13
5460480,30,38 5.10.2026 17:49
7864080,30,38 9.10.2026 13:15
65521040,30,38 29.09.2026 18:42
6477310,30,356 6.10.2026 22:15
24547160,30,38 30.09.2026 22:38
6635180,30,38 7.10.2026 20:12
1061980,30,38 30.09.2026 06:32
5542580,30,38 5.10.2026 17:58
8048580,30,38 9.10.2026 14:29
3024980,30,38 1.10.2026 20:58
2307780,30,38 30.09.2026 22:15
7076480,30,38 8.10.2026 12:20
2752480,30,38 1.10.2026 19:13
1835480,30,38 30.09.2026 15:51
6303380,30,38 5.10.2026 23:04
7958380,30,38 9.10.2026 14:27
11182160,30,38 30.09.2026 06:59
23723160,30,38 30.09.2026 22:19
1902380,30,38 30.09.2026 19:36
5627380,30,38 5.10.2026 18:28
3107680,30,38 1.10.2026 21:13
12871160,30,38 30.09.2026 10:52
4260980,30,38 5.10.2026 02:58
5711980,30,38 5.10.2026 20:19
4807680,30,38 5.10.2026 10:03
1521180,30,38 30.09.2026 11:08
4727380,30,38 5.10.2026 10:00
6053580,30,38 5.10.2026 22:04
5801580,30,38 5.10.2026 21:02
4895880,30,38 5.10.2026 10:42
7164580,30,38 8.10.2026 12:37
7531180,30,38 8.10.2026 17:17
2239980,30,38 30.09.2026 21:37
67289160,30,38 7.10.2026 20:50
1974280,30,38 30.09.2026 20:42
8252380,30,38 9.10.2026 19:25
6975680,30,38 7.10.2026 20:53
3295580,30,38 2.10.2026 01:09
63940480,30,38 6.10.2026 05:50
7715480,30,38 8.10.2026 19:59
3846980,30,38 4.10.2026 13:29
1772280,30,38 30.09.2026 15:42
1457380,30,38 30.09.2026 11:02
3998680,40,48 4.10.2026 13:45
36503240,40,48 2.10.2026 18:17
9020800,40,48 30.09.2026 05:42
6530780,40,48 7.10.2026 13:55
3504280,40,48 2.10.2026 17:24
1707080,40,48 30.09.2026 15:32
7255780,40,48 8.10.2026 14:01
2425380,40,48 30.09.2026 22:35
5291380,40,48 5.10.2026 13:19
4180280,40,48 5.10.2026 00:27
2549780,40,48 30.09.2026 22:40
2175680,40,48 30.09.2026 21:34
4096080,40,48 4.10.2026 22:07
6680310,40,364 7.10.2026 20:40
6888580,40,48 7.10.2026 20:51
5969880,40,48 5.10.2026 21:41
15544320,40,48 30.09.2026 11:22
5373280,40,48 5.10.2026 13:58
4356080,40,48 5.10.2026 09:01
31733160,40,48 2.10.2026 00:06
61420160,40,48 5.10.2026 22:56
45579160,40,48 5.10.2026 09:49
2819580,40,48 1.10.2026 19:19
4434480,40,48 5.10.2026 09:09
2110680,40,48 30.09.2026 21:32
3924080,40,48 4.10.2026 13:31
2043980,40,48 30.09.2026 21:24
5887780,40,48 5.10.2026 21:38
7441280,40,48 8.10.2026 16:38
8152880,40,48 9.10.2026 17:45
51386160,40,48 5.10.2026 12:59
3742280,50,58 4.10.2026 08:55
7353780,50,58 8.10.2026 16:34
49852160,50,58 5.10.2026 12:33
3697610,80,7186 3.10.2026 03:30
7624880,80,88 8.10.2026 18:57
6454510,80,7188 6.10.2026 03:30
3067911,50,9185 1.10.2026 21:13
8094912,92,8125 9.10.2026 14:52
7759413,90,6114 8.10.2026 20:03
7022115,45,3118 8.10.2026 08:30 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:3
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 
UPDATE pr SET CaseID = c.CaseID
        FROM #pair AS pr
        JOIN rag.PlanChangeCase AS c ON c.ServerID = pr.ServerID AND c.DatabaseName = pr.DatabaseName AND c.query_id = pr.query_id
             AND c.OldPlanId = pr.OldPlanId AND c.NewPlanId = pr.NewPlanId
        WHERE pr.IsNew = 1

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.