Pahalı sorgular0x91960C3985CAE9B6
Demo modu

Sorgu 0x91960C3985CAE9B6

SQL-1 · DB-11· test_PlanChange.test olay araligi degisim anini kapsiyorsa sira belirsiz · dönem 2026-09-12 → 2026-10-11 · 126 çalışma · Pahalı sorgulara dön

Ort. süre 1,1 ms
Ort. CPU 1,1 ms
Bekleme payı %0
Ort. mantıksal okuma 86
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,0 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: 11 çalışma, ort. 1,1 ms4.10.2026: 5 çalışma, ort. 1,1 ms5.10.2026: 26 çalışma, ort. 1,3 ms6.10.2026: 6 çalışma, ort. 1,1 ms7.10.2026: 6 çalışma, ort. 1,0 ms9.10.2026: 4 çalışma, ort. 1,1 ms max 43 çalışma max ort. süre 1,3 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 82579
  2. 9.10.2026 17:00 yeni plan plan 81571
  3. 9.10.2026 14:00 yeni plan plan 79644
  4. 9.10.2026 14:00 yeni plan plan 80521
  5. 9.10.2026 13:00 yeni plan plan 78678
  6. 8.10.2026 19:00 yeni plan plan 77142
  7. 8.10.2026 18:00 yeni plan plan 76236
  8. 8.10.2026 17:00 yeni plan plan 75373
  9. 8.10.2026 16:00 yeni plan plan 73576
  10. 8.10.2026 16:00 yeni plan plan 74444
  11. 8.10.2026 14:00 yeni plan plan 72591
  12. 8.10.2026 12:00 yeni plan plan 70825
  13. 8.10.2026 12:00 yeni plan plan 71709
  14. 7.10.2026 20:00 yeni plan plan 66411
  15. 7.10.2026 20:00 yeni plan plan 67328
  16. 7.10.2026 20:00 yeni plan plan 68095
  17. 7.10.2026 20:00 yeni plan plan 68934
  18. 7.10.2026 20:00 yeni plan plan 69790
  19. 7.10.2026 13:00 yeni plan plan 65371
  20. 6.10.2026 00:00 yeni plan plan 63931
  21. 5.10.2026 23:00 yeni plan plan 63086
  22. 5.10.2026 22:00 yeni plan plan 60577
  23. 5.10.2026 22:00 yeni plan plan 61450
  24. 5.10.2026 22:00 yeni plan plan 62213
  25. 5.10.2026 21:00 yeni plan plan 58060
  26. 5.10.2026 21:00 yeni plan plan 58912
  27. 5.10.2026 21:00 yeni plan plan 59749
  28. 5.10.2026 20:00 yeni plan plan 57159
  29. 5.10.2026 18:00 yeni plan plan 56308
  30. 5.10.2026 17:00 yeni plan plan 54644
  31. 5.10.2026 17:00 yeni plan plan 55473
  32. 5.10.2026 13:00 yeni plan plan 52963
  33. 5.10.2026 13:00 yeni plan plan 53792
  34. 5.10.2026 12:00 yeni plan plan 49912
  35. 5.10.2026 12:00 yeni plan plan 50602
  36. 5.10.2026 12:00 yeni plan plan 51414
  37. 5.10.2026 12:00 yeni plan plan 52161
  38. 5.10.2026 10:00 yeni plan plan 47316
  39. 5.10.2026 10:00 yeni plan plan 48067
  40. 5.10.2026 10:00 yeni plan plan 49021
  41. 5.10.2026 09:00 yeni plan plan 43593
  42. 5.10.2026 09:00 yeni plan plan 44404
  43. 5.10.2026 09:00 yeni plan plan 45618
  44. 5.10.2026 09:00 yeni plan plan 46369
  45. 5.10.2026 02:00 yeni plan plan 42670
  46. 5.10.2026 00:00 yeni plan plan 41861
  47. 4.10.2026 22:00 yeni plan plan 41022
  48. 4.10.2026 13:00 yeni plan plan 38500
  49. 4.10.2026 13:00 yeni plan plan 39231
  50. 4.10.2026 13:00 yeni plan plan 40018
  51. 4.10.2026 08:00 yeni plan plan 37410
  52. 2.10.2026 17:00 yeni plan plan 35073
  53. 2.10.2026 17:00 yeni plan plan 35776
  54. 2.10.2026 17:00 yeni plan plan 36549
  55. 2.10.2026 16:00 yeni plan plan 34077
  56. 2.10.2026 02:00 yeni plan plan 33697
  57. 2.10.2026 01:00 yeni plan plan 32987
  58. 2.10.2026 00:00 yeni plan plan 31761
  59. 2.10.2026 00:00 yeni plan plan 32349
  60. 1.10.2026 21:00 yeni plan plan 31110
  61. 1.10.2026 20:00 yeni plan plan 29632
  62. 1.10.2026 20:00 yeni plan plan 30310
  63. 1.10.2026 19:00 yeni plan plan 27561
  64. 1.10.2026 19:00 yeni plan plan 28256
  65. 1.10.2026 19:00 yeni plan plan 28924
  66. 30.09.2026 22:00 yeni plan plan 23128
  67. 30.09.2026 22:00 yeni plan plan 23711
  68. 30.09.2026 22:00 yeni plan plan 24283
  69. 30.09.2026 22:00 yeni plan plan 24927
  70. 30.09.2026 22:00 yeni plan plan 25485
  71. 30.09.2026 22:00 yeni plan plan 26168
  72. 30.09.2026 22:00 yeni plan plan 26856
  73. 30.09.2026 21:00 yeni plan plan 20485
  74. 30.09.2026 21:00 yeni plan plan 21162
  75. 30.09.2026 21:00 yeni plan plan 21807
  76. 30.09.2026 21:00 yeni plan plan 22436
  77. 30.09.2026 20:00 yeni plan plan 19774
  78. 30.09.2026 19:00 yeni plan plan 19086
  79. 30.09.2026 15:00 yeni plan plan 17112
  80. 30.09.2026 15:00 yeni plan plan 17784
  81. 30.09.2026 15:00 yeni plan plan 18396
  82. 30.09.2026 11:00 yeni plan plan 14634
  83. 30.09.2026 11:00 yeni plan plan 15270
  84. 30.09.2026 11:00 yeni plan plan 15924
  85. 30.09.2026 11:00 yeni plan plan 16470
  86. 30.09.2026 10:00 yeni plan plan 12924
  87. 30.09.2026 10:00 yeni plan plan 13450
  88. 30.09.2026 10:00 yeni plan plan 13955
  89. 30.09.2026 07:00 yeni plan plan 12317
  90. 30.09.2026 06:00 yeni plan plan 10685
  91. 30.09.2026 06:00 yeni plan plan 11214
  92. 30.09.2026 06:00 yeni plan plan 11737
  93. 30.09.2026 05:00 yeni plan plan 10098
  94. 30.09.2026 00:00 yeni plan plan 9064
  95. 29.09.2026 21:00 yeni plan plan 8124
  96. 29.09.2026 21:00 yeni plan plan 8597
  97. 29.09.2026 20:00 yeni plan plan 7641
  98. 28.09.2026 16:00 yeni plan plan 6099

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2861,01,0 1,188
2026-09-29131,11,1 1,585
2026-09-30431,11,1 1,486
2026-10-0161,11,1 1,387
2026-10-02111,11,1 1,685
2026-10-0451,11,1 1,284
2026-10-05261,31,3 2,187
2026-10-0661,11,1 1,186
2026-10-0761,01,0 1,285
2026-10-0941,11,1 1,286

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
7444410,90,982 8.10.2026 16:38 en iyi
6308610,90,986 5.10.2026 23:04
6537110,90,982 7.10.2026 13:55
2963210,90,982 1.10.2026 20:57
2756110,90,986 1.10.2026 19:13
4636910,90,982 5.10.2026 09:49
3369710,90,985 2.10.2026 02:27
6979010,90,986 7.10.2026 20:53
6732810,90,984 7.10.2026 20:49
4001810,90,987 4.10.2026 13:45
6893410,90,982 7.10.2026 20:51
6809510,90,989 7.10.2026 20:50
1009810,90,982 30.09.2026 05:49
1231710,90,982 30.09.2026 07:00
1068510,90,983 30.09.2026 06:32
4186110,90,986 5.10.2026 00:27
7082511,01,083 8.10.2026 12:20
1173721,01,085 30.09.2026 06:59
7259111,01,082 8.10.2026 14:01
812411,01,083 29.09.2026 21:26
4806711,01,082 5.10.2026 10:03
3507311,01,083 2.10.2026 17:24
3298711,01,088 2.10.2026 01:09
859711,01,085 29.09.2026 21:50
3654931,01,085 2.10.2026 18:17
4902111,01,082 5.10.2026 10:42
7714211,01,085 8.10.2026 19:59
3577611,01,086 2.10.2026 17:32
5806011,01,086 5.10.2026 21:02
7170911,01,090 8.10.2026 12:37
7623611,01,091 8.10.2026 18:57
1778411,01,083 30.09.2026 15:42
1292411,01,086 30.09.2026 10:51
8257911,01,093 9.10.2026 19:25
4991211,01,090 5.10.2026 12:32
1977411,01,086 30.09.2026 20:42
3741011,01,082 4.10.2026 08:55
4102211,01,083 4.10.2026 22:07
5464411,01,095 5.10.2026 17:49
4359311,01,090 5.10.2026 09:00
1121411,01,085 30.09.2026 06:58
5630811,01,082 5.10.2026 18:28
6221311,01,086 5.10.2026 22:56
4440411,01,089 5.10.2026 09:09
8157111,01,089 9.10.2026 17:45
1908611,01,087 30.09.2026 19:36
5891211,01,086 5.10.2026 21:38
2428321,11,186 30.09.2026 22:38
2492711,11,185 30.09.2026 22:38
2116211,11,183 30.09.2026 21:32
5379211,11,185 5.10.2026 13:58
9064101,11,186 30.09.2026 05:42
6145011,11,192 5.10.2026 22:56
7964411,11,189 9.10.2026 14:27
1592421,11,186 30.09.2026 11:20
1647011,11,183 30.09.2026 11:22
1839611,11,186 30.09.2026 15:51
6393161,11,186 6.10.2026 05:50
3923111,11,186 4.10.2026 13:31
1463411,11,186 30.09.2026 11:02
2685611,11,187 30.09.2026 22:56
2312811,11,190 30.09.2026 22:15
6099161,11,186 29.09.2026 18:42
5974911,11,187 5.10.2026 21:41
3031011,11,187 1.10.2026 20:58
8052111,11,182 9.10.2026 14:29
4731611,11,182 5.10.2026 10:00
1527021,11,186 30.09.2026 11:15
3407721,11,184 2.10.2026 16:25
1345011,11,186 30.09.2026 10:52
1711211,21,193 30.09.2026 15:32
4561811,21,288 5.10.2026 09:48
2616811,21,297 30.09.2026 22:53
2892411,21,287 1.10.2026 19:31
5547311,21,287 5.10.2026 17:58
7867811,21,286 9.10.2026 13:15
3111011,21,286 1.10.2026 21:13
5296311,21,291 5.10.2026 13:19
7357611,21,282 8.10.2026 16:34
3850011,21,282 4.10.2026 13:28
6641111,21,288 7.10.2026 20:12
7537311,21,282 8.10.2026 17:17
2371121,21,283 30.09.2026 22:19
764111,31,387 29.09.2026 20:13
5216111,31,386 5.10.2026 12:59
4267011,31,389 5.10.2026 02:58
5715911,31,386 5.10.2026 20:19
2548511,31,389 30.09.2026 22:40
2825611,31,392 1.10.2026 19:19
2180711,31,382 30.09.2026 21:34
1395511,41,491 30.09.2026 10:56
2048511,41,490 30.09.2026 21:24
3234911,51,587 2.10.2026 00:06
2243611,51,588 30.09.2026 21:37
3176111,61,687 2.10.2026 00:05
6057711,71,782 5.10.2026 22:03
5060212,22,285 5.10.2026 12:33
5141415,65,698 5.10.2026 12:58 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 
SELECT EventType, EarliestUtc, LatestUtc, OrderUncertain INTO #actual FROM rag.PlanChangeEvent WHERE EventType = 'IndexCreated'

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.