Pahalı sorgular0x624BA3EAE2022981
Demo modu

Sorgu 0x624BA3EAE2022981

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

Ort. süre 1,3 ms
Ort. CPU 1,3 ms
Bekleme payı %0,4
Ort. mantıksal okuma 95
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: 53 çalışma, ort. 1,2 ms29.09.2026: 107 çalışma, ort. 1,3 ms30.09.2026: 349 çalışma, ort. 1,3 ms1.10.2026: 49 çalışma, ort. 1,3 ms2.10.2026: 83 çalışma, ort. 1,2 ms3.10.2026: 1 çalışma, ort. 2,7 ms4.10.2026: 57 çalışma, ort. 1,9 ms5.10.2026: 211 çalışma, ort. 1,3 ms6.10.2026: 50 çalışma, ort. 1,2 ms7.10.2026: 49 çalışma, ort. 1,1 ms9.10.2026: 33 çalışma, ort. 1,5 ms max 349 çalışma max ort. süre 2,7 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 82538
  2. 9.10.2026 17:00 yeni plan plan 81543
  3. 9.10.2026 14:00 yeni plan plan 80964
  4. 9.10.2026 14:00 yeni plan plan 80500
  5. 9.10.2026 14:00 yeni plan plan 79598
  6. 9.10.2026 13:00 yeni plan plan 78655
  7. 8.10.2026 20:00 yeni plan plan 77606
  8. 8.10.2026 19:00 yeni plan plan 77169
  9. 8.10.2026 18:00 yeni plan plan 76263
  10. 8.10.2026 17:00 yeni plan plan 75326
  11. 8.10.2026 16:00 yeni plan plan 74427
  12. 8.10.2026 16:00 yeni plan plan 73552
  13. 8.10.2026 14:00 yeni plan plan 72572
  14. 8.10.2026 12:00 yeni plan plan 71660
  15. 8.10.2026 12:00 yeni plan plan 70779
  16. 8.10.2026 08:00 yeni plan plan 70234
  17. 7.10.2026 20:00 yeni plan plan 69771
  18. 7.10.2026 20:00 yeni plan plan 68900
  19. 7.10.2026 20:00 yeni plan plan 67304
  20. 7.10.2026 20:00 yeni plan plan 66815
  21. 7.10.2026 20:00 yeni plan plan 66366
  22. 7.10.2026 13:00 yeni plan plan 65322
  23. 6.10.2026 03:00 yeni plan plan 64557
  24. 6.10.2026 00:00 yeni plan plan 63955
  25. 5.10.2026 23:00 yeni plan plan 63048
  26. 5.10.2026 22:00 yeni plan plan 61435
  27. 5.10.2026 22:00 yeni plan plan 60550
  28. 5.10.2026 21:00 yeni plan plan 58030
  29. 5.10.2026 21:00 yeni plan plan 58892
  30. 5.10.2026 21:00 yeni plan plan 59713
  31. 5.10.2026 20:00 yeni plan plan 57134
  32. 5.10.2026 18:00 yeni plan plan 56288
  33. 5.10.2026 17:00 yeni plan plan 55440
  34. 5.10.2026 17:00 yeni plan plan 54619
  35. 5.10.2026 13:00 yeni plan plan 53747
  36. 5.10.2026 13:00 yeni plan plan 52928
  37. 5.10.2026 12:00 yeni plan plan 51401
  38. 5.10.2026 12:00 yeni plan plan 49867
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48973
  41. 5.10.2026 10:00 yeni plan plan 48091
  42. 5.10.2026 10:00 yeni plan plan 47288
  43. 5.10.2026 09:00 yeni plan plan 45594
  44. 5.10.2026 09:00 yeni plan plan 44789
  45. 5.10.2026 09:00 yeni plan plan 44359
  46. 5.10.2026 09:00 yeni plan plan 43573
  47. 5.10.2026 08:00 yeni plan plan 43233
  48. 5.10.2026 03:00 yeni plan plan 43042
  49. 5.10.2026 02:00 yeni plan plan 42624
  50. 5.10.2026 00:00 yeni plan plan 41817
  51. 4.10.2026 22:00 yeni plan plan 41401
  52. 4.10.2026 22:00 yeni plan plan 40975
  53. 4.10.2026 21:00 yeni plan plan 40567
  54. 4.10.2026 14:00 yeni plan plan 40405
  55. 4.10.2026 13:00 yeni plan plan 40001
  56. 4.10.2026 13:00 yeni plan plan 39255
  57. 4.10.2026 13:00 yeni plan plan 38863
  58. 4.10.2026 13:00 yeni plan plan 38484
  59. 4.10.2026 10:00 yeni plan plan 37993
  60. 4.10.2026 09:00 yeni plan plan 37817
  61. 4.10.2026 08:00 yeni plan plan 37437
  62. 3.10.2026 03:00 yeni plan plan 36988
  63. 2.10.2026 17:00 yeni plan plan 36518
  64. 2.10.2026 17:00 yeni plan plan 35803
  65. 2.10.2026 17:00 yeni plan plan 35057
  66. 2.10.2026 16:00 yeni plan plan 34113
  67. 2.10.2026 02:00 yeni plan plan 33668
  68. 2.10.2026 01:00 yeni plan plan 32970
  69. 2.10.2026 00:00 yeni plan plan 31748
  70. 1.10.2026 21:00 yeni plan plan 31089
  71. 1.10.2026 21:00 yeni plan plan 30697
  72. 1.10.2026 20:00 yeni plan plan 30264
  73. 1.10.2026 20:00 yeni plan plan 29614
  74. 1.10.2026 19:00 yeni plan plan 28889
  75. 1.10.2026 19:00 yeni plan plan 28210
  76. 1.10.2026 19:00 yeni plan plan 27539
  77. 30.09.2026 22:00 yeni plan plan 26838
  78. 30.09.2026 22:00 yeni plan plan 26192
  79. 30.09.2026 22:00 yeni plan plan 25512
  80. 30.09.2026 22:00 yeni plan plan 24562
  81. 30.09.2026 22:00 yeni plan plan 24268
  82. 30.09.2026 22:00 yeni plan plan 24067
  83. 30.09.2026 22:00 yeni plan plan 23738
  84. 30.09.2026 22:00 yeni plan plan 23092
  85. 30.09.2026 21:00 yeni plan plan 20454
  86. 30.09.2026 21:00 yeni plan plan 20754
  87. 30.09.2026 21:00 yeni plan plan 21121
  88. 30.09.2026 21:00 yeni plan plan 21771
  89. 30.09.2026 21:00 yeni plan plan 22414
  90. 30.09.2026 20:00 yeni plan plan 19757
  91. 30.09.2026 20:00 yeni plan plan 19349
  92. 30.09.2026 19:00 yeni plan plan 19038
  93. 30.09.2026 15:00 yeni plan plan 18369
  94. 30.09.2026 15:00 yeni plan plan 17737
  95. 30.09.2026 15:00 yeni plan plan 17085
  96. 30.09.2026 11:00 yeni plan plan 15559
  97. 30.09.2026 11:00 yeni plan plan 15226
  98. 30.09.2026 11:00 yeni plan plan 14588
  99. 30.09.2026 10:00 yeni plan plan 13982
  100. 30.09.2026 10:00 yeni plan plan 12886
  101. 30.09.2026 06:00 yeni plan plan 11972
  102. 30.09.2026 06:00 yeni plan plan 11197
  103. 30.09.2026 06:00 yeni plan plan 10634
  104. 30.09.2026 05:00 yeni plan plan 10071
  105. 30.09.2026 03:00 yeni plan plan 9489
  106. 30.09.2026 00:00 yeni plan plan 9035
  107. 29.09.2026 21:00 yeni plan plan 8579
  108. 29.09.2026 21:00 yeni plan plan 8151
  109. 29.09.2026 20:00 yeni plan plan 7671
  110. 28.09.2026 19:00 yeni plan plan 6565
  111. 28.09.2026 19:00 yeni plan plan 6480
  112. 28.09.2026 16:00 yeni plan plan 6072
  113. 28.09.2026 16:00 yeni plan plan 6032
  114. 28.09.2026 16:00 yeni plan plan 6000

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28531,21,2 1,786
2026-09-291071,31,3 1,985
2026-09-303491,31,3 1,986
2026-10-01491,31,3 4,289
2026-10-02831,21,2 1,585
2026-10-0312,72,7 2,7427
2026-10-04571,91,9 4,9206
2026-10-052111,31,3 4,092
2026-10-06501,21,2 5,193
2026-10-07491,11,1 3,790
2026-10-09331,41,5 7,694

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
6890081,01,084 7.10.2026 20:51 en iyi
67304161,01,083 7.10.2026 20:50
857981,01,086 29.09.2026 21:50
7166081,11,184 8.10.2026 12:37
3580381,11,185 2.10.2026 17:32
8253881,11,185 9.10.2026 19:25
815181,11,183 29.09.2026 21:26
6977181,11,186 7.10.2026 20:53
6636681,11,187 7.10.2026 20:12
6304881,11,186 5.10.2026 23:04
7716981,11,185 8.10.2026 19:59
63955481,11,185 6.10.2026 05:50
2961481,11,183 1.10.2026 20:57
3297081,11,187 2.10.2026 01:09
34113111,11,186 2.10.2026 16:25
11197161,11,186 30.09.2026 06:59
2683881,11,187 30.09.2026 22:56
767181,11,183 29.09.2026 20:13
11972161,11,186 30.09.2026 07:00
36518241,11,186 2.10.2026 18:17
61435161,11,187 5.10.2026 22:56
7077981,11,184 8.10.2026 12:20
3108981,11,184 1.10.2026 21:13
8154381,11,183 9.10.2026 17:45
6532281,11,183 7.10.2026 13:55
2309281,11,185 30.09.2026 22:15
4000181,11,185 4.10.2026 13:45
1398281,11,185 30.09.2026 10:56
5628881,21,282 5.10.2026 18:28
1007181,21,084 30.09.2026 05:49
4809181,21,286 5.10.2026 10:03
5803081,21,285 5.10.2026 21:02
7959881,21,286 9.10.2026 14:27
3366881,21,283 2.10.2026 02:27
4897381,21,284 5.10.2026 10:42
6072241,21,285 28.09.2026 17:03
1063481,21,287 30.09.2026 06:32
7257281,21,285 8.10.2026 14:01
3848481,21,283 4.10.2026 13:29
4181781,21,283 5.10.2026 00:27
4728881,21,286 5.10.2026 10:00
6055081,21,283 5.10.2026 22:04
5971381,21,285 5.10.2026 21:41
5713481,21,284 5.10.2026 20:19
23738161,21,285 30.09.2026 22:19
12886161,21,286 30.09.2026 10:52
2821081,21,283 1.10.2026 19:19
3026481,21,284 1.10.2026 20:58
2888981,21,287 1.10.2026 19:31
4097581,21,285 4.10.2026 22:07
1773781,21,287 30.09.2026 15:42
2753981,21,285 1.10.2026 19:13
4435981,21,285 5.10.2026 09:09
7442781,21,285 8.10.2026 16:38
8050081,21,283 9.10.2026 14:29
5374781,21,283 5.10.2026 13:58
1708581,21,285 30.09.2026 15:32
1836981,21,286 30.09.2026 15:51
24562161,31,386 30.09.2026 22:38
4357381,31,384 5.10.2026 09:01
2426881,31,386 30.09.2026 22:35
4262481,31,384 5.10.2026 02:58
5889281,31,384 5.10.2026 21:38
1458881,31,385 30.09.2026 11:02
2177181,31,386 30.09.2026 21:34
2241481,31,384 30.09.2026 21:37
1522681,31,386 30.09.2026 11:08
1903881,31,387 30.09.2026 19:36
2619281,31,384 30.09.2026 22:53
9035801,31,385 30.09.2026 05:42
5544081,31,384 5.10.2026 17:58
7355281,31,384 8.10.2026 16:34
65651041,31,385 29.09.2026 18:42
45594161,31,385 5.10.2026 09:49
5292881,31,384 5.10.2026 13:19
3925581,31,385 4.10.2026 13:31
1975781,41,485 30.09.2026 20:42
2551281,41,485 30.09.2026 22:40
51401161,41,487 5.10.2026 12:59
5461981,41,484 5.10.2026 17:49
49867161,41,488 5.10.2026 12:33
1934921,41,496 30.09.2026 20:30
3743781,41,486 4.10.2026 08:55
3505781,41,484 2.10.2026 17:24
648061,41,492 29.09.2026 13:36
7865581,41,385 9.10.2026 13:15
15559321,51,587 30.09.2026 11:22
7532681,51,584 8.10.2026 17:17
31748161,51,585 2.10.2026 00:06
7626381,61,685 8.10.2026 18:57
600011,61,6115 28.09.2026 16:24
603211,61,6116 28.09.2026 16:25
2112181,61,686 30.09.2026 21:32
2075411,71,7117 30.09.2026 21:30
2406711,81,8116 30.09.2026 22:30
948912,02,0128 30.09.2026 03:30
3698832,62,6428 4.10.2026 08:30
3799332,92,9471 4.10.2026 12:30
3886313,23,2496 4.10.2026 13:30
4040573,23,2494 4.10.2026 20:30
2045483,53,586 30.09.2026 21:24
3781713,53,5480 4.10.2026 09:30
4304213,73,7580 5.10.2026 03:30
4056713,83,8537 4.10.2026 21:30
4478914,14,1602 5.10.2026 09:30
6681514,64,3368 7.10.2026 20:40
6455724,84,8302 6.10.2026 22:15
7760614,94,6404 8.10.2026 20:03
3069715,44,9292 1.10.2026 21:13
7023416,36,3381 8.10.2026 08:30
4140126,96,9550 4.10.2026 23:30
8096419,29,2413 9.10.2026 14:52
4323319,49,4591 5.10.2026 08:59 en kötü

Davranış

Wait kategorileri (QDS)
CPU:1
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 DISTINCT w.ServerID, w.DatabaseName,
               (SELECT MIN(mo.FirstSeenUtc) FROM perf.MetaObject AS mo WHERE mo.ServerID = w.ServerID AND mo.DatabaseName = w.DatabaseName) AS FirstCollectUtc
        INTO #firstc FROM #win AS w

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.