Pahalı sorgular0x8E5AA72606DE7FED
Demo modu

Sorgu 0x8E5AA72606DE7FED

SQL-1 · DB-11· rag.usp_PlanChange_Detect · dönem 2026-09-12 → 2026-10-11 · 1.043 çalışma · Pahalı sorgulara dön

Ort. süre 0,1 ms
Ort. CPU 0,1 ms
Bekleme payı %2
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: 84 çalışma, ort. 0,1 ms3.10.2026: 1 çalışma, ort. 0,1 ms4.10.2026: 57 çalışma, ort. 0,2 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 82547
  2. 9.10.2026 17:00 yeni plan plan 81552
  3. 9.10.2026 14:00 yeni plan plan 80973
  4. 9.10.2026 14:00 yeni plan plan 80509
  5. 9.10.2026 14:00 yeni plan plan 79607
  6. 9.10.2026 13:00 yeni plan plan 78664
  7. 8.10.2026 19:00 yeni plan plan 77178
  8. 8.10.2026 18:00 yeni plan plan 76272
  9. 8.10.2026 17:00 yeni plan plan 75335
  10. 8.10.2026 16:00 yeni plan plan 74436
  11. 8.10.2026 16:00 yeni plan plan 73561
  12. 8.10.2026 14:00 yeni plan plan 72581
  13. 8.10.2026 12:00 yeni plan plan 71669
  14. 8.10.2026 12:00 yeni plan plan 70788
  15. 7.10.2026 20:00 yeni plan plan 69780
  16. 7.10.2026 20:00 yeni plan plan 68909
  17. 7.10.2026 20:00 yeni plan plan 67313
  18. 7.10.2026 20:00 yeni plan plan 66375
  19. 7.10.2026 13:00 yeni plan plan 65331
  20. 6.10.2026 00:00 yeni plan plan 63964
  21. 5.10.2026 23:00 yeni plan plan 63057
  22. 5.10.2026 22:00 yeni plan plan 60559
  23. 5.10.2026 22:00 yeni plan plan 61444
  24. 5.10.2026 21:00 yeni plan plan 59722
  25. 5.10.2026 21:00 yeni plan plan 58901
  26. 5.10.2026 21:00 yeni plan plan 58039
  27. 5.10.2026 20:00 yeni plan plan 57143
  28. 5.10.2026 18:00 yeni plan plan 56297
  29. 5.10.2026 17:00 yeni plan plan 55449
  30. 5.10.2026 17:00 yeni plan plan 54628
  31. 5.10.2026 13:00 yeni plan plan 53756
  32. 5.10.2026 13:00 yeni plan plan 52937
  33. 5.10.2026 12:00 yeni plan plan 51410
  34. 5.10.2026 12:00 yeni plan plan 49876
  35. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  36. 5.10.2026 10:00 yeni plan plan 48982
  37. 5.10.2026 10:00 yeni plan plan 48100
  38. 5.10.2026 10:00 yeni plan plan 47297
  39. 5.10.2026 09:00 yeni plan plan 45603
  40. 5.10.2026 09:00 yeni plan plan 44368
  41. 5.10.2026 08:00 yeni plan plan 43243
  42. 5.10.2026 02:00 yeni plan plan 42633
  43. 5.10.2026 00:00 yeni plan plan 41826
  44. 4.10.2026 22:00 yeni plan plan 40984
  45. 4.10.2026 21:00 yeni plan plan 40576
  46. 4.10.2026 13:00 yeni plan plan 40010
  47. 4.10.2026 13:00 yeni plan plan 39264
  48. 4.10.2026 13:00 yeni plan plan 38493
  49. 4.10.2026 10:00 yeni plan plan 38002
  50. 4.10.2026 08:00 yeni plan plan 37446
  51. 2.10.2026 17:00 yeni plan plan 36527
  52. 2.10.2026 17:00 yeni plan plan 35812
  53. 2.10.2026 17:00 yeni plan plan 35066
  54. 2.10.2026 16:00 yeni plan plan 34076
  55. 2.10.2026 02:00 yeni plan plan 33677
  56. 2.10.2026 01:00 yeni plan plan 32979
  57. 2.10.2026 00:00 yeni plan plan 31757
  58. 1.10.2026 21:00 yeni plan plan 30709
  59. 1.10.2026 20:00 yeni plan plan 30273
  60. 1.10.2026 20:00 yeni plan plan 29623
  61. 1.10.2026 19:00 yeni plan plan 28898
  62. 1.10.2026 19:00 yeni plan plan 28219
  63. 1.10.2026 19:00 yeni plan plan 27548
  64. 30.09.2026 22:00 yeni plan plan 26847
  65. 30.09.2026 22:00 yeni plan plan 26201
  66. 30.09.2026 22:00 yeni plan plan 25521
  67. 30.09.2026 22:00 yeni plan plan 24571
  68. 30.09.2026 22:00 yeni plan plan 24277
  69. 30.09.2026 22:00 yeni plan plan 23747
  70. 30.09.2026 22:00 yeni plan plan 23101
  71. 30.09.2026 21:00 yeni plan plan 20463
  72. 30.09.2026 21:00 yeni plan plan 21130
  73. 30.09.2026 21:00 yeni plan plan 21780
  74. 30.09.2026 21:00 yeni plan plan 22423
  75. 30.09.2026 20:00 yeni plan plan 19766
  76. 30.09.2026 19:00 yeni plan plan 19047
  77. 30.09.2026 15:00 yeni plan plan 18378
  78. 30.09.2026 15:00 yeni plan plan 17746
  79. 30.09.2026 15:00 yeni plan plan 17094
  80. 30.09.2026 11:00 yeni plan plan 15568
  81. 30.09.2026 11:00 yeni plan plan 15235
  82. 30.09.2026 11:00 yeni plan plan 14597
  83. 30.09.2026 10:00 yeni plan plan 13991
  84. 30.09.2026 10:00 yeni plan plan 12895
  85. 30.09.2026 06:00 yeni plan plan 11981
  86. 30.09.2026 06:00 yeni plan plan 11206
  87. 30.09.2026 06:00 yeni plan plan 10643
  88. 30.09.2026 05:00 yeni plan plan 10080
  89. 30.09.2026 00:00 yeni plan plan 9044
  90. 29.09.2026 21:00 yeni plan plan 8588
  91. 29.09.2026 21:00 yeni plan plan 8160
  92. 29.09.2026 20:00 yeni plan plan 7680
  93. 28.09.2026 19:00 yeni plan plan 6489
  94. 28.09.2026 16:00 yeni plan plan 6041
  95. 28.09.2026 16:00 yeni plan plan 6008

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-02840,10,1 0,14
2026-10-0310,10,1 0,112
2026-10-04570,20,2 1,37
2026-10-052110,10,1 0,14
2026-10-06500,10,1 0,14
2026-10-07490,10,1 0,14
2026-10-09330,10,1 0,34

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
5714380,10,14 5.10.2026 20:19 en iyi
816080,10,14 29.09.2026 21:26
1008080,10,14 30.09.2026 05:50
2310180,10,14 30.09.2026 22:15
5803980,10,14 5.10.2026 21:02
4810080,10,14 5.10.2026 10:03
2552180,10,14 30.09.2026 22:40
5544980,10,14 5.10.2026 17:58
3367780,10,14 2.10.2026 02:27
12895160,10,14 30.09.2026 10:52
11206160,10,14 30.09.2026 06:59
6055980,10,14 5.10.2026 22:04
1459780,10,14 30.09.2026 11:02
5629780,10,14 5.10.2026 18:28
7078880,10,14 8.10.2026 12:20
4729780,10,14 5.10.2026 10:00
2962380,10,14 1.10.2026 20:57
1523580,10,14 30.09.2026 11:08
8254780,10,14 9.10.2026 19:25
7166980,10,14 8.10.2026 12:37
1976680,10,14 30.09.2026 20:42
4182680,10,14 5.10.2026 00:27
3027380,10,14 1.10.2026 20:58
8050980,10,14 9.10.2026 14:29
858880,10,14 29.09.2026 21:50
5462880,10,14 5.10.2026 17:49
3297980,10,14 2.10.2026 01:09
7533580,10,14 8.10.2026 17:17
4898280,10,14 5.10.2026 10:42
2242380,10,14 30.09.2026 21:37
6890980,10,14 7.10.2026 20:51
23747170,10,14 30.09.2026 22:30
6533180,10,14 7.10.2026 13:55
1399180,10,14 30.09.2026 10:56
1709480,10,14 30.09.2026 15:32
768080,10,14 29.09.2026 20:13
7627280,10,14 8.10.2026 18:57
7356180,10,14 8.10.2026 16:34
6305780,10,14 5.10.2026 23:04
1064380,10,14 30.09.2026 06:32
1837880,10,14 30.09.2026 15:51
45603160,10,14 5.10.2026 09:49
11981160,10,14 30.09.2026 07:00
2178080,10,14 30.09.2026 21:34
2427780,10,14 30.09.2026 22:35
67313160,10,14 7.10.2026 20:50
5972280,10,14 5.10.2026 21:41
63964500,10,14 6.10.2026 22:15
2684780,10,14 30.09.2026 22:56
600810,10,14 28.09.2026 16:24
8155280,10,14 9.10.2026 17:45
19047100,10,14 30.09.2026 20:30
7960780,10,14 9.10.2026 14:27
2889880,10,14 1.10.2026 19:31
24571160,10,14 30.09.2026 22:38
6637590,10,15 7.10.2026 20:40
64891100,10,14 29.09.2026 18:42
3581280,10,14 2.10.2026 17:32
4436890,10,15 5.10.2026 09:30
2046390,10,14 30.09.2026 21:30
3506680,10,14 2.10.2026 17:24
2113080,10,14 30.09.2026 21:32
2754880,10,14 1.10.2026 19:13
7866480,10,14 9.10.2026 13:15
3070990,10,15 1.10.2026 21:13
5890180,10,14 5.10.2026 21:38
7443680,10,14 8.10.2026 16:38
5375680,10,14 5.10.2026 13:58
7258180,10,14 8.10.2026 14:01
1774680,10,14 30.09.2026 15:42
9044810,10,14 30.09.2026 05:42
3744690,10,15 4.10.2026 09:30
49876160,10,14 5.10.2026 12:33
4263390,10,15 5.10.2026 03:30
2620180,10,14 30.09.2026 22:53
5293780,10,14 5.10.2026 13:19
3926480,10,14 4.10.2026 13:31
34076120,10,14 2.10.2026 16:25
31757160,10,14 2.10.2026 00:06
7717890,10,15 8.10.2026 20:03
51410160,10,14 5.10.2026 12:59
4324390,10,15 5.10.2026 09:01
2821980,10,14 1.10.2026 19:19
3849390,10,15 4.10.2026 13:30
36527270,10,15 4.10.2026 08:30
6041250,10,14 28.09.2026 17:03
15568320,10,14 30.09.2026 11:22
61444160,10,14 5.10.2026 22:56
4057610,10,112 4.10.2026 21:30
6978090,10,15 8.10.2026 08:30
40984100,20,26 4.10.2026 23:30
3800230,20,213 4.10.2026 12:30
8097310,30,315 9.10.2026 14:52
40010150,40,48 4.10.2026 20:30 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 
(@rows int)SET @rows = (SELECT COUNT(*) FROM #pair)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.