Pahalı sorgular0x99166344D8F707D8
Demo modu

Sorgu 0x99166344D8F707D8

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

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

4.10.2026: 21 çalışma, ort. 0,2 ms5.10.2026: 72 çalışma, ort. 0,1 ms6.10.2026: 13 çalışma, ort. 0,1 ms7.10.2026: 17 çalışma, ort. 0,1 ms9.10.2026: 12 çalışma, ort. 0,2 ms max 72 çalışma max ort. süre 0,2 ms 4.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 82893
  2. 9.10.2026 19:00 yeni plan plan 82027
  3. 9.10.2026 17:00 yeni plan plan 81899
  4. 9.10.2026 17:00 yeni plan plan 81034
  5. 9.10.2026 14:00 yeni plan plan 80857
  6. 9.10.2026 14:00 yeni plan plan 79988
  7. 9.10.2026 14:00 yeni plan plan 79950
  8. 9.10.2026 14:00 yeni plan plan 79092
  9. 9.10.2026 13:00 yeni plan plan 79009
  10. 9.10.2026 13:00 yeni plan plan 78150
  11. 8.10.2026 19:00 yeni plan plan 77515
  12. 8.10.2026 19:00 yeni plan plan 76696
  13. 8.10.2026 18:00 yeni plan plan 76608
  14. 8.10.2026 18:00 yeni plan plan 75790
  15. 8.10.2026 17:00 yeni plan plan 75667
  16. 8.10.2026 17:00 yeni plan plan 74858
  17. 8.10.2026 16:00 yeni plan plan 74771
  18. 8.10.2026 16:00 yeni plan plan 73953
  19. 8.10.2026 16:00 yeni plan plan 73897
  20. 8.10.2026 16:00 yeni plan plan 73080
  21. 8.10.2026 14:00 yeni plan plan 72919
  22. 8.10.2026 14:00 yeni plan plan 72103
  23. 8.10.2026 12:00 yeni plan plan 70306
  24. 8.10.2026 12:00 yeni plan plan 71119
  25. 8.10.2026 12:00 yeni plan plan 71192
  26. 8.10.2026 12:00 yeni plan plan 72007
  27. 7.10.2026 20:00 yeni plan plan 70117
  28. 7.10.2026 20:00 yeni plan plan 69302
  29. 7.10.2026 20:00 yeni plan plan 69251
  30. 7.10.2026 20:00 yeni plan plan 68431
  31. 7.10.2026 20:00 yeni plan plan 67644
  32. 7.10.2026 20:00 yeni plan plan 66835
  33. 7.10.2026 20:00 yeni plan plan 66714
  34. 7.10.2026 20:00 yeni plan plan 65894
  35. 7.10.2026 13:00 yeni plan plan 65665
  36. 7.10.2026 13:00 yeni plan plan 64810
  37. 6.10.2026 00:00 yeni plan plan 64259
  38. 6.10.2026 00:00 yeni plan plan 63531
  39. 5.10.2026 23:00 yeni plan plan 63382
  40. 5.10.2026 23:00 yeni plan plan 62601
  41. 5.10.2026 22:00 yeni plan plan 61779
  42. 5.10.2026 22:00 yeni plan plan 60999
  43. 5.10.2026 22:00 yeni plan plan 60892
  44. 5.10.2026 22:00 yeni plan plan 60100
  45. 5.10.2026 21:00 yeni plan plan 60060
  46. 5.10.2026 21:00 yeni plan plan 59271
  47. 5.10.2026 21:00 yeni plan plan 59229
  48. 5.10.2026 21:00 yeni plan plan 58447
  49. 5.10.2026 21:00 yeni plan plan 58377
  50. 5.10.2026 20:00 yeni plan plan 57575
  51. 5.10.2026 20:00 yeni plan plan 57475
  52. 5.10.2026 20:00 yeni plan plan 56712
  53. 5.10.2026 18:00 yeni plan plan 56631
  54. 5.10.2026 18:00 yeni plan plan 55865
  55. 5.10.2026 17:00 yeni plan plan 55776
  56. 5.10.2026 17:00 yeni plan plan 55020
  57. 5.10.2026 17:00 yeni plan plan 54967
  58. 5.10.2026 17:00 yeni plan plan 54199
  59. 5.10.2026 13:00 yeni plan plan 54082
  60. 5.10.2026 13:00 yeni plan plan 53324
  61. 5.10.2026 13:00 yeni plan plan 53262
  62. 5.10.2026 13:00 yeni plan plan 52506
  63. 5.10.2026 12:00 yeni plan plan 51739
  64. 5.10.2026 12:00 yeni plan plan 50981
  65. 5.10.2026 12:00 yeni plan plan 50209
  66. 5.10.2026 12:00 yeni plan plan 49439
  67. 5.10.2026 10:00 tanım değişti rag.usp_Equivalence_MarkLegacy
  68. 5.10.2026 10:00 yeni plan plan 49317
  69. 5.10.2026 10:00 yeni plan plan 48561
  70. 5.10.2026 10:00 yeni plan plan 48430
  71. 5.10.2026 10:00 yeni plan plan 47676
  72. 5.10.2026 10:00 yeni plan plan 47625
  73. 5.10.2026 10:00 yeni plan plan 46871
  74. 5.10.2026 09:00 yeni plan plan 43909
  75. 5.10.2026 09:00 yeni plan plan 43958
  76. 5.10.2026 09:00 yeni plan plan 44696
  77. 5.10.2026 09:00 yeni plan plan 45153
  78. 5.10.2026 09:00 yeni plan plan 45958
  79. 5.10.2026 08:00 yeni plan plan 43124
  80. 5.10.2026 02:00 yeni plan plan 42964
  81. 5.10.2026 02:00 yeni plan plan 42237
  82. 5.10.2026 00:00 yeni plan plan 42160
  83. 5.10.2026 00:00 yeni plan plan 41439
  84. 4.10.2026 22:00 yeni plan plan 41315
  85. 4.10.2026 22:00 yeni plan plan 40596
  86. 4.10.2026 13:00 yeni plan plan 40335
  87. 4.10.2026 13:00 yeni plan plan 39622
  88. 4.10.2026 13:00 yeni plan plan 39581
  89. 4.10.2026 13:00 yeni plan plan 38873
  90. 4.10.2026 13:00 yeni plan plan 38805
  91. 4.10.2026 13:00 yeni plan plan 38102
  92. 4.10.2026 13:00 yeni plan plan 38044
  93. 4.10.2026 13:00 yeni plan plan 38030
  94. 4.10.2026 10:00 yeni plan plan 37931
  95. 4.10.2026 10:00 yeni plan plan 37904
  96. 4.10.2026 09:00 yeni plan plan 37870
  97. 4.10.2026 09:00 yeni plan plan 37828

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-04210,20,2 0,415
2026-10-05720,10,1 0,212
2026-10-06130,10,1 0,216
2026-10-07170,10,1 0,212
2026-10-09120,20,2 0,311

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
5927110,10,12 5.10.2026 21:39 en iyi
7210310,10,10 8.10.2026 14:01
5671210,10,12 5.10.2026 20:19
6010010,10,12 5.10.2026 22:02
7669610,10,10 8.10.2026 19:58
6589410,10,10 7.10.2026 20:11
6260110,10,10 5.10.2026 23:03
5332410,10,10 5.10.2026 13:57
4687110,10,10 5.10.2026 10:00
7909210,10,10 9.10.2026 14:27
7998810,10,10 9.10.2026 14:28
4515310,10,10 5.10.2026 09:47
4943910,10,10 5.10.2026 12:32
6353110,10,10 6.10.2026 00:17
6683510,10,10 7.10.2026 20:48
8103410,10,10 9.10.2026 17:44
6481010,10,10 7.10.2026 13:53
3962210,10,10 4.10.2026 13:45
3790410,10,10 4.10.2026 10:03
6099910,10,10 5.10.2026 22:52
4223710,10,10 5.10.2026 02:57
4143910,10,10 5.10.2026 00:27
8202710,10,10 9.10.2026 19:25
6843110,10,10 7.10.2026 20:50
5757510,10,12 5.10.2026 20:59
4059610,10,10 4.10.2026 22:06
4767610,10,10 5.10.2026 10:02
7485810,10,10 8.10.2026 17:16
6930210,10,10 7.10.2026 20:52
4312410,10,10 5.10.2026 08:54
5844710,10,12 5.10.2026 21:37
5250610,10,10 5.10.2026 13:19
3887310,10,10 4.10.2026 13:30
5586510,10,10 5.10.2026 18:27
7030610,10,10 8.10.2026 12:19
7579010,10,10 8.10.2026 18:57
5502010,10,10 5.10.2026 17:57
7395310,10,10 8.10.2026 16:37
7119210,10,10 8.10.2026 12:37
5419910,10,10 5.10.2026 17:49
3803010,10,10 4.10.2026 13:07
4762520,10,117 5.10.2026 10:00
8085720,10,117 9.10.2026 14:29
7291920,10,117 8.10.2026 14:01
4856110,10,10 5.10.2026 10:41
4395810,10,10 5.10.2026 09:08
5098110,10,10 5.10.2026 12:58
4296420,10,117 5.10.2026 02:59
7011720,10,117 7.10.2026 20:53
7900920,10,117 9.10.2026 13:15
7751520,10,117 8.10.2026 19:59
8189920,10,117 9.10.2026 17:45
6925120,10,117 7.10.2026 20:51
4131520,10,117 4.10.2026 22:07
7660820,10,117 8.10.2026 18:57
5326220,10,117 5.10.2026 13:20
3810210,10,14 4.10.2026 13:28
6338220,10,117 5.10.2026 23:04
6006020,10,117 5.10.2026 21:41
6764440,10,117 7.10.2026 20:50
7111920,10,117 8.10.2026 12:20
4843020,10,117 5.10.2026 10:03
5922920,10,117 5.10.2026 21:38
6566520,10,117 7.10.2026 13:55
8289320,10,117 9.10.2026 19:26
5577620,10,117 5.10.2026 17:58
5663120,20,117 5.10.2026 18:28
3793120,20,213 4.10.2026 10:03
64259120,20,217 6.10.2026 05:50
5020940,20,217 5.10.2026 12:33
6089220,20,217 5.10.2026 22:04
5747520,20,217 5.10.2026 20:19
4595840,20,217 5.10.2026 09:49
7477120,20,217 8.10.2026 16:38
3787020,20,213 4.10.2026 09:37
5837720,20,217 5.10.2026 21:02
4469620,20,217 5.10.2026 09:09
4390920,20,217 5.10.2026 09:01
3880520,20,213 4.10.2026 13:29
7566720,20,217 8.10.2026 17:17
4931720,20,217 5.10.2026 10:42
6177940,20,217 5.10.2026 22:57
5173920,20,217 5.10.2026 12:59
4033520,20,217 4.10.2026 13:46
4216020,20,217 5.10.2026 00:28
7200720,20,217 8.10.2026 12:37
3958120,20,213 4.10.2026 13:31
3804420,20,213 4.10.2026 13:08
6671420,20,217 7.10.2026 20:12
7389720,20,217 8.10.2026 16:34
5496720,20,217 5.10.2026 17:50
7995020,30,317 9.10.2026 14:28
5408220,30,317 5.10.2026 13:58
7815010,30,30 9.10.2026 13:15
7308010,60,60 8.10.2026 16:34
3782810,80,8123 4.10.2026 09:36 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 
(@note nvarchar(200))UPDATE r SET ValidationStatus = IIF(r.ValidationStatus = 'Valid', 'Warning', r.ValidationStatus),
                 ValidationNotes = IIF(r.ValidationStatus = 'Valid', CONCAT(@note, IIF(r.ValidationNotes IS NULL, N'', CHAR(10) + r.ValidationNotes)), r.ValidationNotes)
    FROM rag.AnalysisRecommendation AS r JOIN @ids AS i ON i.RecommendationID = r.RecommendationID

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.