Pahalı sorgular0xFBAD1B52DC971571
Demo modu

Sorgu 0xFBAD1B52DC971571

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

Ort. süre 0,3 ms
Ort. CPU 0,3 ms
Bekleme payı %0,6
Ort. mantıksal okuma 8
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

5.10.2026: 66 çalışma, ort. 0,3 ms6.10.2026: 13 çalışma, ort. 0,3 ms7.10.2026: 19 çalışma, ort. 0,2 ms9.10.2026: 14 çalışma, ort. 0,3 ms max 66 çalışma max ort. süre 0,3 ms 5.10.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 82961
  2. 9.10.2026 19:00 yeni plan plan 82894
  3. 9.10.2026 19:00 yeni plan plan 82028
  4. 9.10.2026 18:00 yeni plan plan 81986
  5. 9.10.2026 17:00 yeni plan plan 81900
  6. 9.10.2026 17:00 yeni plan plan 81035
  7. 9.10.2026 14:00 yeni plan plan 80922
  8. 9.10.2026 14:00 yeni plan plan 80858
  9. 9.10.2026 14:00 yeni plan plan 79989
  10. 9.10.2026 14:00 yeni plan plan 79951
  11. 9.10.2026 14:00 yeni plan plan 79093
  12. 9.10.2026 13:00 yeni plan plan 79010
  13. 9.10.2026 13:00 yeni plan plan 78151
  14. 8.10.2026 19:00 yeni plan plan 77516
  15. 8.10.2026 19:00 yeni plan plan 76697
  16. 8.10.2026 18:00 yeni plan plan 76609
  17. 8.10.2026 18:00 yeni plan plan 75791
  18. 8.10.2026 17:00 yeni plan plan 75736
  19. 8.10.2026 17:00 yeni plan plan 75668
  20. 8.10.2026 17:00 yeni plan plan 74859
  21. 8.10.2026 16:00 yeni plan plan 73081
  22. 8.10.2026 16:00 yeni plan plan 73898
  23. 8.10.2026 16:00 yeni plan plan 73954
  24. 8.10.2026 16:00 yeni plan plan 74772
  25. 8.10.2026 15:00 yeni plan plan 73030
  26. 8.10.2026 15:00 yeni plan plan 73012
  27. 8.10.2026 14:00 yeni plan plan 72920
  28. 8.10.2026 14:00 yeni plan plan 72104
  29. 8.10.2026 12:00 yeni plan plan 72008
  30. 8.10.2026 12:00 yeni plan plan 71193
  31. 8.10.2026 12:00 yeni plan plan 71120
  32. 8.10.2026 12:00 yeni plan plan 70307
  33. 7.10.2026 20:00 yeni plan plan 70118
  34. 7.10.2026 20:00 yeni plan plan 69303
  35. 7.10.2026 20:00 yeni plan plan 69252
  36. 7.10.2026 20:00 yeni plan plan 68432
  37. 7.10.2026 20:00 yeni plan plan 67645
  38. 7.10.2026 20:00 yeni plan plan 66836
  39. 7.10.2026 20:00 yeni plan plan 66715
  40. 7.10.2026 20:00 yeni plan plan 65895
  41. 7.10.2026 18:00 yeni plan plan 65842
  42. 7.10.2026 16:00 yeni plan plan 65771
  43. 7.10.2026 13:00 yeni plan plan 65666
  44. 7.10.2026 13:00 yeni plan plan 64811
  45. 6.10.2026 00:00 yeni plan plan 64260
  46. 6.10.2026 00:00 yeni plan plan 63532
  47. 5.10.2026 23:00 yeni plan plan 63383
  48. 5.10.2026 23:00 yeni plan plan 62602
  49. 5.10.2026 22:00 yeni plan plan 61780
  50. 5.10.2026 22:00 yeni plan plan 61000
  51. 5.10.2026 22:00 yeni plan plan 60893
  52. 5.10.2026 22:00 yeni plan plan 60101
  53. 5.10.2026 21:00 yeni plan plan 60061
  54. 5.10.2026 21:00 yeni plan plan 59272
  55. 5.10.2026 21:00 yeni plan plan 59230
  56. 5.10.2026 21:00 yeni plan plan 58448
  57. 5.10.2026 21:00 yeni plan plan 58378
  58. 5.10.2026 20:00 yeni plan plan 57576
  59. 5.10.2026 20:00 yeni plan plan 57476
  60. 5.10.2026 20:00 yeni plan plan 56713
  61. 5.10.2026 18:00 yeni plan plan 56632
  62. 5.10.2026 18:00 yeni plan plan 55866
  63. 5.10.2026 17:00 yeni plan plan 55777
  64. 5.10.2026 17:00 yeni plan plan 55021
  65. 5.10.2026 17:00 yeni plan plan 54968
  66. 5.10.2026 17:00 yeni plan plan 54200
  67. 5.10.2026 13:00 yeni plan plan 52507
  68. 5.10.2026 13:00 yeni plan plan 53263
  69. 5.10.2026 13:00 yeni plan plan 53325
  70. 5.10.2026 13:00 yeni plan plan 54083
  71. 5.10.2026 12:00 yeni plan plan 51740
  72. 5.10.2026 12:00 yeni plan plan 50982
  73. 5.10.2026 12:00 yeni plan plan 50210
  74. 5.10.2026 12:00 yeni plan plan 49440
  75. 5.10.2026 10:00 tanım değişti rag.usp_Equivalence_MarkLegacy
  76. 5.10.2026 10:00 yeni plan plan 49318
  77. 5.10.2026 10:00 yeni plan plan 48562
  78. 5.10.2026 10:00 yeni plan plan 48530
  79. 5.10.2026 10:00 yeni plan plan 48521
  80. 5.10.2026 10:00 yeni plan plan 48431
  81. 5.10.2026 10:00 yeni plan plan 47677
  82. 5.10.2026 10:00 yeni plan plan 47626
  83. 5.10.2026 10:00 yeni plan plan 46872
  84. 5.10.2026 09:00 yeni plan plan 45959
  85. 5.10.2026 09:00 yeni plan plan 45154
  86. 5.10.2026 09:00 yeni plan plan 45004
  87. 5.10.2026 09:00 yeni plan plan 44997
  88. 5.10.2026 09:00 yeni plan plan 44816
  89. 5.10.2026 09:00 yeni plan plan 44810

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-05660,30,3 0,48
2026-10-06130,30,3 0,411
2026-10-07190,20,2 0,38
2026-10-09140,30,3 0,47

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
5671310,10,10 5.10.2026 20:19 en iyi
6010110,10,10 5.10.2026 22:02
7573610,10,10 8.10.2026 17:47
6589510,10,10 7.10.2026 20:11
5332510,10,10 5.10.2026 13:57
7210410,10,10 8.10.2026 14:01
8092210,10,10 9.10.2026 14:46
4515410,10,10 5.10.2026 09:47
8296110,10,10 9.10.2026 19:41
7669710,10,10 8.10.2026 19:58
4481010,20,20 5.10.2026 09:37
6353210,20,20 6.10.2026 00:17
7909310,20,20 9.10.2026 14:27
6260210,20,20 5.10.2026 23:03
8198610,20,20 9.10.2026 18:19
7815110,20,20 9.10.2026 13:15
4944010,20,20 5.10.2026 12:32
6683610,20,20 7.10.2026 20:48
6843210,20,20 7.10.2026 20:50
4500410,20,20 5.10.2026 09:40
8202810,20,20 9.10.2026 19:25
4767710,20,20 5.10.2026 10:02
4852110,20,20 5.10.2026 10:22
5586610,20,20 5.10.2026 18:27
4499710,20,20 5.10.2026 09:39
8103510,20,20 9.10.2026 17:44
7395410,20,20 8.10.2026 16:37
5098210,20,20 5.10.2026 12:58
6481110,20,20 7.10.2026 13:53
6577110,20,20 7.10.2026 16:18
4687210,20,20 5.10.2026 10:00
5502110,20,20 5.10.2026 17:57
7579110,20,20 8.10.2026 18:57
4481610,20,20 5.10.2026 09:37
4856210,20,20 5.10.2026 10:41
6100010,20,20 5.10.2026 22:52
6930310,20,20 7.10.2026 20:52
5927210,20,20 5.10.2026 21:39
6584210,20,20 7.10.2026 18:44
4853010,20,20 5.10.2026 10:37
5757610,20,20 5.10.2026 20:59
7119310,20,20 8.10.2026 12:37
5844810,20,20 5.10.2026 21:37
7998910,20,20 9.10.2026 14:28
7303010,20,20 8.10.2026 15:44
7030710,20,20 8.10.2026 12:19
7485910,20,20 8.10.2026 17:16
7308110,20,20 8.10.2026 16:34
5663220,20,212 5.10.2026 18:28
4762620,20,212 5.10.2026 10:00
5250710,20,20 5.10.2026 13:19
5420010,20,20 5.10.2026 17:49
7011820,20,212 7.10.2026 20:53
8085820,30,313 9.10.2026 14:29
6925220,30,312 7.10.2026 20:51
8190020,30,313 9.10.2026 17:45
7751620,30,312 8.10.2026 19:59
6089320,30,312 5.10.2026 22:04
7112020,30,312 8.10.2026 12:20
4843120,30,312 5.10.2026 10:03
6006120,30,312 5.10.2026 21:41
6566620,30,313 7.10.2026 13:55
6764540,30,312 7.10.2026 20:50
8289420,30,312 9.10.2026 19:26
6338320,30,313 5.10.2026 23:04
5326320,30,313 5.10.2026 13:20
7477220,30,312 8.10.2026 16:38
5923020,30,313 5.10.2026 21:38
7660920,30,312 8.10.2026 18:57
5747620,30,313 5.10.2026 20:19
7389820,30,312 8.10.2026 16:34
4595940,30,312 5.10.2026 09:49
5408320,30,314 5.10.2026 13:58
6178040,30,312 5.10.2026 22:57
64260120,30,312 6.10.2026 05:50
5837820,30,312 5.10.2026 21:02
7200820,30,313 8.10.2026 12:37
7901020,30,312 9.10.2026 13:15
5021040,30,312 5.10.2026 12:33
6671520,30,312 7.10.2026 20:12
7566820,30,313 8.10.2026 17:17
5577720,30,313 5.10.2026 17:58
5174020,40,412 5.10.2026 12:59
5496820,40,412 5.10.2026 17:50
7301210,40,40 8.10.2026 15:38
4931820,50,512 5.10.2026 10:42
7292020,50,513 8.10.2026 14:01
7995120,50,512 9.10.2026 14:28 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 
INSERT rag.RecommendationEquivalence (RecommendationID, Status, ReasonCode, ParamSets, Note, CheckedUtc, BaseStatus)
    SELECT i.RecommendationID, 'Untestable', 'Legacy', 0, N'eşdeğerlik test edilmedi (eski analiz)', DBA.fn_Now(), i.BaseStatus FROM @ids AS i

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.