Pahalı sorgular0x1BA5A56813D28119
Demo modu

Sorgu 0x1BA5A56813D28119

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,1 ms
Ort. CPU 0,1 ms
Bekleme payı %0,4
Ort. mantıksal okuma 4
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,1 ms29.09.2026: 107 çalışma, ort. 0,1 ms30.09.2026: 349 çalışma, ort. 0,1 ms1.10.2026: 49 çalışma, ort. 0,1 ms2.10.2026: 83 çalışma, ort. 0,1 ms3.10.2026: 1 çalışma, ort. 0,2 ms4.10.2026: 57 çalışma, ort. 0,1 ms5.10.2026: 211 çalışma, ort. 0,1 ms6.10.2026: 50 çalışma, ort. 0,1 ms7.10.2026: 49 çalışma, ort. 0,1 ms9.10.2026: 33 çalışma, ort. 0,1 ms max 349 çalışma max ort. süre 0,2 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 82521
  2. 9.10.2026 17:00 yeni plan plan 81526
  3. 9.10.2026 14:00 yeni plan plan 80947
  4. 9.10.2026 14:00 yeni plan plan 80483
  5. 9.10.2026 14:00 yeni plan plan 79581
  6. 9.10.2026 13:00 yeni plan plan 78638
  7. 8.10.2026 19:00 yeni plan plan 77152
  8. 8.10.2026 18:00 yeni plan plan 76246
  9. 8.10.2026 17:00 yeni plan plan 75309
  10. 8.10.2026 16:00 yeni plan plan 74410
  11. 8.10.2026 16:00 yeni plan plan 73535
  12. 8.10.2026 14:00 yeni plan plan 72555
  13. 8.10.2026 12:00 yeni plan plan 71643
  14. 8.10.2026 12:00 yeni plan plan 70762
  15. 7.10.2026 20:00 yeni plan plan 69754
  16. 7.10.2026 20:00 yeni plan plan 68883
  17. 7.10.2026 20:00 yeni plan plan 67287
  18. 7.10.2026 20:00 yeni plan plan 66349
  19. 7.10.2026 13:00 yeni plan plan 65305
  20. 6.10.2026 00:00 yeni plan plan 63938
  21. 5.10.2026 23:00 yeni plan plan 63031
  22. 5.10.2026 22:00 yeni plan plan 60533
  23. 5.10.2026 22:00 yeni plan plan 61418
  24. 5.10.2026 21:00 yeni plan plan 59696
  25. 5.10.2026 21:00 yeni plan plan 58875
  26. 5.10.2026 21:00 yeni plan plan 58013
  27. 5.10.2026 20:00 yeni plan plan 57117
  28. 5.10.2026 18:00 yeni plan plan 56271
  29. 5.10.2026 17:00 yeni plan plan 55423
  30. 5.10.2026 17:00 yeni plan plan 54602
  31. 5.10.2026 13:00 yeni plan plan 53730
  32. 5.10.2026 13:00 yeni plan plan 52911
  33. 5.10.2026 12:00 yeni plan plan 51384
  34. 5.10.2026 12:00 yeni plan plan 49850
  35. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  36. 5.10.2026 10:00 yeni plan plan 48956
  37. 5.10.2026 10:00 yeni plan plan 48074
  38. 5.10.2026 10:00 yeni plan plan 47271
  39. 5.10.2026 09:00 yeni plan plan 45577
  40. 5.10.2026 09:00 yeni plan plan 44342
  41. 5.10.2026 08:00 yeni plan plan 43216
  42. 5.10.2026 02:00 yeni plan plan 42607
  43. 5.10.2026 00:00 yeni plan plan 41800
  44. 4.10.2026 22:00 yeni plan plan 40958
  45. 4.10.2026 21:00 yeni plan plan 40550
  46. 4.10.2026 13:00 yeni plan plan 39984
  47. 4.10.2026 13:00 yeni plan plan 39238
  48. 4.10.2026 13:00 yeni plan plan 38467
  49. 4.10.2026 10:00 yeni plan plan 37976
  50. 4.10.2026 08:00 yeni plan plan 37420
  51. 2.10.2026 17:00 yeni plan plan 36501
  52. 2.10.2026 17:00 yeni plan plan 35786
  53. 2.10.2026 17:00 yeni plan plan 35040
  54. 2.10.2026 16:00 yeni plan plan 34096
  55. 2.10.2026 02:00 yeni plan plan 33651
  56. 2.10.2026 01:00 yeni plan plan 32953
  57. 2.10.2026 00:00 yeni plan plan 31731
  58. 1.10.2026 21:00 yeni plan plan 30677
  59. 1.10.2026 20:00 yeni plan plan 30247
  60. 1.10.2026 20:00 yeni plan plan 29597
  61. 1.10.2026 19:00 yeni plan plan 28872
  62. 1.10.2026 19:00 yeni plan plan 28193
  63. 1.10.2026 19:00 yeni plan plan 27522
  64. 30.09.2026 22:00 yeni plan plan 26821
  65. 30.09.2026 22:00 yeni plan plan 26175
  66. 30.09.2026 22:00 yeni plan plan 25495
  67. 30.09.2026 22:00 yeni plan plan 24545
  68. 30.09.2026 22:00 yeni plan plan 24251
  69. 30.09.2026 22:00 yeni plan plan 23721
  70. 30.09.2026 22:00 yeni plan plan 23075
  71. 30.09.2026 21:00 yeni plan plan 20437
  72. 30.09.2026 21:00 yeni plan plan 21104
  73. 30.09.2026 21:00 yeni plan plan 21754
  74. 30.09.2026 21:00 yeni plan plan 22397
  75. 30.09.2026 20:00 yeni plan plan 19740
  76. 30.09.2026 19:00 yeni plan plan 19021
  77. 30.09.2026 15:00 yeni plan plan 18352
  78. 30.09.2026 15:00 yeni plan plan 17720
  79. 30.09.2026 15:00 yeni plan plan 17068
  80. 30.09.2026 11:00 yeni plan plan 15542
  81. 30.09.2026 11:00 yeni plan plan 15209
  82. 30.09.2026 11:00 yeni plan plan 14571
  83. 30.09.2026 10:00 yeni plan plan 13965
  84. 30.09.2026 10:00 yeni plan plan 12869
  85. 30.09.2026 06:00 yeni plan plan 11955
  86. 30.09.2026 06:00 yeni plan plan 11180
  87. 30.09.2026 06:00 yeni plan plan 10617
  88. 30.09.2026 05:00 yeni plan plan 10054
  89. 30.09.2026 00:00 yeni plan plan 9018
  90. 29.09.2026 21:00 yeni plan plan 8562
  91. 29.09.2026 21:00 yeni plan plan 8134
  92. 29.09.2026 20:00 yeni plan plan 7654
  93. 28.09.2026 19:00 yeni plan plan 6463
  94. 28.09.2026 16:00 yeni plan plan 6015
  95. 28.09.2026 16:00 yeni plan plan 5983

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,10,1 0,14
2026-09-291070,10,1 0,14
2026-09-303490,10,1 0,14
2026-10-01490,10,1 0,14
2026-10-02830,10,1 0,14
2026-10-0310,20,2 0,212
2026-10-04570,10,1 0,17
2026-10-052110,10,1 0,14
2026-10-06500,10,1 0,24
2026-10-07490,10,1 0,14
2026-10-09330,10,1 0,24

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
19021100,10,14 30.09.2026 20:30 en iyi
3797630,10,113 4.10.2026 12:30
39984150,10,18 4.10.2026 20:30
1396580,10,14 30.09.2026 10:56
5460280,10,14 5.10.2026 17:49
2307580,10,14 30.09.2026 22:15
2682180,10,14 30.09.2026 22:56
5291180,10,14 5.10.2026 13:19
1706880,10,14 30.09.2026 15:32
5801380,10,14 5.10.2026 21:02
1005480,10,14 30.09.2026 05:49
3365180,10,14 2.10.2026 02:27
2887280,10,14 1.10.2026 19:31
11955160,10,14 30.09.2026 07:00
1835280,10,14 30.09.2026 15:51
11180160,10,14 30.09.2026 06:59
2239780,10,14 30.09.2026 21:37
12869160,10,14 30.09.2026 10:52
2752280,10,14 1.10.2026 19:13
40958100,10,16 4.10.2026 23:30
7958180,10,14 9.10.2026 14:27
813480,10,14 29.09.2026 21:26
6015250,10,14 28.09.2026 17:03
6530580,10,14 7.10.2026 13:55
6888380,10,14 7.10.2026 20:51
4727180,10,14 5.10.2026 10:00
2425180,10,14 30.09.2026 22:35
8048380,10,14 9.10.2026 14:29
7164380,10,14 8.10.2026 12:37
1520980,10,14 30.09.2026 11:08
1061780,10,14 30.09.2026 06:32
5711780,10,14 5.10.2026 20:19
34096110,10,14 2.10.2026 16:25
856280,10,14 29.09.2026 21:50
1772080,10,14 30.09.2026 15:42
2959780,10,14 1.10.2026 20:57
3578680,10,14 2.10.2026 17:32
5969680,10,14 5.10.2026 21:41
5627180,10,14 5.10.2026 18:28
1974080,10,14 30.09.2026 20:42
3846790,10,15 4.10.2026 13:30
4260790,10,15 5.10.2026 03:30
4055010,10,112 4.10.2026 21:30
5542380,10,14 5.10.2026 17:58
6303180,10,14 5.10.2026 23:04
7530980,10,14 8.10.2026 17:17
23721170,10,14 30.09.2026 22:30
61418160,10,14 5.10.2026 22:56
4807480,10,14 5.10.2026 10:03
1457180,10,14 30.09.2026 11:02
765480,10,14 29.09.2026 20:13
2175480,10,14 30.09.2026 21:34
7076280,10,14 8.10.2026 12:20
8252180,10,14 9.10.2026 19:25
5887580,10,14 5.10.2026 21:38
67287160,10,14 7.10.2026 20:50
4895680,10,14 5.10.2026 10:42
3504080,10,14 2.10.2026 17:24
7255580,10,14 8.10.2026 14:01
24545160,10,14 30.09.2026 22:38
7863880,10,14 9.10.2026 13:15
36501270,10,15 4.10.2026 08:30
49850160,10,14 5.10.2026 12:33
15542320,10,14 30.09.2026 11:22
7441080,10,14 8.10.2026 16:38
64631100,10,14 29.09.2026 18:42
6053380,10,14 5.10.2026 22:04
6634990,10,15 7.10.2026 20:40
7624680,10,14 8.10.2026 18:57
2819380,10,14 1.10.2026 19:19
3295380,10,14 2.10.2026 01:09
8152680,10,14 9.10.2026 17:45
2617580,10,14 30.09.2026 22:53
4180080,10,14 5.10.2026 00:27
3067790,10,15 1.10.2026 21:13
3923880,10,14 4.10.2026 13:31
4321690,10,15 5.10.2026 09:01
9018810,10,14 30.09.2026 05:42
7715290,10,15 8.10.2026 20:03
3742090,10,15 4.10.2026 09:30
598310,10,14 28.09.2026 16:24
6975490,10,15 8.10.2026 08:30
2549580,10,14 30.09.2026 22:40
45577160,10,14 5.10.2026 09:49
2043790,10,14 30.09.2026 21:30
51384160,10,14 5.10.2026 12:59
7353580,10,14 8.10.2026 16:34
3024780,10,14 1.10.2026 20:58
2110480,10,14 30.09.2026 21:32
5373080,10,14 5.10.2026 13:58
4434290,10,15 5.10.2026 09:30
63938500,10,14 6.10.2026 22:15
31731160,10,14 2.10.2026 00:06
8094710,30,315 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
–
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 #pair SET IsNew = 1 WHERE CaseID IS NULL

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.