Pahalı sorgular0x60D9BE32914EAB1F
Demo modu

Sorgu 0x60D9BE32914EAB1F

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

Ort. süre 0,8 ms
Ort. CPU 0,8 ms
Bekleme payı %0,3
Ort. mantıksal okuma 40
En büyük bellek izni 0 MB

Ö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. 0,5 ms29.09.2026: 107 çalışma, ort. 0,4 ms30.09.2026: 349 çalışma, ort. 0,4 ms1.10.2026: 49 çalışma, ort. 0,4 ms2.10.2026: 84 çalışma, ort. 0,4 ms3.10.2026: 1 çalışma, ort. 12,3 ms4.10.2026: 57 çalışma, ort. 3,2 ms5.10.2026: 211 çalışma, ort. 0,6 ms6.10.2026: 50 çalışma, ort. 1,9 ms7.10.2026: 49 çalışma, ort. 1,1 ms9.10.2026: 33 çalışma, ort. 3,0 ms max 349 çalışma max ort. süre 12,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 82545
  2. 9.10.2026 17:00 yeni plan plan 81550
  3. 9.10.2026 14:00 yeni plan plan 80971
  4. 9.10.2026 14:00 yeni plan plan 80507
  5. 9.10.2026 14:00 yeni plan plan 79605
  6. 9.10.2026 13:00 yeni plan plan 78662
  7. 8.10.2026 20:00 yeni plan plan 77620
  8. 8.10.2026 19:00 yeni plan plan 77176
  9. 8.10.2026 18:00 yeni plan plan 76270
  10. 8.10.2026 17:00 yeni plan plan 75333
  11. 8.10.2026 16:00 yeni plan plan 74434
  12. 8.10.2026 16:00 yeni plan plan 73559
  13. 8.10.2026 14:00 yeni plan plan 72579
  14. 8.10.2026 12:00 yeni plan plan 71667
  15. 8.10.2026 12:00 yeni plan plan 70786
  16. 8.10.2026 08:00 yeni plan plan 70241
  17. 7.10.2026 20:00 yeni plan plan 69778
  18. 7.10.2026 20:00 yeni plan plan 68907
  19. 7.10.2026 20:00 yeni plan plan 67311
  20. 7.10.2026 20:00 yeni plan plan 66822
  21. 7.10.2026 20:00 yeni plan plan 66373
  22. 7.10.2026 13:00 yeni plan plan 65329
  23. 6.10.2026 03:00 yeni plan plan 64564
  24. 6.10.2026 00:00 yeni plan plan 63962
  25. 5.10.2026 23:00 yeni plan plan 63055
  26. 5.10.2026 22:00 yeni plan plan 61442
  27. 5.10.2026 22:00 yeni plan plan 60557
  28. 5.10.2026 21:00 yeni plan plan 58037
  29. 5.10.2026 21:00 yeni plan plan 58899
  30. 5.10.2026 21:00 yeni plan plan 59720
  31. 5.10.2026 20:00 yeni plan plan 57141
  32. 5.10.2026 18:00 yeni plan plan 56295
  33. 5.10.2026 17:00 yeni plan plan 55447
  34. 5.10.2026 17:00 yeni plan plan 54626
  35. 5.10.2026 13:00 yeni plan plan 53754
  36. 5.10.2026 13:00 yeni plan plan 52935
  37. 5.10.2026 12:00 yeni plan plan 51408
  38. 5.10.2026 12:00 yeni plan plan 49874
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48980
  41. 5.10.2026 10:00 yeni plan plan 48098
  42. 5.10.2026 10:00 yeni plan plan 47295
  43. 5.10.2026 09:00 yeni plan plan 45601
  44. 5.10.2026 09:00 yeni plan plan 44796
  45. 5.10.2026 09:00 yeni plan plan 44366
  46. 5.10.2026 09:00 yeni plan plan 43580
  47. 5.10.2026 08:00 yeni plan plan 43241
  48. 5.10.2026 03:00 yeni plan plan 43049
  49. 5.10.2026 02:00 yeni plan plan 42631
  50. 5.10.2026 00:00 yeni plan plan 41824
  51. 4.10.2026 22:00 yeni plan plan 41408
  52. 4.10.2026 22:00 yeni plan plan 40982
  53. 4.10.2026 21:00 yeni plan plan 40574
  54. 4.10.2026 14:00 yeni plan plan 40412
  55. 4.10.2026 13:00 yeni plan plan 40008
  56. 4.10.2026 13:00 yeni plan plan 39262
  57. 4.10.2026 13:00 yeni plan plan 38870
  58. 4.10.2026 13:00 yeni plan plan 38491
  59. 4.10.2026 10:00 yeni plan plan 38000
  60. 4.10.2026 09:00 yeni plan plan 37824
  61. 4.10.2026 08:00 yeni plan plan 37444
  62. 3.10.2026 03:00 yeni plan plan 36995
  63. 2.10.2026 17:00 yeni plan plan 36525
  64. 2.10.2026 17:00 yeni plan plan 35810
  65. 2.10.2026 17:00 yeni plan plan 35064
  66. 2.10.2026 16:00 yeni plan plan 34074
  67. 2.10.2026 02:00 yeni plan plan 33675
  68. 2.10.2026 01:00 yeni plan plan 32977
  69. 2.10.2026 00:00 yeni plan plan 31755
  70. 1.10.2026 21:00 yeni plan plan 31096
  71. 1.10.2026 21:00 yeni plan plan 30707
  72. 1.10.2026 20:00 yeni plan plan 30271
  73. 1.10.2026 20:00 yeni plan plan 29621
  74. 1.10.2026 19:00 yeni plan plan 28896
  75. 1.10.2026 19:00 yeni plan plan 28217
  76. 1.10.2026 19:00 yeni plan plan 27546
  77. 30.09.2026 22:00 yeni plan plan 26845
  78. 30.09.2026 22:00 yeni plan plan 26199
  79. 30.09.2026 22:00 yeni plan plan 25519
  80. 30.09.2026 22:00 yeni plan plan 24569
  81. 30.09.2026 22:00 yeni plan plan 24275
  82. 30.09.2026 22:00 yeni plan plan 24075
  83. 30.09.2026 22:00 yeni plan plan 23745
  84. 30.09.2026 22:00 yeni plan plan 23099
  85. 30.09.2026 21:00 yeni plan plan 20461
  86. 30.09.2026 21:00 yeni plan plan 20763
  87. 30.09.2026 21:00 yeni plan plan 21128
  88. 30.09.2026 21:00 yeni plan plan 21778
  89. 30.09.2026 21:00 yeni plan plan 22421
  90. 30.09.2026 20:00 yeni plan plan 19764
  91. 30.09.2026 20:00 yeni plan plan 19365
  92. 30.09.2026 19:00 yeni plan plan 19045
  93. 30.09.2026 15:00 yeni plan plan 18376
  94. 30.09.2026 15:00 yeni plan plan 17744
  95. 30.09.2026 15:00 yeni plan plan 17092
  96. 30.09.2026 11:00 yeni plan plan 15566
  97. 30.09.2026 11:00 yeni plan plan 15233
  98. 30.09.2026 11:00 yeni plan plan 14595
  99. 30.09.2026 10:00 yeni plan plan 13989
  100. 30.09.2026 10:00 yeni plan plan 12893
  101. 30.09.2026 06:00 yeni plan plan 11979
  102. 30.09.2026 06:00 yeni plan plan 11204
  103. 30.09.2026 06:00 yeni plan plan 10641
  104. 30.09.2026 05:00 yeni plan plan 10078
  105. 30.09.2026 03:00 yeni plan plan 9496
  106. 30.09.2026 00:00 yeni plan plan 9042
  107. 29.09.2026 21:00 yeni plan plan 8586
  108. 29.09.2026 21:00 yeni plan plan 8158
  109. 29.09.2026 20:00 yeni plan plan 7678
  110. 29.09.2026 03:00 yeni plan plan 6774
  111. 28.09.2026 22:00 yeni plan plan 6686
  112. 28.09.2026 19:00 yeni plan plan 6572
  113. 28.09.2026 19:00 yeni plan plan 6487
  114. 28.09.2026 16:00 yeni plan plan 6079
  115. 28.09.2026 16:00 yeni plan plan 6039
  116. 28.09.2026 16:00 yeni plan plan 6006

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28530,50,5 1,13
2026-09-291070,40,4 2,52
2026-09-303490,40,4 1,10
2026-10-01490,40,4 1,67
2026-10-02840,40,4 0,50
2026-10-03112,312,3 12,31.068
2026-10-04573,13,2 10,8388
2026-10-052110,60,6 13,223
2026-10-06501,91,9 39,2124
2026-10-07491,11,1 28,970
2026-10-09333,03,0 71,294

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
5544780,30,30 5.10.2026 17:58 en iyi
3367580,30,30 2.10.2026 02:27
6637380,30,30 7.10.2026 20:12
1398980,30,30 30.09.2026 10:56
4098280,30,30 4.10.2026 22:07
815880,30,30 29.09.2026 21:26
11204160,30,30 30.09.2026 06:59
1007880,30,30 30.09.2026 05:50
2962180,30,30 1.10.2026 20:57
8050780,30,30 9.10.2026 14:29
4809880,30,30 5.10.2026 10:03
1064180,30,30 30.09.2026 06:32
2309980,30,30 30.09.2026 22:15
5629580,30,30 5.10.2026 18:28
767880,30,30 29.09.2026 20:13
2889680,30,30 1.10.2026 19:31
7960580,40,40 9.10.2026 14:27
6305580,40,40 5.10.2026 23:04
24569160,40,40 30.09.2026 22:38
6532980,40,40 7.10.2026 13:55
7866280,40,40 9.10.2026 13:15
1837680,40,40 30.09.2026 15:51
2551980,40,40 30.09.2026 22:40
5714180,40,40 5.10.2026 20:19
4729580,40,40 5.10.2026 10:00
4898080,40,40 5.10.2026 10:42
2177880,40,40 30.09.2026 21:34
858680,40,40 29.09.2026 21:50
4000880,40,40 4.10.2026 13:45
5462680,40,40 5.10.2026 17:49
1523380,40,40 30.09.2026 11:08
1904580,40,40 30.09.2026 19:36
4182480,40,40 5.10.2026 00:27
2684580,40,40 30.09.2026 22:56
67311160,40,40 7.10.2026 20:50
6890780,40,40 7.10.2026 20:51
11979160,40,40 30.09.2026 07:00
7078680,40,40 8.10.2026 12:20
6055780,40,40 5.10.2026 22:04
5803780,40,40 5.10.2026 21:02
8155080,40,40 9.10.2026 17:45
2427580,40,40 30.09.2026 22:35
1774480,40,40 30.09.2026 15:42
5293580,40,40 5.10.2026 13:19
7717680,40,40 8.10.2026 19:59
49874160,40,40 5.10.2026 12:33
4263180,40,40 5.10.2026 02:58
45601160,40,40 5.10.2026 09:49
2112880,40,40 30.09.2026 21:32
61442160,40,40 5.10.2026 22:56
2619980,40,40 30.09.2026 22:53
1976480,40,40 30.09.2026 20:42
3027180,40,40 1.10.2026 20:58
7355980,40,40 8.10.2026 16:34
9042800,40,40 30.09.2026 05:42
1459580,40,40 30.09.2026 11:02
7443480,40,40 8.10.2026 16:38
3744480,40,40 4.10.2026 08:55
3109680,40,40 1.10.2026 21:13
5972080,40,40 5.10.2026 21:41
65721040,40,40 29.09.2026 18:42
7257980,40,40 8.10.2026 14:01
36525240,40,40 2.10.2026 18:17
3849180,40,40 4.10.2026 13:29
5889980,40,40 5.10.2026 21:38
23745160,40,40 30.09.2026 22:19
7166780,40,40 8.10.2026 12:37
3926280,40,40 4.10.2026 13:31
2821780,40,40 1.10.2026 19:19
1709280,40,40 30.09.2026 15:32
8254580,40,40 9.10.2026 19:25
677410,40,42 29.09.2026 03:30
51408160,40,40 5.10.2026 12:59
3297780,40,40 2.10.2026 01:09
34074120,40,40 2.10.2026 16:25
4358080,40,40 5.10.2026 09:01
4436680,40,40 5.10.2026 09:09
7627080,40,40 8.10.2026 18:57
3581080,40,40 2.10.2026 17:32
3506480,40,40 2.10.2026 17:24
6977880,40,40 7.10.2026 20:53
6079240,50,50 28.09.2026 17:03
31755160,50,50 2.10.2026 00:06
63962480,50,50 6.10.2026 05:50
12893160,50,50 30.09.2026 10:52
15566320,50,50 30.09.2026 11:22
2242180,50,40 30.09.2026 21:37
7533380,50,50 8.10.2026 17:17
2754680,50,50 1.10.2026 19:13
2046180,50,50 30.09.2026 21:24
603910,60,636 28.09.2026 16:25
2076310,90,932 30.09.2026 21:30
1936521,11,134 30.09.2026 20:30
600611,11,140 28.09.2026 16:24
949611,11,136 30.09.2026 03:30
2407511,11,128 30.09.2026 22:30
648721,11,134 29.09.2026 02:24
5375481,61,60 5.10.2026 13:58
668631,91,968 29.09.2026 13:36
3070712,02,0345 1.10.2026 21:13
3887018,78,71.268 4.10.2026 13:30
4304918,98,91.492 5.10.2026 03:30
3800039,39,01.251 4.10.2026 12:30
3782419,79,61.245 4.10.2026 09:30
4140829,79,71.384 4.10.2026 23:30
4041279,89,81.330 4.10.2026 20:30
36995310,610,61.160 4.10.2026 08:30
40574110,810,81.363 4.10.2026 21:30
44796114,314,31.659 5.10.2026 09:30
43241116,816,81.653 5.10.2026 08:59
64564236,736,73.107 6.10.2026 22:15
66822138,438,03.437 7.10.2026 20:40
70241143,343,33.568 8.10.2026 08:30
77620164,856,53.108 8.10.2026 20:03
80971188,988,93.113 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
CPU:8
Session'da görülen wait'ler
–
Başka oturumları bloklama
0
En büyük memory grant
0 KB

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 — 10910:00 — 011:00 — 012:00 — 01213:00 — 014:00 — 015:00 — 01516:00 — 017:00 — 018:00 — 01819:00 — 120:00 — 021:00 — 02122:00 — 023:00 — 0

