Pahalı sorgular0x3383025BA57CA797
Demo modu

Sorgu 0x3383025BA57CA797

SQL-1 · DB-11· test_PlanChange.test etki ozeti iptal ve hatayi ayri sayar birimleri cevirir · dönem 2026-09-12 → 2026-10-11 · 125 çalışma · Pahalı sorgulara dön

Ort. süre 1,1 ms
Ort. CPU 1,1 ms
Bekleme payı %2,5
Ort. mantıksal okuma 122
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: 6 çalışma, ort. 1,5 ms29.09.2026: 13 çalışma, ort. 1,1 ms30.09.2026: 43 çalışma, ort. 1,1 ms1.10.2026: 6 çalışma, ort. 1,1 ms2.10.2026: 10 çalışma, ort. 1,0 ms4.10.2026: 5 çalışma, ort. 1,3 ms5.10.2026: 26 çalışma, ort. 1,1 ms6.10.2026: 6 çalışma, ort. 1,0 ms7.10.2026: 6 çalışma, ort. 0,9 ms9.10.2026: 4 çalışma, ort. 1,0 ms max 43 çalışma max ort. süre 1,5 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 82548
  2. 9.10.2026 17:00 yeni plan plan 81556
  3. 9.10.2026 14:00 yeni plan plan 79624
  4. 9.10.2026 14:00 yeni plan plan 80526
  5. 9.10.2026 13:00 yeni plan plan 78665
  6. 8.10.2026 19:00 yeni plan plan 77216
  7. 8.10.2026 18:00 yeni plan plan 76299
  8. 8.10.2026 17:00 yeni plan plan 75338
  9. 8.10.2026 16:00 yeni plan plan 73581
  10. 8.10.2026 16:00 yeni plan plan 74473
  11. 8.10.2026 14:00 yeni plan plan 72585
  12. 8.10.2026 12:00 yeni plan plan 70789
  13. 8.10.2026 12:00 yeni plan plan 71680
  14. 7.10.2026 20:00 yeni plan plan 66402
  15. 7.10.2026 20:00 yeni plan plan 67323
  16. 7.10.2026 20:00 yeni plan plan 68114
  17. 7.10.2026 20:00 yeni plan plan 68949
  18. 7.10.2026 20:00 yeni plan plan 69796
  19. 7.10.2026 13:00 yeni plan plan 65364
  20. 6.10.2026 00:00 yeni plan plan 63985
  21. 5.10.2026 23:00 yeni plan plan 63081
  22. 5.10.2026 22:00 yeni plan plan 60570
  23. 5.10.2026 22:00 yeni plan plan 61445
  24. 5.10.2026 22:00 yeni plan plan 62192
  25. 5.10.2026 21:00 yeni plan plan 58043
  26. 5.10.2026 21:00 yeni plan plan 58907
  27. 5.10.2026 21:00 yeni plan plan 59744
  28. 5.10.2026 20:00 yeni plan plan 57154
  29. 5.10.2026 18:00 yeni plan plan 56303
  30. 5.10.2026 17:00 yeni plan plan 54668
  31. 5.10.2026 17:00 yeni plan plan 55450
  32. 5.10.2026 13:00 yeni plan plan 52975
  33. 5.10.2026 13:00 yeni plan plan 53762
  34. 5.10.2026 12:00 yeni plan plan 49882
  35. 5.10.2026 12:00 yeni plan plan 50616
  36. 5.10.2026 12:00 yeni plan plan 51421
  37. 5.10.2026 12:00 yeni plan plan 52166
  38. 5.10.2026 10:00 yeni plan plan 47311
  39. 5.10.2026 10:00 yeni plan plan 48135
  40. 5.10.2026 10:00 yeni plan plan 48992
  41. 5.10.2026 09:00 yeni plan plan 43599
  42. 5.10.2026 09:00 yeni plan plan 44374
  43. 5.10.2026 09:00 yeni plan plan 45623
  44. 5.10.2026 09:00 yeni plan plan 46380
  45. 5.10.2026 02:00 yeni plan plan 42639
  46. 5.10.2026 00:00 yeni plan plan 41866
  47. 4.10.2026 22:00 yeni plan plan 40987
  48. 4.10.2026 13:00 yeni plan plan 38529
  49. 4.10.2026 13:00 yeni plan plan 39291
  50. 4.10.2026 13:00 yeni plan plan 40048
  51. 4.10.2026 08:00 yeni plan plan 37484
  52. 2.10.2026 17:00 yeni plan plan 35092
  53. 2.10.2026 17:00 yeni plan plan 35844
  54. 2.10.2026 17:00 yeni plan plan 36560
  55. 2.10.2026 16:00 yeni plan plan 34645
  56. 2.10.2026 02:00 yeni plan plan 33702
  57. 2.10.2026 01:00 yeni plan plan 33001
  58. 2.10.2026 00:00 yeni plan plan 31774
  59. 2.10.2026 00:00 yeni plan plan 32340
  60. 1.10.2026 21:00 yeni plan plan 31105
  61. 1.10.2026 20:00 yeni plan plan 29624
  62. 1.10.2026 20:00 yeni plan plan 30295
  63. 1.10.2026 19:00 yeni plan plan 27556
  64. 1.10.2026 19:00 yeni plan plan 28251
  65. 1.10.2026 19:00 yeni plan plan 28904
  66. 30.09.2026 22:00 yeni plan plan 23133
  67. 30.09.2026 22:00 yeni plan plan 23770
  68. 30.09.2026 22:00 yeni plan plan 24278
  69. 30.09.2026 22:00 yeni plan plan 24922
  70. 30.09.2026 22:00 yeni plan plan 25559
  71. 30.09.2026 22:00 yeni plan plan 26229
  72. 30.09.2026 22:00 yeni plan plan 26848
  73. 30.09.2026 21:00 yeni plan plan 20469
  74. 30.09.2026 21:00 yeni plan plan 21171
  75. 30.09.2026 21:00 yeni plan plan 21801
  76. 30.09.2026 21:00 yeni plan plan 22463
  77. 30.09.2026 20:00 yeni plan plan 19806
  78. 30.09.2026 19:00 yeni plan plan 19048
  79. 30.09.2026 15:00 yeni plan plan 17122
  80. 30.09.2026 15:00 yeni plan plan 17779
  81. 30.09.2026 15:00 yeni plan plan 18391
  82. 30.09.2026 11:00 yeni plan plan 14598
  83. 30.09.2026 11:00 yeni plan plan 15263
  84. 30.09.2026 11:00 yeni plan plan 15940
  85. 30.09.2026 11:00 yeni plan plan 16465
  86. 30.09.2026 10:00 yeni plan plan 12909
  87. 30.09.2026 10:00 yeni plan plan 13445
  88. 30.09.2026 10:00 yeni plan plan 14014
  89. 30.09.2026 07:00 yeni plan plan 12337
  90. 30.09.2026 06:00 yeni plan plan 10694
  91. 30.09.2026 06:00 yeni plan plan 11209
  92. 30.09.2026 06:00 yeni plan plan 11725
  93. 30.09.2026 05:00 yeni plan plan 10092
  94. 30.09.2026 00:00 yeni plan plan 9059
  95. 29.09.2026 21:00 yeni plan plan 8171
  96. 29.09.2026 21:00 yeni plan plan 8592
  97. 29.09.2026 20:00 yeni plan plan 7710
  98. 28.09.2026 16:00 yeni plan plan 6094

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2861,01,5 2,3121
2026-09-29131,11,1 1,5125
2026-09-30431,11,1 1,5121
2026-10-0161,11,1 1,3124
2026-10-02101,01,0 1,3122
2026-10-0451,31,3 2,2121
2026-10-05261,11,1 1,5122
2026-10-0661,01,0 1,1126
2026-10-0760,90,9 1,0122
2026-10-0941,01,0 1,0128

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
6979610,80,8119 7.10.2026 20:53 en iyi
6894910,90,9126 7.10.2026 20:51
6308110,90,9126 5.10.2026 23:04
6536410,90,9125 7.10.2026 13:55
4098710,90,9132 4.10.2026 22:07
859210,90,9115 29.09.2026 21:50
2622910,90,9122 30.09.2026 22:53
7258510,90,9126 8.10.2026 14:01
3300110,90,9138 2.10.2026 01:09
7168010,90,9136 8.10.2026 12:37
3177410,90,9115 2.10.2026 00:05
3852910,90,9128 4.10.2026 13:29
817110,90,9116 29.09.2026 21:26
7962410,90,9136 9.10.2026 14:27
5376210,90,9128 5.10.2026 13:58
6640210,90,9119 7.10.2026 20:12
6811410,90,9125 7.10.2026 20:50
4813510,90,9115 5.10.2026 10:03
1980611,01,0118 30.09.2026 20:42
771011,01,0116 29.09.2026 20:13
7629911,01,0135 8.10.2026 18:57
7721611,01,0136 8.10.2026 19:59
8155611,01,0115 9.10.2026 17:45
2890411,01,0126 1.10.2026 19:31
6398561,01,0126 6.10.2026 05:50
3656031,01,0121 2.10.2026 18:17
3110511,01,0116 1.10.2026 21:13
1526321,01,0116 30.09.2026 11:15
3509211,01,0122 2.10.2026 17:24
1120911,01,0121 30.09.2026 06:58
8052611,01,0135 9.10.2026 14:29
8254811,01,0115 9.10.2026 19:25
7447311,01,0126 8.10.2026 16:38
3370211,01,0118 2.10.2026 02:27
2492211,01,0115 30.09.2026 22:38
4437411,01,0121 5.10.2026 09:09
5890711,01,0115 5.10.2026 21:38
4899211,01,0121 5.10.2026 10:42
7358111,01,0120 8.10.2026 16:34
4359911,01,0116 5.10.2026 09:01
2825111,01,0125 1.10.2026 19:19
6057011,01,0125 5.10.2026 22:03
1594021,01,0118 30.09.2026 11:20
3029511,01,0115 1.10.2026 20:58
6732311,01,0115 7.10.2026 20:49
5630311,01,0115 5.10.2026 18:28
7866511,01,0127 9.10.2026 13:15
1401411,01,0118 30.09.2026 10:56
2313311,01,0115 30.09.2026 22:15
5715411,01,0115 5.10.2026 20:19
7078911,11,1129 8.10.2026 12:19
3464511,11,1115 2.10.2026 16:25
4731111,11,1135 5.10.2026 10:00
5297511,11,1116 5.10.2026 13:19
1777911,11,1116 30.09.2026 15:42
2117111,11,1126 30.09.2026 21:32
9059101,11,1122 30.09.2026 05:42
5974411,11,1126 5.10.2026 21:41
4562311,11,1130 5.10.2026 09:48
5466811,11,1117 5.10.2026 17:49
1459811,11,1118 30.09.2026 11:02
1172521,11,1126 30.09.2026 06:59
4988211,11,1129 5.10.2026 12:32
3748411,11,1115 4.10.2026 08:55
5142111,11,1116 5.10.2026 12:58
1233711,11,1130 30.09.2026 07:00
2962411,11,1129 1.10.2026 20:57
2377021,11,1116 30.09.2026 22:19
4263911,11,1117 5.10.2026 02:58
2427821,11,1127 30.09.2026 22:38
1904811,21,2118 30.09.2026 19:36
1646511,21,2116 30.09.2026 11:22
4638011,21,2122 5.10.2026 09:49
4186611,21,2126 5.10.2026 00:27
1009211,20,9125 30.09.2026 05:49
2684811,21,2118 30.09.2026 22:56
2246311,21,2127 30.09.2026 21:37
1344511,21,2121 30.09.2026 10:52
5804311,21,2117 5.10.2026 21:02
6094161,31,1125 29.09.2026 18:42
2555911,31,3119 30.09.2026 22:40
3584411,31,3122 2.10.2026 17:32
6219211,31,3126 5.10.2026 22:56
2046911,31,3119 30.09.2026 21:24
5545011,31,3115 5.10.2026 17:58
3234011,31,3123 2.10.2026 00:06
2755611,41,4135 1.10.2026 19:13
7533811,41,0125 8.10.2026 17:17
1290911,41,3129 30.09.2026 10:51
1839111,41,4119 30.09.2026 15:51
4004811,41,4115 4.10.2026 13:45
1712211,41,4120 30.09.2026 15:32
6144511,51,5136 5.10.2026 22:55
5061611,51,5126 5.10.2026 12:33
5216611,51,5118 5.10.2026 12:59
2180111,61,6127 30.09.2026 21:34
1069412,01,5135 30.09.2026 06:32
3929112,42,4115 4.10.2026 13:31 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:2
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 
SELECT TOP (0) * INTO #expected FROM #actual

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.