Pahalı sorgular0x2CD6353D75471852
Demo modu

Sorgu 0x2CD6353D75471852

SQL-1 · DB-11· test_Sessions.test staginge gelmeyen ama ornegin referansladigi metin ve planin LastSeenUtc tazelenir · dönem 2026-09-13 → 2026-10-12 · 170 ç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 17
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

24.09.2026: 16 çalışma, ort. 0,2 ms25.09.2026: 2 çalışma, ort. 0,1 ms27.09.2026: 9 çalışma, ort. 0,1 ms28.09.2026: 19 çalışma, ort. 0,2 ms29.09.2026: 13 çalışma, ort. 0,2 ms30.09.2026: 43 çalışma, ort. 0,2 ms1.10.2026: 6 çalışma, ort. 0,1 ms2.10.2026: 10 çalışma, ort. 0,2 ms4.10.2026: 5 çalışma, ort. 0,1 ms5.10.2026: 31 çalışma, ort. 0,2 ms6.10.2026: 6 çalışma, ort. 0,1 ms7.10.2026: 6 çalışma, ort. 0,1 ms9.10.2026: 4 çalışma, ort. 0,1 ms max 43 çalışma max ort. süre 0,2 ms 24.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 82058
  2. 9.10.2026 17:00 yeni plan plan 81079
  3. 9.10.2026 14:00 yeni plan plan 79123
  4. 9.10.2026 14:00 yeni plan plan 80028
  5. 9.10.2026 13:00 yeni plan plan 78178
  6. 8.10.2026 19:00 yeni plan plan 76741
  7. 8.10.2026 18:00 yeni plan plan 75835
  8. 8.10.2026 17:00 yeni plan plan 74899
  9. 8.10.2026 16:00 yeni plan plan 73985
  10. 8.10.2026 16:00 yeni plan plan 73119
  11. 8.10.2026 14:00 yeni plan plan 72146
  12. 8.10.2026 12:00 yeni plan plan 71223
  13. 8.10.2026 12:00 yeni plan plan 70348
  14. 7.10.2026 20:00 yeni plan plan 66880
  15. 7.10.2026 20:00 yeni plan plan 67716
  16. 7.10.2026 20:00 yeni plan plan 69337
  17. 7.10.2026 20:00 yeni plan plan 65932
  18. 7.10.2026 20:00 yeni plan plan 68467
  19. 7.10.2026 13:00 yeni plan plan 64890
  20. 5.10.2026 23:00 yeni plan plan 62642
  21. 5.10.2026 22:00 yeni plan plan 61039
  22. 5.10.2026 22:00 yeni plan plan 61852
  23. 5.10.2026 22:00 yeni plan plan 60196
  24. 5.10.2026 21:00 yeni plan plan 59356
  25. 5.10.2026 21:00 yeni plan plan 57672
  26. 5.10.2026 21:00 yeni plan plan 58532
  27. 5.10.2026 20:00 yeni plan plan 56754
  28. 5.10.2026 18:00 yeni plan plan 55904
  29. 5.10.2026 17:00 yeni plan plan 54240
  30. 5.10.2026 17:00 yeni plan plan 55059
  31. 5.10.2026 13:00 yeni plan plan 52547
  32. 5.10.2026 13:00 yeni plan plan 53364
  33. 5.10.2026 12:00 yeni plan plan 51822
  34. 5.10.2026 12:00 yeni plan plan 50288
  35. 5.10.2026 12:00 yeni plan plan 51028
  36. 5.10.2026 12:00 yeni plan plan 49486
  37. 5.10.2026 10:00 yeni plan plan 47721
  38. 5.10.2026 10:00 yeni plan plan 48599
  39. 5.10.2026 10:00 yeni plan plan 46916
  40. 5.10.2026 09:00 yeni plan plan 45055
  41. 5.10.2026 09:00 yeni plan plan 43994
  42. 5.10.2026 09:00 yeni plan plan 44923
  43. 5.10.2026 09:00 yeni plan plan 43282
  44. 5.10.2026 09:00 yeni plan plan 46030
  45. 5.10.2026 09:00 yeni plan plan 45191
  46. 5.10.2026 09:00 yeni plan plan 46721
  47. 5.10.2026 02:00 yeni plan plan 42279
  48. 5.10.2026 00:00 yeni plan plan 41479
  49. 4.10.2026 22:00 yeni plan plan 40631
  50. 4.10.2026 13:00 yeni plan plan 39661
  51. 4.10.2026 13:00 yeni plan plan 38138
  52. 4.10.2026 13:00 yeni plan plan 38904
  53. 4.10.2026 08:00 yeni plan plan 37089
  54. 2.10.2026 17:00 yeni plan plan 34710
  55. 2.10.2026 17:00 yeni plan plan 35464
  56. 2.10.2026 17:00 yeni plan plan 36175
  57. 2.10.2026 16:00 yeni plan plan 34398
  58. 2.10.2026 02:00 yeni plan plan 33342
  59. 2.10.2026 01:00 yeni plan plan 32638
  60. 2.10.2026 00:00 yeni plan plan 32069
  61. 2.10.2026 00:00 yeni plan plan 31424
  62. 1.10.2026 21:00 yeni plan plan 30782
  63. 1.10.2026 20:00 yeni plan plan 29929
  64. 1.10.2026 20:00 yeni plan plan 29289
  65. 1.10.2026 19:00 yeni plan plan 27895
  66. 1.10.2026 19:00 yeni plan plan 27207
  67. 1.10.2026 19:00 yeni plan plan 28558
  68. 30.09.2026 22:00 yeni plan plan 26511
  69. 30.09.2026 22:00 yeni plan plan 24640
  70. 30.09.2026 22:00 yeni plan plan 23408
  71. 30.09.2026 22:00 yeni plan plan 25871
  72. 30.09.2026 22:00 yeni plan plan 25183
  73. 30.09.2026 22:00 yeni plan plan 22759
  74. 30.09.2026 21:00 yeni plan plan 22093
  75. 30.09.2026 21:00 yeni plan plan 20795
  76. 30.09.2026 21:00 yeni plan plan 21447
  77. 30.09.2026 21:00 yeni plan plan 20125
  78. 30.09.2026 20:00 yeni plan plan 19432
  79. 30.09.2026 19:00 yeni plan plan 18710
  80. 30.09.2026 15:00 yeni plan plan 16761
  81. 30.09.2026 15:00 yeni plan plan 18046
  82. 30.09.2026 15:00 yeni plan plan 17400
  83. 30.09.2026 11:00 yeni plan plan 15657
  84. 30.09.2026 11:00 yeni plan plan 14268
  85. 30.09.2026 11:00 yeni plan plan 14907
  86. 30.09.2026 11:00 yeni plan plan 16206
  87. 30.09.2026 10:00 yeni plan plan 12567
  88. 30.09.2026 10:00 yeni plan plan 13163
  89. 30.09.2026 10:00 yeni plan plan 13669
  90. 30.09.2026 07:00 yeni plan plan 12045
  91. 30.09.2026 06:00 yeni plan plan 10318
  92. 30.09.2026 06:00 yeni plan plan 11457
  93. 30.09.2026 06:00 yeni plan plan 10883
  94. 30.09.2026 05:00 yeni plan plan 9748
  95. 30.09.2026 00:00 yeni plan plan 8740
  96. 29.09.2026 21:00 yeni plan plan 7868
  97. 29.09.2026 21:00 yeni plan plan 8289
  98. 29.09.2026 20:00 yeni plan plan 7373
  99. 28.09.2026 16:00 yeni plan plan 6161
  100. 28.09.2026 12:00 yeni plan plan 5431
  101. 28.09.2026 12:00 yeni plan plan 4779
  102. 28.09.2026 12:00 yeni plan plan 5694
  103. 28.09.2026 12:00 yeni plan plan 5119
  104. 28.09.2026 10:00 yeni plan plan 4493
  105. 28.09.2026 09:00 yeni plan plan 3940
  106. 28.09.2026 09:00 yeni plan plan 4207
  107. 28.09.2026 09:00 yeni plan plan 3676
  108. 28.09.2026 09:00 yeni plan plan 3432
  109. 28.09.2026 08:00 yeni plan plan 3200
  110. 25.09.2026 02:00 yeni plan plan 2605
  111. 25.09.2026 02:00 yeni plan plan 2414
  112. 24.09.2026 06:00 yeni plan plan 1759
  113. 24.09.2026 06:00 yeni plan plan 1924
  114. 24.09.2026 06:00 yeni plan plan 1607
  115. 24.09.2026 02:00 yeni plan plan 1369
  116. 24.09.2026 01:00 yeni plan plan 1198
  117. 24.09.2026 01:00 yeni plan plan 1092

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-24160,20,2 0,220
2026-09-2520,10,1 0,115
2026-09-2790,10,1 0,115
2026-09-28190,20,2 0,220
2026-09-29130,10,2 0,221
2026-09-30430,20,2 0,318
2026-10-0160,10,1 0,215
2026-10-02100,20,2 0,216
2026-10-0450,10,1 0,215
2026-10-05310,20,2 0,216
2026-10-0660,10,1 0,116
2026-10-0760,10,1 0,216
2026-10-0940,10,1 0,215

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
367610,10,115 28.09.2026 09:50 en iyi
6019610,10,115 5.10.2026 22:03
4691610,10,115 5.10.2026 10:00
4063110,10,115 4.10.2026 22:06
5675410,10,115 5.10.2026 20:19
5767210,10,115 5.10.2026 21:02
1088310,10,115 30.09.2026 06:58
2789510,10,115 1.10.2026 19:18
4672110,10,115 5.10.2026 09:49
1871010,10,118 30.09.2026 19:36
5336410,10,115 5.10.2026 13:57
2587110,10,115 30.09.2026 22:53
175910,10,120 24.09.2026 06:33
2928910,10,115 1.10.2026 20:57
4859910,10,115 5.10.2026 10:41
160710,10,120 24.09.2026 06:32
1204510,10,115 30.09.2026 07:00
1676110,10,115 30.09.2026 15:32
1620610,10,115 30.09.2026 11:22
828910,10,115 29.09.2026 21:50
1804610,10,115 30.09.2026 15:51
2992910,10,115 1.10.2026 20:58
1565720,10,115 30.09.2026 11:20
449310,10,118 28.09.2026 10:35
6771610,10,115 7.10.2026 20:49
3966110,10,115 4.10.2026 13:45
4948610,10,121 5.10.2026 12:32
394010,10,115 28.09.2026 09:53
4603010,10,115 5.10.2026 09:48
6489010,10,115 7.10.2026 13:54
2275910,10,121 30.09.2026 22:15
5935610,10,115 5.10.2026 21:41
7122310,10,118 8.10.2026 12:37
3708910,10,115 4.10.2026 08:54
3471010,10,118 2.10.2026 17:24
241410,10,115 25.09.2026 02:44
2720710,10,115 1.10.2026 19:13
2518310,10,115 30.09.2026 22:39
786810,10,115 29.09.2026 21:26
974810,10,121 30.09.2026 05:49
4147910,10,115 5.10.2026 00:27
343210,10,115 28.09.2026 09:33
5853210,10,115 5.10.2026 21:37
4772110,10,115 5.10.2026 10:02
5182210,10,115 5.10.2026 12:59
5424010,10,115 5.10.2026 17:49
2079510,10,121 30.09.2026 21:31
8205810,10,115 9.10.2026 19:25
5590410,10,115 5.10.2026 18:27
4399410,10,115 5.10.2026 09:08
7311910,10,115 8.10.2026 16:34
2464010,10,118 30.09.2026 22:38
1145720,10,115 30.09.2026 06:59
4519110,10,115 5.10.2026 09:47
7489910,10,118 8.10.2026 17:16
3206910,10,118 2.10.2026 00:06
1943210,10,118 30.09.2026 20:42
6593210,10,115 7.10.2026 20:11
4505510,10,115 5.10.2026 09:40
1490720,10,115 30.09.2026 11:15
737310,10,115 29.09.2026 20:13
569410,10,115 28.09.2026 12:43
7214610,10,118 8.10.2026 14:01
7912310,10,115 9.10.2026 14:27
7398510,10,115 8.10.2026 16:37
3078210,10,115 1.10.2026 21:13
136920,10,120 24.09.2026 02:10
6264270,10,116 6.10.2026 05:49
1256710,10,115 30.09.2026 10:51
6933710,10,118 7.10.2026 20:52
3334210,10,115 2.10.2026 02:27
1366910,10,115 30.09.2026 10:56
5028810,10,115 5.10.2026 12:33
2012510,10,115 30.09.2026 21:24
1316310,10,115 30.09.2026 10:52
7034810,10,115 8.10.2026 12:19
8002810,10,115 9.10.2026 14:28
1740010,10,115 30.09.2026 15:42
4227910,10,115 5.10.2026 02:58
2605120,10,115 28.09.2026 01:05
5505910,10,115 5.10.2026 17:57
420710,10,118 28.09.2026 09:59
5254710,10,115 5.10.2026 13:19
3813810,10,115 4.10.2026 13:28
3617530,10,115 2.10.2026 18:16
1426810,20,115 30.09.2026 11:02
543110,20,215 28.09.2026 12:16
7583510,20,215 8.10.2026 18:57
7817810,20,215 9.10.2026 13:15
6161150,20,220 29.09.2026 18:42
4492330,20,215 5.10.2026 09:40
2651110,20,215 30.09.2026 22:56
4328210,20,218 5.10.2026 09:00
8107910,20,215 9.10.2026 17:44
6185210,20,218 5.10.2026 22:56
3546410,20,215 2.10.2026 17:32
3263810,20,215 2.10.2026 01:09
2340840,20,219 30.09.2026 22:37
477920,20,254 28.09.2026 12:01
2855810,20,215 1.10.2026 19:31
2209310,20,215 30.09.2026 21:36
6846710,20,215 7.10.2026 20:50
7674110,20,215 8.10.2026 19:58
8740100,20,224 30.09.2026 05:42
109230,20,220 24.09.2026 01:11
3142410,20,218 2.10.2026 00:05
6688010,20,218 7.10.2026 20:48
320010,20,218 28.09.2026 08:44
192480,20,220 24.09.2026 08:28
511920,20,215 28.09.2026 12:12
3890410,20,215 4.10.2026 13:30
6103910,20,218 5.10.2026 22:55
119810,20,220 24.09.2026 01:12
3439810,30,318 2.10.2026 16:24
2144710,30,321 30.09.2026 21:34
5102810,90,915 5.10.2026 12:58
1031811,01,015 30.09.2026 06:31 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 
(@h binary(32))INSERT perf.Stg_SessionSample (ServerID, SampleID, CaptureTimeUtc, IsHeadBlocker, session_id, SqlTextHash, StatementTextHash, query_plan_hash)
    VALUES (1, 10, '2026-09-20T10:00:00', 0, 55, @h, @h, 0x0102030405060708)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.