Pahalı sorgular0xAA5001836FDF33CB
Demo modu

Sorgu 0xAA5001836FDF33CB

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 19,2 ms
Ort. CPU 19,1 ms
Bekleme payı %0,5
Ort. mantıksal okuma 539
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. 6,9 ms29.09.2026: 107 çalışma, ort. 2,6 ms30.09.2026: 349 çalışma, ort. 2,4 ms1.10.2026: 49 çalışma, ort. 3,3 ms2.10.2026: 83 çalışma, ort. 1,9 ms3.10.2026: 1 çalışma, ort. 298,2 ms4.10.2026: 57 çalışma, ort. 139,5 ms5.10.2026: 211 çalışma, ort. 12,2 ms6.10.2026: 50 çalışma, ort. 53,5 ms7.10.2026: 49 çalışma, ort. 37,0 ms9.10.2026: 33 çalışma, ort. 86,4 ms max 349 çalışma max ort. süre 298,2 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 82534
  2. 9.10.2026 17:00 yeni plan plan 81539
  3. 9.10.2026 14:00 yeni plan plan 80960
  4. 9.10.2026 14:00 yeni plan plan 80496
  5. 9.10.2026 14:00 yeni plan plan 79594
  6. 9.10.2026 13:00 yeni plan plan 78651
  7. 8.10.2026 20:00 yeni plan plan 77604
  8. 8.10.2026 19:00 yeni plan plan 77165
  9. 8.10.2026 18:00 yeni plan plan 76259
  10. 8.10.2026 17:00 yeni plan plan 75322
  11. 8.10.2026 16:00 yeni plan plan 74423
  12. 8.10.2026 16:00 yeni plan plan 73548
  13. 8.10.2026 14:00 yeni plan plan 72568
  14. 8.10.2026 12:00 yeni plan plan 71656
  15. 8.10.2026 12:00 yeni plan plan 70775
  16. 8.10.2026 08:00 yeni plan plan 70232
  17. 7.10.2026 20:00 yeni plan plan 69767
  18. 7.10.2026 20:00 yeni plan plan 68896
  19. 7.10.2026 20:00 yeni plan plan 67300
  20. 7.10.2026 20:00 yeni plan plan 66813
  21. 7.10.2026 20:00 yeni plan plan 66362
  22. 7.10.2026 13:00 yeni plan plan 65318
  23. 6.10.2026 03:00 yeni plan plan 64555
  24. 6.10.2026 00:00 yeni plan plan 63951
  25. 5.10.2026 23:00 yeni plan plan 63044
  26. 5.10.2026 22:00 yeni plan plan 61431
  27. 5.10.2026 22:00 yeni plan plan 60546
  28. 5.10.2026 21:00 yeni plan plan 58026
  29. 5.10.2026 21:00 yeni plan plan 58888
  30. 5.10.2026 21:00 yeni plan plan 59709
  31. 5.10.2026 20:00 yeni plan plan 57130
  32. 5.10.2026 18:00 yeni plan plan 56284
  33. 5.10.2026 17:00 yeni plan plan 55436
  34. 5.10.2026 17:00 yeni plan plan 54615
  35. 5.10.2026 13:00 yeni plan plan 53743
  36. 5.10.2026 13:00 yeni plan plan 52924
  37. 5.10.2026 12:00 yeni plan plan 51397
  38. 5.10.2026 12:00 yeni plan plan 49863
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48969
  41. 5.10.2026 10:00 yeni plan plan 48087
  42. 5.10.2026 10:00 yeni plan plan 47284
  43. 5.10.2026 09:00 yeni plan plan 45590
  44. 5.10.2026 09:00 yeni plan plan 44787
  45. 5.10.2026 09:00 yeni plan plan 44355
  46. 5.10.2026 09:00 yeni plan plan 43570
  47. 5.10.2026 08:00 yeni plan plan 43229
  48. 5.10.2026 03:00 yeni plan plan 43040
  49. 5.10.2026 02:00 yeni plan plan 42620
  50. 5.10.2026 00:00 yeni plan plan 41813
  51. 4.10.2026 22:00 yeni plan plan 41399
  52. 4.10.2026 22:00 yeni plan plan 40971
  53. 4.10.2026 21:00 yeni plan plan 40563
  54. 4.10.2026 14:00 yeni plan plan 40403
  55. 4.10.2026 13:00 yeni plan plan 39997
  56. 4.10.2026 13:00 yeni plan plan 39251
  57. 4.10.2026 13:00 yeni plan plan 38861
  58. 4.10.2026 13:00 yeni plan plan 38480
  59. 4.10.2026 10:00 yeni plan plan 37989
  60. 4.10.2026 09:00 yeni plan plan 37815
  61. 4.10.2026 08:00 yeni plan plan 37433
  62. 3.10.2026 03:00 yeni plan plan 36986
  63. 2.10.2026 17:00 yeni plan plan 36514
  64. 2.10.2026 17:00 yeni plan plan 35799
  65. 2.10.2026 17:00 yeni plan plan 35053
  66. 2.10.2026 16:00 yeni plan plan 34109
  67. 2.10.2026 02:00 yeni plan plan 33664
  68. 2.10.2026 01:00 yeni plan plan 32966
  69. 2.10.2026 00:00 yeni plan plan 31744
  70. 1.10.2026 21:00 yeni plan plan 31086
  71. 1.10.2026 21:00 yeni plan plan 30692
  72. 1.10.2026 20:00 yeni plan plan 30260
  73. 1.10.2026 20:00 yeni plan plan 29610
  74. 1.10.2026 19:00 yeni plan plan 28885
  75. 1.10.2026 19:00 yeni plan plan 28206
  76. 1.10.2026 19:00 yeni plan plan 27535
  77. 30.09.2026 22:00 yeni plan plan 26834
  78. 30.09.2026 22:00 yeni plan plan 26188
  79. 30.09.2026 22:00 yeni plan plan 25508
  80. 30.09.2026 22:00 yeni plan plan 24558
  81. 30.09.2026 22:00 yeni plan plan 24264
  82. 30.09.2026 22:00 yeni plan plan 24064
  83. 30.09.2026 22:00 yeni plan plan 23734
  84. 30.09.2026 22:00 yeni plan plan 23088
  85. 30.09.2026 21:00 yeni plan plan 20450
  86. 30.09.2026 21:00 yeni plan plan 20752
  87. 30.09.2026 21:00 yeni plan plan 21117
  88. 30.09.2026 21:00 yeni plan plan 21767
  89. 30.09.2026 21:00 yeni plan plan 22410
  90. 30.09.2026 20:00 yeni plan plan 19753
  91. 30.09.2026 20:00 yeni plan plan 19347
  92. 30.09.2026 19:00 yeni plan plan 19034
  93. 30.09.2026 15:00 yeni plan plan 18365
  94. 30.09.2026 15:00 yeni plan plan 17733
  95. 30.09.2026 15:00 yeni plan plan 17081
  96. 30.09.2026 11:00 yeni plan plan 15555
  97. 30.09.2026 11:00 yeni plan plan 15222
  98. 30.09.2026 11:00 yeni plan plan 14584
  99. 30.09.2026 10:00 yeni plan plan 13978
  100. 30.09.2026 10:00 yeni plan plan 12882
  101. 30.09.2026 06:00 yeni plan plan 11968
  102. 30.09.2026 06:00 yeni plan plan 11193
  103. 30.09.2026 06:00 yeni plan plan 10630
  104. 30.09.2026 05:00 yeni plan plan 10067
  105. 30.09.2026 03:00 yeni plan plan 9487
  106. 30.09.2026 00:00 yeni plan plan 9031
  107. 29.09.2026 21:00 yeni plan plan 8575
  108. 29.09.2026 21:00 yeni plan plan 8147
  109. 29.09.2026 20:00 yeni plan plan 7667
  110. 28.09.2026 19:00 yeni plan plan 6562
  111. 28.09.2026 19:00 yeni plan plan 6476
  112. 28.09.2026 16:00 yeni plan plan 6069
  113. 28.09.2026 16:00 yeni plan plan 6028
  114. 28.09.2026 16:00 yeni plan plan 5996

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28536,96,9 62,4327
2026-09-291072,62,6 27,9130
2026-09-303492,42,4 33,4122
2026-10-01492,83,3 52,1127
2026-10-02831,91,9 2,1107
2026-10-031298,2298,2 298,28.472
2026-10-0457139,4139,5 578,93.850
2026-10-0521112,212,2 619,3318
2026-10-065053,553,5 1.307,11.604
2026-10-074936,937,0 1.295,3942
2026-10-093383,986,4 2.229,41.552

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
814781,61,6103 29.09.2026 21:26 en iyi
3579981,61,6108 2.10.2026 17:32
1006781,61,6104 30.09.2026 05:49
6889681,71,7104 7.10.2026 20:51
7077581,71,7108 8.10.2026 12:20
2683481,71,7109 30.09.2026 22:56
7532281,71,7107 8.10.2026 17:17
11193161,71,7105 30.09.2026 06:59
766781,71,7106 29.09.2026 20:13
857581,71,7106 29.09.2026 21:50
6976781,71,7108 7.10.2026 20:53
3026081,71,7107 1.10.2026 20:58
6636281,71,7104 7.10.2026 20:12
2961081,81,8106 1.10.2026 20:57
8253481,81,8106 9.10.2026 19:25
4808781,81,8106 5.10.2026 10:03
11968161,81,8107 30.09.2026 07:00
3366481,81,8104 2.10.2026 02:27
6069241,81,8107 28.09.2026 17:03
34109111,81,8107 2.10.2026 16:25
67300161,81,8104 7.10.2026 20:50
3999781,81,8106 4.10.2026 13:45
2888581,81,8110 1.10.2026 19:31
7165681,81,8109 8.10.2026 12:37
2753581,81,8108 1.10.2026 19:13
1063081,81,8105 30.09.2026 06:32
7959481,81,8106 9.10.2026 14:27
5543681,81,8106 5.10.2026 17:58
6304481,81,8110 5.10.2026 23:04
4097181,81,8106 4.10.2026 22:07
5713081,91,9104 5.10.2026 20:19
5628481,91,9106 5.10.2026 18:28
6531881,91,9104 7.10.2026 13:55
5374381,91,9108 5.10.2026 13:58
3296681,91,9111 2.10.2026 01:09
4181381,91,9109 5.10.2026 00:27
4896981,91,9105 5.10.2026 10:42
2618881,91,9105 30.09.2026 22:53
12882161,91,9106 30.09.2026 10:52
36514241,91,9107 2.10.2026 18:17
3108681,91,9104 1.10.2026 21:13
1836581,91,9106 30.09.2026 15:51
4262081,91,9104 5.10.2026 02:58
2550881,91,9105 30.09.2026 22:40
7442381,91,9106 8.10.2026 16:38
2820681,91,9109 1.10.2026 19:19
8153982,02,0102 9.10.2026 17:45
9031802,02,0107 30.09.2026 05:42
2308882,02,0107 30.09.2026 22:15
1708182,02,0103 30.09.2026 15:32
1397882,02,0104 30.09.2026 10:56
7865182,02,0110 9.10.2026 13:15
3848082,02,0107 4.10.2026 13:29
63951482,02,0108 6.10.2026 05:50
5802682,02,0106 5.10.2026 21:02
1773382,02,0108 30.09.2026 15:42
4435582,02,0106 5.10.2026 09:09
2426482,02,0110 30.09.2026 22:35
23734162,02,0106 30.09.2026 22:19
2176782,02,0106 30.09.2026 21:34
4728482,02,0107 5.10.2026 10:00
1522282,02,0105 30.09.2026 11:08
5292482,02,0103 5.10.2026 13:19
5970982,02,0106 5.10.2026 21:41
1903482,02,0107 30.09.2026 19:36
5461582,02,0107 5.10.2026 17:49
5888882,12,1105 5.10.2026 21:38
6054682,12,1106 5.10.2026 22:04
24558162,12,1106 30.09.2026 22:38
45590162,12,1104 5.10.2026 09:49
31744162,12,1107 2.10.2026 00:06
1975382,12,1106 30.09.2026 20:42
61431162,12,1111 5.10.2026 22:56
49863162,12,1106 5.10.2026 12:33
7625982,12,1109 8.10.2026 18:57
4357082,12,1106 5.10.2026 09:01
8049682,22,2106 9.10.2026 14:29
3505382,22,2108 2.10.2026 17:24
3925182,22,2107 4.10.2026 13:31
15555322,22,2107 30.09.2026 11:22
65621062,22,2113 29.09.2026 18:42
2241082,32,1106 30.09.2026 21:37
7716582,31,9106 8.10.2026 19:59
1458482,32,3107 30.09.2026 11:02
7256882,32,3108 8.10.2026 14:01
2111782,52,5106 30.09.2026 21:32
7354882,52,5107 8.10.2026 16:34
51397162,62,6106 5.10.2026 12:59
3743382,62,6103 4.10.2026 08:55
2045082,92,9106 30.09.2026 21:24
24064118,718,7691 30.09.2026 22:30
19347232,432,41.230 30.09.2026 20:30
20752135,335,31.260 30.09.2026 21:30
9487141,641,61.581 30.09.2026 03:30
6476450,950,92.196 29.09.2026 02:24
6028162,462,42.672 28.09.2026 16:25
5996162,562,52.658 28.09.2026 16:24
30692173,651,11.101 1.10.2026 21:13
369863366,1366,110.028 4.10.2026 08:30
379893395,2394,811.315 4.10.2026 12:30
388611403,7403,711.720 4.10.2026 13:30
378151421,0421,011.348 4.10.2026 09:30
404037471,0471,013.504 4.10.2026 20:30
430401495,6495,514.729 5.10.2026 03:30
405631578,9578,914.006 4.10.2026 21:30
413992589,6589,614.020 4.10.2026 23:30
447871650,2650,215.425 5.10.2026 09:30
4322911.002,11.002,114.920 5.10.2026 08:59
6455521.290,41.290,137.506 6.10.2026 22:15
6681311.726,41.725,241.145 7.10.2026 20:40
7760412.115,12.106,146.793 8.10.2026 20:03
7023212.601,52.581,143.872 8.10.2026 08:30
8096012.786,22.706,847.801 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
CPU:120,Memory:91,Buffer IO:22
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 
WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
        SELECT DISTINCT px.CaseID, px.PlanRole, px.ServerID, px.DatabaseName,
               PARSENAME(n.value('@Schema', 'nvarchar(260)'), 1) AS SchemaName,
               PARSENAME(n.value('@Table', 'nvarchar(260)'), 1) AS TableName,
               PARSENAME(n.value('@Index', 'nvarchar(260)'), 1) AS IndexName
        INTO #pobj
        FROM #px AS px
        CROSS APPLY px.PlanXml.nodes('//RelOp//Object') AS o (n)
        WHERE n.value('@Table', 'nvarchar(260)') IS NOT NULL AND n.value('@Table', 'nvarchar(260)') NOT LIKE N'[[]#%'

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.