Sorgu metni

SQL 
WITH mc AS (
            SELECT w.CaseID, q.ObjectName, md.LastChangedUtc AS L,
                   COALESCE((SELECT MAX(l.StartUtc) FROM DBA.CollectionRunLog AS l
                             WHERE l.SourceType = 'METADATA' AND l.Status = 'OK' AND l.ServerID = w.ServerID AND l.DatabaseName = w.DatabaseName
                               AND l.EndUtc < md.LastChangedUtc), DATEADD(day, -1, md.LastChangedUtc)) AS E,
                   w.WinStart, w.ChangeUtc, w.ChangeEndUtc
            FROM #win AS w
            JOIN #pair AS pr ON pr.CaseID = w.CaseID
            JOIN perf.QdsQuery AS q ON q.ServerID = pr.ServerID AND q.DatabaseName = pr.DatabaseName AND q.query_id = pr.query_id
            JOIN perf.MetaModuleDefinition AS md ON md.ServerID = q.ServerID AND md.DatabaseName = q.DatabaseName AND md.object_id = q.object_id
            WHERE md.LastChangedUtc > md.FirstSeenUtc)
        INSERT rag.PlanChangeEvent (CaseID, EventType, EarliestUtc, LatestUtc, ObjectName, OrderUncertain)
        SELECT CaseID, 'ModuleChanged', E, L, ObjectName, CASE WHEN L > ChangeUtc THEN 1 ELSE 0 END
        FROM mc WHERE L >= WinStart AND E <= ChangeEndUtc

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.