Pahalı sorgular0xFAF76ECF10D6E45B
Demo modu

Sorgu 0xFAF76ECF10D6E45B

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,1
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,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,2 ms4.10.2026: 57 çalışma, ort. 0,3 ms5.10.2026: 211 çalışma, ort. 0,3 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,3 ms max 349 çalışma max ort. süre 0,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 82520
  2. 9.10.2026 17:00 yeni plan plan 81525
  3. 9.10.2026 14:00 yeni plan plan 80946
  4. 9.10.2026 14:00 yeni plan plan 80482
  5. 9.10.2026 14:00 yeni plan plan 79580
  6. 9.10.2026 13:00 yeni plan plan 78637
  7. 8.10.2026 19:00 yeni plan plan 77151
  8. 8.10.2026 18:00 yeni plan plan 76245
  9. 8.10.2026 17:00 yeni plan plan 75308
  10. 8.10.2026 16:00 yeni plan plan 74409
  11. 8.10.2026 16:00 yeni plan plan 73534
  12. 8.10.2026 14:00 yeni plan plan 72554
  13. 8.10.2026 12:00 yeni plan plan 71642
  14. 8.10.2026 12:00 yeni plan plan 70761
  15. 7.10.2026 20:00 yeni plan plan 69753
  16. 7.10.2026 20:00 yeni plan plan 68882
  17. 7.10.2026 20:00 yeni plan plan 67286
  18. 7.10.2026 20:00 yeni plan plan 66348
  19. 7.10.2026 13:00 yeni plan plan 65304
  20. 6.10.2026 00:00 yeni plan plan 63937
  21. 5.10.2026 23:00 yeni plan plan 63030
  22. 5.10.2026 22:00 yeni plan plan 60532
  23. 5.10.2026 22:00 yeni plan plan 61417
  24. 5.10.2026 21:00 yeni plan plan 59695
  25. 5.10.2026 21:00 yeni plan plan 58874
  26. 5.10.2026 21:00 yeni plan plan 58012
  27. 5.10.2026 20:00 yeni plan plan 57116
  28. 5.10.2026 18:00 yeni plan plan 56270
  29. 5.10.2026 17:00 yeni plan plan 55422
  30. 5.10.2026 17:00 yeni plan plan 54601
  31. 5.10.2026 13:00 yeni plan plan 53729
  32. 5.10.2026 13:00 yeni plan plan 52910
  33. 5.10.2026 12:00 yeni plan plan 51383
  34. 5.10.2026 12:00 yeni plan plan 49849
  35. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  36. 5.10.2026 10:00 yeni plan plan 48955
  37. 5.10.2026 10:00 yeni plan plan 48073
  38. 5.10.2026 10:00 yeni plan plan 47270
  39. 5.10.2026 09:00 yeni plan plan 45576
  40. 5.10.2026 09:00 yeni plan plan 44341
  41. 5.10.2026 08:00 yeni plan plan 43215
  42. 5.10.2026 02:00 yeni plan plan 42606
  43. 5.10.2026 00:00 yeni plan plan 41799
  44. 4.10.2026 22:00 yeni plan plan 40957
  45. 4.10.2026 21:00 yeni plan plan 40549
  46. 4.10.2026 13:00 yeni plan plan 39983
  47. 4.10.2026 13:00 yeni plan plan 39237
  48. 4.10.2026 13:00 yeni plan plan 38466
  49. 4.10.2026 10:00 yeni plan plan 37975
  50. 4.10.2026 08:00 yeni plan plan 37419
  51. 2.10.2026 17:00 yeni plan plan 36500
  52. 2.10.2026 17:00 yeni plan plan 35785
  53. 2.10.2026 17:00 yeni plan plan 35039
  54. 2.10.2026 16:00 yeni plan plan 34095
  55. 2.10.2026 02:00 yeni plan plan 33650
  56. 2.10.2026 01:00 yeni plan plan 32952
  57. 2.10.2026 00:00 yeni plan plan 31730
  58. 1.10.2026 21:00 yeni plan plan 30676
  59. 1.10.2026 20:00 yeni plan plan 30246
  60. 1.10.2026 20:00 yeni plan plan 29596
  61. 1.10.2026 19:00 yeni plan plan 28871
  62. 1.10.2026 19:00 yeni plan plan 28192
  63. 1.10.2026 19:00 yeni plan plan 27521
  64. 30.09.2026 22:00 yeni plan plan 26820
  65. 30.09.2026 22:00 yeni plan plan 26174
  66. 30.09.2026 22:00 yeni plan plan 25494
  67. 30.09.2026 22:00 yeni plan plan 24544
  68. 30.09.2026 22:00 yeni plan plan 24250
  69. 30.09.2026 22:00 yeni plan plan 23720
  70. 30.09.2026 22:00 yeni plan plan 23074
  71. 30.09.2026 21:00 yeni plan plan 20436
  72. 30.09.2026 21:00 yeni plan plan 21103
  73. 30.09.2026 21:00 yeni plan plan 21753
  74. 30.09.2026 21:00 yeni plan plan 22396
  75. 30.09.2026 20:00 yeni plan plan 19739
  76. 30.09.2026 19:00 yeni plan plan 19020
  77. 30.09.2026 15:00 yeni plan plan 18351
  78. 30.09.2026 15:00 yeni plan plan 17719
  79. 30.09.2026 15:00 yeni plan plan 17067
  80. 30.09.2026 11:00 yeni plan plan 15541
  81. 30.09.2026 11:00 yeni plan plan 15208
  82. 30.09.2026 11:00 yeni plan plan 14570
  83. 30.09.2026 10:00 yeni plan plan 13964
  84. 30.09.2026 10:00 yeni plan plan 12868
  85. 30.09.2026 06:00 yeni plan plan 11954
  86. 30.09.2026 06:00 yeni plan plan 11179
  87. 30.09.2026 06:00 yeni plan plan 10616
  88. 30.09.2026 05:00 yeni plan plan 10053
  89. 30.09.2026 00:00 yeni plan plan 9017
  90. 29.09.2026 21:00 yeni plan plan 8561
  91. 29.09.2026 21:00 yeni plan plan 8133
  92. 29.09.2026 20:00 yeni plan plan 7653
  93. 28.09.2026 19:00 yeni plan plan 6462
  94. 28.09.2026 16:00 yeni plan plan 6014
  95. 28.09.2026 16:00 yeni plan plan 5982

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,30,3 0,34
2026-09-291070,30,3 0,44
2026-09-303490,30,3 0,44
2026-10-01490,30,3 0,45
2026-10-02830,30,3 0,44
2026-10-0310,20,2 0,218
2026-10-04570,30,3 0,47
2026-10-052110,30,3 0,44
2026-10-06500,30,3 0,35
2026-10-07490,30,3 0,34
2026-10-09330,30,3 0,44

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
3797530,10,113 4.10.2026 12:30 en iyi
598210,20,24 28.09.2026 16:24
4054910,20,212 4.10.2026 21:30
856180,20,24 29.09.2026 21:50
2682080,20,24 30.09.2026 22:56
2752180,20,24 1.10.2026 19:13
1396480,20,24 30.09.2026 10:56
813380,20,24 29.09.2026 21:26
1005380,20,24 30.09.2026 05:49
40957100,20,26 4.10.2026 23:30
1061680,20,24 30.09.2026 06:32
2887180,20,24 1.10.2026 19:31
3024680,20,24 1.10.2026 20:58
39983150,20,28 4.10.2026 20:30
5460180,20,24 5.10.2026 17:49
7863780,30,34 9.10.2026 13:15
2959680,30,34 1.10.2026 20:57
8048280,30,34 9.10.2026 14:29
6014250,30,34 28.09.2026 17:03
11954160,30,34 30.09.2026 07:00
5542280,30,34 5.10.2026 17:58
7958080,30,34 9.10.2026 14:27
19020100,30,34 30.09.2026 20:30
3578580,30,34 2.10.2026 17:32
3846690,30,35 4.10.2026 13:30
3365080,30,34 2.10.2026 02:27
5627080,30,34 5.10.2026 18:28
765380,30,34 29.09.2026 20:13
2617480,30,34 30.09.2026 22:53
11179160,30,34 30.09.2026 06:59
64621100,30,34 29.09.2026 18:42
1973980,30,34 30.09.2026 20:42
4895580,30,34 5.10.2026 10:42
4727080,30,34 5.10.2026 10:00
7076180,30,34 8.10.2026 12:20
12868160,30,34 30.09.2026 10:52
5711680,30,34 5.10.2026 20:19
6530480,30,34 7.10.2026 13:55
1835180,30,34 30.09.2026 15:51
7530880,30,34 8.10.2026 17:17
1771980,30,34 30.09.2026 15:42
2239680,30,34 30.09.2026 21:37
6634890,30,35 7.10.2026 20:40
34095110,30,34 2.10.2026 16:25
2307480,30,34 30.09.2026 22:15
3295280,30,34 2.10.2026 01:09
5801280,30,34 5.10.2026 21:02
3503980,30,34 2.10.2026 17:24
24544160,30,34 30.09.2026 22:38
1520880,30,34 30.09.2026 11:08
4807380,30,34 5.10.2026 10:03
67286160,30,34 7.10.2026 20:50
36500270,30,35 4.10.2026 08:30
23720170,30,34 30.09.2026 22:30
6975390,30,35 8.10.2026 08:30
4260690,30,35 5.10.2026 03:30
7164280,30,34 8.10.2026 12:37
5372980,30,34 5.10.2026 13:58
2175380,30,34 30.09.2026 21:34
8252080,30,34 9.10.2026 19:25
63937500,30,35 6.10.2026 22:15
6053280,30,34 5.10.2026 22:04
1706780,30,34 30.09.2026 15:32
6888280,30,34 7.10.2026 20:51
15541320,30,34 30.09.2026 11:22
2425080,30,34 30.09.2026 22:35
5291080,30,34 5.10.2026 13:19
4179980,30,34 5.10.2026 00:27
7255480,40,44 8.10.2026 14:01
7440980,40,44 8.10.2026 16:38
9017810,40,44 30.09.2026 05:42
6303080,40,44 5.10.2026 23:04
61417160,40,44 5.10.2026 22:56
31730160,40,44 2.10.2026 00:06
3067690,40,49 1.10.2026 21:13
5969580,40,44 5.10.2026 21:41
5887480,40,44 5.10.2026 21:38
45576160,40,44 5.10.2026 09:49
4434190,40,45 5.10.2026 09:30
7715190,40,45 8.10.2026 20:03
2110380,40,44 30.09.2026 21:32
4321590,40,45 5.10.2026 09:01
3741990,40,45 4.10.2026 09:30
8094610,40,415 9.10.2026 14:52
2549480,40,44 30.09.2026 22:40
3923780,40,44 4.10.2026 13:31
2043690,40,44 30.09.2026 21:30
8152580,40,44 9.10.2026 17:45
7624580,40,44 8.10.2026 18:57
2819280,40,44 1.10.2026 19:19
49849160,40,44 5.10.2026 12:33
51383160,40,44 5.10.2026 12:59
1457080,50,54 30.09.2026 11:02
7353480,70,74 8.10.2026 16:34 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 
(@maxNew int)WITH n AS (SELECT *, ROW_NUMBER() OVER (ORDER BY LoadMs DESC, ServerID, DatabaseName, query_id, NewPlanId) AS r FROM #pair WHERE CaseID IS NULL)
        DELETE FROM n WHERE r > @maxNew

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.