Pahalı sorgular0x1D02C413A1F4D9D4
Demo modu

Sorgu 0x1D02C413A1F4D9D4

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,3 ms
Ort. CPU 0,2 ms
Bekleme payı %41,1
Ort. mantıksal okuma 15
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,2 ms27.09.2026: 9 çalışma, ort. 0,2 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,2 ms2.10.2026: 10 çalışma, ort. 0,2 ms4.10.2026: 5 çalışma, ort. 5,0 ms5.10.2026: 31 çalışma, ort. 0,2 ms6.10.2026: 6 çalışma, ort. 0,2 ms7.10.2026: 6 çalışma, ort. 0,2 ms9.10.2026: 4 çalışma, ort. 0,2 ms max 43 çalışma max ort. süre 5,0 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 82056
  2. 9.10.2026 17:00 yeni plan plan 81077
  3. 9.10.2026 14:00 yeni plan plan 80026
  4. 9.10.2026 14:00 yeni plan plan 79121
  5. 9.10.2026 13:00 yeni plan plan 78176
  6. 8.10.2026 19:00 yeni plan plan 76739
  7. 8.10.2026 18:00 yeni plan plan 75833
  8. 8.10.2026 17:00 yeni plan plan 74897
  9. 8.10.2026 16:00 yeni plan plan 73983
  10. 8.10.2026 16:00 yeni plan plan 73117
  11. 8.10.2026 14:00 yeni plan plan 72144
  12. 8.10.2026 12:00 yeni plan plan 71221
  13. 8.10.2026 12:00 yeni plan plan 70346
  14. 7.10.2026 20:00 yeni plan plan 69335
  15. 7.10.2026 20:00 yeni plan plan 65930
  16. 7.10.2026 20:00 yeni plan plan 67714
  17. 7.10.2026 20:00 yeni plan plan 68465
  18. 7.10.2026 20:00 yeni plan plan 66878
  19. 7.10.2026 13:00 yeni plan plan 64888
  20. 5.10.2026 23:00 yeni plan plan 62640
  21. 5.10.2026 22:00 yeni plan plan 60194
  22. 5.10.2026 22:00 yeni plan plan 61850
  23. 5.10.2026 22:00 yeni plan plan 61037
  24. 5.10.2026 21:00 yeni plan plan 59354
  25. 5.10.2026 21:00 yeni plan plan 57670
  26. 5.10.2026 21:00 yeni plan plan 58530
  27. 5.10.2026 20:00 yeni plan plan 56752
  28. 5.10.2026 18:00 yeni plan plan 55902
  29. 5.10.2026 17:00 yeni plan plan 55057
  30. 5.10.2026 17:00 yeni plan plan 54238
  31. 5.10.2026 13:00 yeni plan plan 52545
  32. 5.10.2026 13:00 yeni plan plan 53362
  33. 5.10.2026 12:00 yeni plan plan 51820
  34. 5.10.2026 12:00 yeni plan plan 51026
  35. 5.10.2026 12:00 yeni plan plan 50286
  36. 5.10.2026 12:00 yeni plan plan 49484
  37. 5.10.2026 10:00 yeni plan plan 46914
  38. 5.10.2026 10:00 yeni plan plan 47719
  39. 5.10.2026 10:00 yeni plan plan 48597
  40. 5.10.2026 09:00 yeni plan plan 43280
  41. 5.10.2026 09:00 yeni plan plan 43992
  42. 5.10.2026 09:00 yeni plan plan 45053
  43. 5.10.2026 09:00 yeni plan plan 46719
  44. 5.10.2026 09:00 yeni plan plan 46028
  45. 5.10.2026 09:00 yeni plan plan 45189
  46. 5.10.2026 09:00 yeni plan plan 44921
  47. 5.10.2026 02:00 yeni plan plan 42277
  48. 5.10.2026 00:00 yeni plan plan 41477
  49. 4.10.2026 22:00 yeni plan plan 40629
  50. 4.10.2026 13:00 yeni plan plan 39659
  51. 4.10.2026 13:00 yeni plan plan 38902
  52. 4.10.2026 13:00 yeni plan plan 38136
  53. 4.10.2026 08:00 yeni plan plan 37087
  54. 2.10.2026 17:00 yeni plan plan 35462
  55. 2.10.2026 17:00 yeni plan plan 36173
  56. 2.10.2026 17:00 yeni plan plan 34708
  57. 2.10.2026 16:00 yeni plan plan 34396
  58. 2.10.2026 02:00 yeni plan plan 33340
  59. 2.10.2026 01:00 yeni plan plan 32636
  60. 2.10.2026 00:00 yeni plan plan 32067
  61. 2.10.2026 00:00 yeni plan plan 31422
  62. 1.10.2026 21:00 yeni plan plan 30780
  63. 1.10.2026 20:00 yeni plan plan 29287
  64. 1.10.2026 20:00 yeni plan plan 29927
  65. 1.10.2026 19:00 yeni plan plan 28556
  66. 1.10.2026 19:00 yeni plan plan 27205
  67. 1.10.2026 19:00 yeni plan plan 27893
  68. 30.09.2026 22:00 yeni plan plan 22757
  69. 30.09.2026 22:00 yeni plan plan 25869
  70. 30.09.2026 22:00 yeni plan plan 25181
  71. 30.09.2026 22:00 yeni plan plan 23406
  72. 30.09.2026 22:00 yeni plan plan 26509
  73. 30.09.2026 22:00 yeni plan plan 24638
  74. 30.09.2026 21:00 yeni plan plan 20123
  75. 30.09.2026 21:00 yeni plan plan 21445
  76. 30.09.2026 21:00 yeni plan plan 22091
  77. 30.09.2026 21:00 yeni plan plan 20793
  78. 30.09.2026 20:00 yeni plan plan 19430
  79. 30.09.2026 19:00 yeni plan plan 18708
  80. 30.09.2026 15:00 yeni plan plan 16759
  81. 30.09.2026 15:00 yeni plan plan 17398
  82. 30.09.2026 15:00 yeni plan plan 18044
  83. 30.09.2026 11:00 yeni plan plan 14266
  84. 30.09.2026 11:00 yeni plan plan 14905
  85. 30.09.2026 11:00 yeni plan plan 16204
  86. 30.09.2026 11:00 yeni plan plan 15655
  87. 30.09.2026 10:00 yeni plan plan 12565
  88. 30.09.2026 10:00 yeni plan plan 13667
  89. 30.09.2026 10:00 yeni plan plan 13161
  90. 30.09.2026 07:00 yeni plan plan 12043
  91. 30.09.2026 06:00 yeni plan plan 11455
  92. 30.09.2026 06:00 yeni plan plan 10316
  93. 30.09.2026 06:00 yeni plan plan 10881
  94. 30.09.2026 05:00 yeni plan plan 9746
  95. 30.09.2026 00:00 yeni plan plan 8738
  96. 29.09.2026 21:00 yeni plan plan 8287
  97. 29.09.2026 21:00 yeni plan plan 7866
  98. 29.09.2026 20:00 yeni plan plan 7371
  99. 28.09.2026 16:00 yeni plan plan 6159
  100. 28.09.2026 12:00 yeni plan plan 5692
  101. 28.09.2026 12:00 yeni plan plan 5429
  102. 28.09.2026 12:00 yeni plan plan 5117
  103. 28.09.2026 12:00 yeni plan plan 4777
  104. 28.09.2026 10:00 yeni plan plan 4491
  105. 28.09.2026 09:00 yeni plan plan 3430
  106. 28.09.2026 09:00 yeni plan plan 3938
  107. 28.09.2026 09:00 yeni plan plan 4205
  108. 28.09.2026 09:00 yeni plan plan 3674
  109. 28.09.2026 08:00 yeni plan plan 3198
  110. 25.09.2026 02:00 yeni plan plan 2603
  111. 25.09.2026 02:00 yeni plan plan 2412
  112. 24.09.2026 06:00 yeni plan plan 1605
  113. 24.09.2026 06:00 yeni plan plan 1922
  114. 24.09.2026 06:00 yeni plan plan 1757
  115. 24.09.2026 02:00 yeni plan plan 1367
  116. 24.09.2026 01:00 yeni plan plan 1196
  117. 24.09.2026 01:00 yeni plan plan 1090

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-24160,20,2 0,220
2026-09-2520,20,2 0,215
2026-09-2790,20,2 0,215
2026-09-28190,20,2 0,315
2026-09-29130,20,2 0,315
2026-09-30430,20,2 0,215
2026-10-0160,20,2 0,315
2026-10-02100,20,2 0,315
2026-10-0450,35,0 19,215
2026-10-05310,20,2 0,215
2026-10-0660,20,2 0,215
2026-10-0760,20,2 0,215
2026-10-0940,20,2 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
160510,20,220 24.09.2026 06:32 en iyi
1426610,20,215 30.09.2026 11:02
2586910,20,215 30.09.2026 22:53
7912110,20,215 9.10.2026 14:27
4671910,20,215 5.10.2026 09:49
7489710,20,215 8.10.2026 17:16
1088110,20,215 30.09.2026 06:58
7034610,20,215 8.10.2026 12:19
6488810,20,215 7.10.2026 13:54
7817610,20,215 9.10.2026 13:15
175710,20,220 24.09.2026 06:33
241210,20,215 25.09.2026 02:44
4859710,20,215 5.10.2026 10:41
4492130,20,215 5.10.2026 09:40
4147710,20,215 5.10.2026 00:27
1256510,20,215 30.09.2026 10:51
786610,20,215 29.09.2026 21:26
3617330,20,215 2.10.2026 18:16
1675910,20,215 30.09.2026 15:32
343010,20,215 28.09.2026 09:33
737110,20,215 29.09.2026 20:13
5935410,20,215 5.10.2026 21:41
1145520,20,215 30.09.2026 06:59
1620410,20,215 30.09.2026 11:22
4948410,20,215 5.10.2026 12:32
8205610,20,215 9.10.2026 19:25
2789310,20,215 1.10.2026 19:18
4227710,20,215 5.10.2026 02:58
3078010,20,215 1.10.2026 21:13
2928710,20,215 1.10.2026 20:57
2518110,20,215 30.09.2026 22:39
1565520,20,215 30.09.2026 11:20
5336210,20,215 5.10.2026 13:57
6019410,20,215 5.10.2026 22:03
5102610,20,215 5.10.2026 12:58
6933510,20,215 7.10.2026 20:52
2463810,20,215 30.09.2026 22:38
2079310,20,215 30.09.2026 21:31
3470810,20,215 2.10.2026 17:24
136720,20,220 24.09.2026 02:10
6771410,20,215 7.10.2026 20:49
2603120,20,215 28.09.2026 01:05
5675210,20,215 5.10.2026 20:19
5423810,20,215 5.10.2026 17:49
5028610,20,215 5.10.2026 12:33
828710,20,215 29.09.2026 21:50
2340640,20,215 30.09.2026 22:37
3965910,20,215 4.10.2026 13:45
1204310,20,215 30.09.2026 07:00
4602810,20,215 5.10.2026 09:48
6846510,20,215 7.10.2026 20:50
7214410,20,215 8.10.2026 14:01
5853010,20,215 5.10.2026 21:37
4328010,20,215 5.10.2026 09:00
2275710,20,215 30.09.2026 22:15
1031610,20,215 30.09.2026 06:31
119610,20,220 24.09.2026 01:12
4771910,20,215 5.10.2026 10:02
8002610,20,215 9.10.2026 14:28
1943010,20,215 30.09.2026 20:42
4505310,20,215 5.10.2026 09:40
1316110,20,215 30.09.2026 10:52
7122110,20,215 8.10.2026 12:37
6687810,20,215 7.10.2026 20:48
4399210,20,215 5.10.2026 09:08
2650910,20,215 30.09.2026 22:56
1804410,20,215 30.09.2026 15:51
5254510,20,215 5.10.2026 13:19
1870810,20,215 30.09.2026 19:36
393810,20,215 28.09.2026 09:53
8738100,20,215 30.09.2026 05:42
4518910,20,215 5.10.2026 09:47
192280,20,220 24.09.2026 08:28
6264070,20,215 6.10.2026 05:49
7311710,20,215 8.10.2026 16:34
367410,20,215 28.09.2026 09:50
477720,20,215 28.09.2026 12:01
5767010,20,215 5.10.2026 21:02
4691410,20,215 5.10.2026 10:00
511720,20,215 28.09.2026 12:12
2209110,20,215 30.09.2026 21:36
6593010,20,215 7.10.2026 20:11
109030,20,220 24.09.2026 01:11
1490520,20,215 30.09.2026 11:15
6159150,20,215 29.09.2026 18:42
420510,20,215 28.09.2026 09:59
3263610,20,215 2.10.2026 01:09
7583310,20,215 8.10.2026 18:57
5182010,20,215 5.10.2026 12:59
569210,20,215 28.09.2026 12:43
319810,20,215 28.09.2026 08:44
974610,20,215 30.09.2026 05:49
3546210,20,215 2.10.2026 17:32
8107710,20,215 9.10.2026 17:44
5505710,20,215 5.10.2026 17:57
1739810,20,215 30.09.2026 15:42
449110,20,215 28.09.2026 10:35
3142210,20,215 2.10.2026 00:05
4062910,20,215 4.10.2026 22:06
6185010,20,215 5.10.2026 22:56
7673910,20,215 8.10.2026 19:58
3206710,20,215 2.10.2026 00:06
2012310,20,215 30.09.2026 21:24
2855610,20,215 1.10.2026 19:31
2992710,20,215 1.10.2026 20:58
7398310,20,215 8.10.2026 16:37
1366710,20,215 30.09.2026 10:56
6103710,20,215 5.10.2026 22:55
3334010,30,315 2.10.2026 02:27
3890210,30,315 4.10.2026 13:30
5590210,30,315 5.10.2026 18:27
3439610,30,315 2.10.2026 16:24
2144510,30,315 30.09.2026 21:34
3708710,30,315 4.10.2026 08:54
2720510,40,415 1.10.2026 19:13
542910,40,415 28.09.2026 12:16
38136123,90,315 4.10.2026 13:28 en kötü

Davranış

Wait kategorileri (QDS)
Latch:23
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.SqlText (TextHash, SqlText, FirstSeenUtc, LastSeenUtc) VALUES (@h, N'select 1', '2020-01-01', '2020-01-01')

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.