Pahalı sorgular0xED2CCA66487B504E
Demo modu

Sorgu 0xED2CCA66487B504E

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,9 ms
Ort. CPU 1,9 ms
Bekleme payı %0,7
Ort. mantıksal okuma 150
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,6 ms29.09.2026: 107 çalışma, ort. 1,7 ms30.09.2026: 349 çalışma, ort. 1,7 ms1.10.2026: 49 çalışma, ort. 1,9 ms2.10.2026: 83 çalışma, ort. 1,7 ms3.10.2026: 1 çalışma, ort. 6,0 ms4.10.2026: 57 çalışma, ort. 3,9 ms5.10.2026: 211 çalışma, ort. 1,8 ms6.10.2026: 50 çalışma, ort. 2,2 ms7.10.2026: 49 çalışma, ort. 1,8 ms9.10.2026: 33 çalışma, ort. 3,0 ms max 349 çalışma max ort. süre 6,0 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 82536
  2. 9.10.2026 17:00 yeni plan plan 81541
  3. 9.10.2026 14:00 yeni plan plan 80962
  4. 9.10.2026 14:00 yeni plan plan 80498
  5. 9.10.2026 14:00 yeni plan plan 79596
  6. 9.10.2026 13:00 yeni plan plan 78653
  7. 8.10.2026 20:00 yeni plan plan 77605
  8. 8.10.2026 19:00 yeni plan plan 77167
  9. 8.10.2026 18:00 yeni plan plan 76261
  10. 8.10.2026 17:00 yeni plan plan 75324
  11. 8.10.2026 16:00 yeni plan plan 74425
  12. 8.10.2026 16:00 yeni plan plan 73550
  13. 8.10.2026 14:00 yeni plan plan 72570
  14. 8.10.2026 12:00 yeni plan plan 71658
  15. 8.10.2026 12:00 yeni plan plan 70777
  16. 8.10.2026 08:00 yeni plan plan 70233
  17. 7.10.2026 20:00 yeni plan plan 69769
  18. 7.10.2026 20:00 yeni plan plan 68898
  19. 7.10.2026 20:00 yeni plan plan 67302
  20. 7.10.2026 20:00 yeni plan plan 66814
  21. 7.10.2026 20:00 yeni plan plan 66364
  22. 7.10.2026 13:00 yeni plan plan 65320
  23. 6.10.2026 03:00 yeni plan plan 64556
  24. 6.10.2026 00:00 yeni plan plan 63953
  25. 5.10.2026 23:00 yeni plan plan 63046
  26. 5.10.2026 22:00 yeni plan plan 61433
  27. 5.10.2026 22:00 yeni plan plan 60548
  28. 5.10.2026 21:00 yeni plan plan 58028
  29. 5.10.2026 21:00 yeni plan plan 58890
  30. 5.10.2026 21:00 yeni plan plan 59711
  31. 5.10.2026 20:00 yeni plan plan 57132
  32. 5.10.2026 18:00 yeni plan plan 56286
  33. 5.10.2026 17:00 yeni plan plan 55438
  34. 5.10.2026 17:00 yeni plan plan 54617
  35. 5.10.2026 13:00 yeni plan plan 53745
  36. 5.10.2026 13:00 yeni plan plan 52926
  37. 5.10.2026 12:00 yeni plan plan 51399
  38. 5.10.2026 12:00 yeni plan plan 49865
  39. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  40. 5.10.2026 10:00 yeni plan plan 48971
  41. 5.10.2026 10:00 yeni plan plan 48089
  42. 5.10.2026 10:00 yeni plan plan 47286
  43. 5.10.2026 09:00 yeni plan plan 45592
  44. 5.10.2026 09:00 yeni plan plan 44788
  45. 5.10.2026 09:00 yeni plan plan 44357
  46. 5.10.2026 09:00 yeni plan plan 43572
  47. 5.10.2026 08:00 yeni plan plan 43231
  48. 5.10.2026 03:00 yeni plan plan 43041
  49. 5.10.2026 02:00 yeni plan plan 42622
  50. 5.10.2026 00:00 yeni plan plan 41815
  51. 4.10.2026 22:00 yeni plan plan 41400
  52. 4.10.2026 22:00 yeni plan plan 40973
  53. 4.10.2026 21:00 yeni plan plan 40565
  54. 4.10.2026 14:00 yeni plan plan 40404
  55. 4.10.2026 13:00 yeni plan plan 39999
  56. 4.10.2026 13:00 yeni plan plan 39253
  57. 4.10.2026 13:00 yeni plan plan 38862
  58. 4.10.2026 13:00 yeni plan plan 38482
  59. 4.10.2026 10:00 yeni plan plan 37991
  60. 4.10.2026 09:00 yeni plan plan 37816
  61. 4.10.2026 08:00 yeni plan plan 37435
  62. 3.10.2026 03:00 yeni plan plan 36987
  63. 2.10.2026 17:00 yeni plan plan 36516
  64. 2.10.2026 17:00 yeni plan plan 35801
  65. 2.10.2026 17:00 yeni plan plan 35055
  66. 2.10.2026 16:00 yeni plan plan 34111
  67. 2.10.2026 02:00 yeni plan plan 33666
  68. 2.10.2026 01:00 yeni plan plan 32968
  69. 2.10.2026 00:00 yeni plan plan 31746
  70. 1.10.2026 21:00 yeni plan plan 31088
  71. 1.10.2026 21:00 yeni plan plan 30695
  72. 1.10.2026 20:00 yeni plan plan 30262
  73. 1.10.2026 20:00 yeni plan plan 29612
  74. 1.10.2026 19:00 yeni plan plan 28887
  75. 1.10.2026 19:00 yeni plan plan 28208
  76. 1.10.2026 19:00 yeni plan plan 27537
  77. 30.09.2026 22:00 yeni plan plan 26836
  78. 30.09.2026 22:00 yeni plan plan 26190
  79. 30.09.2026 22:00 yeni plan plan 25510
  80. 30.09.2026 22:00 yeni plan plan 24560
  81. 30.09.2026 22:00 yeni plan plan 24266
  82. 30.09.2026 22:00 yeni plan plan 24065
  83. 30.09.2026 22:00 yeni plan plan 23736
  84. 30.09.2026 22:00 yeni plan plan 23090
  85. 30.09.2026 21:00 yeni plan plan 20452
  86. 30.09.2026 21:00 yeni plan plan 20753
  87. 30.09.2026 21:00 yeni plan plan 21119
  88. 30.09.2026 21:00 yeni plan plan 21769
  89. 30.09.2026 21:00 yeni plan plan 22412
  90. 30.09.2026 20:00 yeni plan plan 19755
  91. 30.09.2026 20:00 yeni plan plan 19348
  92. 30.09.2026 19:00 yeni plan plan 19036
  93. 30.09.2026 15:00 yeni plan plan 18367
  94. 30.09.2026 15:00 yeni plan plan 17735
  95. 30.09.2026 15:00 yeni plan plan 17083
  96. 30.09.2026 11:00 yeni plan plan 15557
  97. 30.09.2026 11:00 yeni plan plan 15224
  98. 30.09.2026 11:00 yeni plan plan 14586
  99. 30.09.2026 10:00 yeni plan plan 13980
  100. 30.09.2026 10:00 yeni plan plan 12884
  101. 30.09.2026 06:00 yeni plan plan 11970
  102. 30.09.2026 06:00 yeni plan plan 11195
  103. 30.09.2026 06:00 yeni plan plan 10632
  104. 30.09.2026 05:00 yeni plan plan 10069
  105. 30.09.2026 03:00 yeni plan plan 9488
  106. 30.09.2026 00:00 yeni plan plan 9033
  107. 29.09.2026 21:00 yeni plan plan 8577
  108. 29.09.2026 21:00 yeni plan plan 8149
  109. 29.09.2026 20:00 yeni plan plan 7669
  110. 28.09.2026 19:00 yeni plan plan 6564
  111. 28.09.2026 19:00 yeni plan plan 6478
  112. 28.09.2026 16:00 yeni plan plan 6071
  113. 28.09.2026 16:00 yeni plan plan 6030
  114. 28.09.2026 16:00 yeni plan plan 5998

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28531,61,6 1,9106
2026-09-291071,71,7 2,2103
2026-09-303491,71,7 2,0104
2026-10-01491,71,9 13,1107
2026-10-02831,71,7 2,1105
2026-10-0316,06,0 6,01.268
2026-10-04573,93,9 10,8566
2026-10-052111,81,8 12,8129
2026-10-06502,22,2 20,1238
2026-10-07491,81,8 15,2182
2026-10-09333,03,0 36,5244

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
647861,31,3128 29.09.2026 13:36 en iyi
1934821,31,3152 30.09.2026 20:30
1006981,41,4101 30.09.2026 05:49
6889881,41,4103 7.10.2026 20:51
857781,41,4103 29.09.2026 21:50
814981,41,4101 29.09.2026 21:26
7165881,41,4103 8.10.2026 12:37
6976981,41,4106 7.10.2026 20:53
2961281,41,4101 1.10.2026 20:57
6636481,41,4101 7.10.2026 20:12
6304681,41,4106 5.10.2026 23:04
11195161,51,5102 30.09.2026 06:59
2888781,51,5103 1.10.2026 19:31
1063281,51,4102 30.09.2026 06:32
3296881,51,5106 2.10.2026 01:09
67302161,51,5100 7.10.2026 20:50
4808981,51,5105 5.10.2026 10:03
7077781,51,5103 8.10.2026 12:20
3999981,51,5102 4.10.2026 13:45
36516241,51,5105 2.10.2026 18:17
34111111,51,5103 2.10.2026 16:25
5374581,51,5100 5.10.2026 13:58
4728681,51,5102 5.10.2026 10:00
5628681,51,5101 5.10.2026 18:28
3366681,51,5104 2.10.2026 02:27
63953481,51,5103 6.10.2026 05:50
603011,51,5160 28.09.2026 16:25
6532081,61,6101 7.10.2026 13:55
4897181,61,6100 5.10.2026 10:42
7257081,61,6103 8.10.2026 14:01
766981,61,6102 29.09.2026 20:13
6054881,61,6100 5.10.2026 22:04
1398081,61,6104 30.09.2026 10:56
7716781,61,6103 8.10.2026 19:59
3108881,61,6101 1.10.2026 21:13
2683681,61,6104 30.09.2026 22:56
5971181,61,6104 5.10.2026 21:41
61433161,61,6107 5.10.2026 22:56
7532481,61,5101 8.10.2026 17:17
8253681,61,6102 9.10.2026 19:25
4357281,61,6103 5.10.2026 09:01
948811,61,6194 30.09.2026 03:30
3026281,61,6105 1.10.2026 20:58
4181581,61,6104 5.10.2026 00:27
4435781,61,6102 5.10.2026 09:09
1836781,61,6102 30.09.2026 15:51
1903681,61,6102 30.09.2026 19:36
7959681,61,6106 9.10.2026 14:27
3848281,61,6101 4.10.2026 13:29
4097381,61,6107 4.10.2026 22:07
5713281,61,6102 5.10.2026 20:19
2619081,61,6104 30.09.2026 22:53
2551081,61,6103 30.09.2026 22:40
5802881,61,6103 5.10.2026 21:02
5543881,61,6101 5.10.2026 17:58
7442581,61,6103 8.10.2026 16:38
1773581,61,6104 30.09.2026 15:42
8154181,61,6102 9.10.2026 17:45
11970161,61,6100 30.09.2026 07:00
4262281,71,7103 5.10.2026 02:58
599811,71,7147 28.09.2026 16:24
2820881,71,7103 1.10.2026 19:19
2309081,71,7102 30.09.2026 22:15
5292681,71,7102 5.10.2026 13:19
45592161,71,7101 5.10.2026 09:49
8049881,71,7103 9.10.2026 14:29
23736161,71,7102 30.09.2026 22:19
12884161,71,7105 30.09.2026 10:52
15557321,71,7102 30.09.2026 11:22
1522481,71,7102 30.09.2026 11:08
1708381,71,7103 30.09.2026 15:32
2111981,71,7103 30.09.2026 21:32
9033801,71,7103 30.09.2026 05:42
49865161,71,7103 5.10.2026 12:33
65641041,81,8103 29.09.2026 18:42
2241281,81,8103 30.09.2026 21:37
6071241,81,8103 28.09.2026 17:03
2426681,81,8102 30.09.2026 22:35
5461781,81,8104 5.10.2026 17:49
24560161,81,8105 30.09.2026 22:38
3580181,81,8106 2.10.2026 17:32
2406511,81,8117 30.09.2026 22:30
5889081,81,8101 5.10.2026 21:38
51399161,81,8102 5.10.2026 12:59
1458681,81,8103 30.09.2026 11:02
2753781,91,9105 1.10.2026 19:13
2176981,91,8104 30.09.2026 21:34
1975581,91,9104 30.09.2026 20:42
31746161,91,9106 2.10.2026 00:06
7865382,02,0105 9.10.2026 13:15
3743582,12,1101 4.10.2026 08:55
3505582,22,2109 2.10.2026 17:24
2075312,22,2183 30.09.2026 21:30
3925382,32,3102 4.10.2026 13:31
7626182,52,5105 8.10.2026 18:57
7355082,62,5102 8.10.2026 16:34
2045283,83,8103 30.09.2026 21:24
3698736,56,51.371 4.10.2026 08:30
3886217,87,81.582 4.10.2026 13:30
3781617,97,91.523 4.10.2026 09:30
3799138,07,91.559 4.10.2026 12:30
4040479,39,31.745 4.10.2026 20:30
4056519,89,81.760 4.10.2026 21:30
4304119,99,91.927 5.10.2026 03:30
41400211,211,21.774 4.10.2026 23:30
43231113,513,51.940 5.10.2026 08:59
30695117,85,8301 1.10.2026 21:13
44788118,218,21.981 5.10.2026 09:30
64556218,318,33.481 6.10.2026 22:15
66814119,719,04.023 7.10.2026 20:40
77605144,732,94.690 8.10.2026 20:03
80962145,245,24.708 9.10.2026 14:52
702331112,034,74.252 8.10.2026 08:30 en kötü

Davranış

Wait kategorileri (QDS)
Preemptive:46,Tran Log IO:21,CPU:12
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 po.CaseID, po.ServerID, po.DatabaseName, mo.object_id, po.SchemaName, po.TableName
        INTO #ptab
        FROM #pobj AS po
        JOIN perf.MetaObject AS mo ON mo.ServerID = po.ServerID AND mo.DatabaseName = po.DatabaseName
             AND mo.SchemaName = po.SchemaName AND mo.ObjectName = po.TableName

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.