Pahalı sorgular0x732FCC5508FB27A0
Demo modu

Sorgu 0x732FCC5508FB27A0

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

Ort. süre 0,2 ms
Ort. CPU 0,2 ms
Bekleme payı %0,1
Ort. mantıksal okuma 22
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. 0,2 ms29.09.2026: 13 çalışma, ort. 0,2 ms30.09.2026: 43 çalışma, ort. 0,2 ms1.10.2026: 6 çalışma, ort. 0,2 ms2.10.2026: 10 çalışma, ort. 0,2 ms4.10.2026: 5 çalışma, ort. 0,2 ms5.10.2026: 26 çalışma, ort. 0,2 ms6.10.2026: 6 çalışma, ort. 0,2 ms7.10.2026: 6 çalışma, ort. 0,2 ms9.10.2026: 4 çalışma, ort. 0,2 ms max 43 çalışma max ort. süre 0,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 82578
  2. 9.10.2026 17:00 yeni plan plan 81570
  3. 9.10.2026 14:00 yeni plan plan 79643
  4. 9.10.2026 14:00 yeni plan plan 80520
  5. 9.10.2026 13:00 yeni plan plan 78677
  6. 8.10.2026 19:00 yeni plan plan 77141
  7. 8.10.2026 18:00 yeni plan plan 76235
  8. 8.10.2026 17:00 yeni plan plan 75372
  9. 8.10.2026 16:00 yeni plan plan 73575
  10. 8.10.2026 16:00 yeni plan plan 74443
  11. 8.10.2026 14:00 yeni plan plan 72590
  12. 8.10.2026 12:00 yeni plan plan 70824
  13. 8.10.2026 12:00 yeni plan plan 71708
  14. 7.10.2026 20:00 yeni plan plan 66410
  15. 7.10.2026 20:00 yeni plan plan 67327
  16. 7.10.2026 20:00 yeni plan plan 68094
  17. 7.10.2026 20:00 yeni plan plan 68933
  18. 7.10.2026 20:00 yeni plan plan 69789
  19. 7.10.2026 13:00 yeni plan plan 65370
  20. 6.10.2026 00:00 yeni plan plan 63930
  21. 5.10.2026 23:00 yeni plan plan 63085
  22. 5.10.2026 22:00 yeni plan plan 60576
  23. 5.10.2026 22:00 yeni plan plan 61449
  24. 5.10.2026 22:00 yeni plan plan 62212
  25. 5.10.2026 21:00 yeni plan plan 58059
  26. 5.10.2026 21:00 yeni plan plan 58911
  27. 5.10.2026 21:00 yeni plan plan 59748
  28. 5.10.2026 20:00 yeni plan plan 57158
  29. 5.10.2026 18:00 yeni plan plan 56307
  30. 5.10.2026 17:00 yeni plan plan 54643
  31. 5.10.2026 17:00 yeni plan plan 55472
  32. 5.10.2026 13:00 yeni plan plan 52962
  33. 5.10.2026 13:00 yeni plan plan 53791
  34. 5.10.2026 12:00 yeni plan plan 49911
  35. 5.10.2026 12:00 yeni plan plan 50601
  36. 5.10.2026 12:00 yeni plan plan 51413
  37. 5.10.2026 12:00 yeni plan plan 52160
  38. 5.10.2026 10:00 yeni plan plan 47315
  39. 5.10.2026 10:00 yeni plan plan 48066
  40. 5.10.2026 10:00 yeni plan plan 49020
  41. 5.10.2026 09:00 yeni plan plan 43592
  42. 5.10.2026 09:00 yeni plan plan 44403
  43. 5.10.2026 09:00 yeni plan plan 45617
  44. 5.10.2026 09:00 yeni plan plan 46368
  45. 5.10.2026 02:00 yeni plan plan 42669
  46. 5.10.2026 00:00 yeni plan plan 41860
  47. 4.10.2026 22:00 yeni plan plan 41021
  48. 4.10.2026 13:00 yeni plan plan 38499
  49. 4.10.2026 13:00 yeni plan plan 39230
  50. 4.10.2026 13:00 yeni plan plan 40017
  51. 4.10.2026 08:00 yeni plan plan 37409
  52. 2.10.2026 17:00 yeni plan plan 35072
  53. 2.10.2026 17:00 yeni plan plan 35775
  54. 2.10.2026 17:00 yeni plan plan 36548
  55. 2.10.2026 16:00 yeni plan plan 34643
  56. 2.10.2026 02:00 yeni plan plan 33696
  57. 2.10.2026 01:00 yeni plan plan 32986
  58. 2.10.2026 00:00 yeni plan plan 31760
  59. 2.10.2026 00:00 yeni plan plan 32348
  60. 1.10.2026 21:00 yeni plan plan 31109
  61. 1.10.2026 20:00 yeni plan plan 29631
  62. 1.10.2026 20:00 yeni plan plan 30309
  63. 1.10.2026 19:00 yeni plan plan 27560
  64. 1.10.2026 19:00 yeni plan plan 28255
  65. 1.10.2026 19:00 yeni plan plan 28923
  66. 30.09.2026 22:00 yeni plan plan 23127
  67. 30.09.2026 22:00 yeni plan plan 23710
  68. 30.09.2026 22:00 yeni plan plan 24282
  69. 30.09.2026 22:00 yeni plan plan 24926
  70. 30.09.2026 22:00 yeni plan plan 25484
  71. 30.09.2026 22:00 yeni plan plan 26167
  72. 30.09.2026 22:00 yeni plan plan 26855
  73. 30.09.2026 21:00 yeni plan plan 20484
  74. 30.09.2026 21:00 yeni plan plan 21161
  75. 30.09.2026 21:00 yeni plan plan 21806
  76. 30.09.2026 21:00 yeni plan plan 22435
  77. 30.09.2026 20:00 yeni plan plan 19773
  78. 30.09.2026 19:00 yeni plan plan 19085
  79. 30.09.2026 15:00 yeni plan plan 17111
  80. 30.09.2026 15:00 yeni plan plan 17783
  81. 30.09.2026 15:00 yeni plan plan 18395
  82. 30.09.2026 11:00 yeni plan plan 14633
  83. 30.09.2026 11:00 yeni plan plan 15269
  84. 30.09.2026 11:00 yeni plan plan 15923
  85. 30.09.2026 11:00 yeni plan plan 16469
  86. 30.09.2026 10:00 yeni plan plan 12923
  87. 30.09.2026 10:00 yeni plan plan 13449
  88. 30.09.2026 10:00 yeni plan plan 13954
  89. 30.09.2026 07:00 yeni plan plan 12316
  90. 30.09.2026 06:00 yeni plan plan 10684
  91. 30.09.2026 06:00 yeni plan plan 11213
  92. 30.09.2026 06:00 yeni plan plan 11736
  93. 30.09.2026 05:00 yeni plan plan 10097
  94. 30.09.2026 00:00 yeni plan plan 9063
  95. 29.09.2026 21:00 yeni plan plan 8123
  96. 29.09.2026 21:00 yeni plan plan 8596
  97. 29.09.2026 20:00 yeni plan plan 7640
  98. 28.09.2026 16:00 yeni plan plan 6098

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2860,20,2 0,218
2026-09-29130,20,2 0,323
2026-09-30430,20,2 0,324
2026-10-0160,20,2 0,317
2026-10-02100,20,2 0,317
2026-10-0450,20,2 0,518
2026-10-05260,20,2 0,226
2026-10-0660,20,2 0,218
2026-10-0760,20,2 0,218
2026-10-0940,20,2 0,218

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
1292310,10,117 30.09.2026 10:51 en iyi
4991110,10,117 5.10.2026 12:32
2616710,10,117 30.09.2026 22:53
2492610,10,117 30.09.2026 22:38
4902010,10,117 5.10.2026 10:42
6978910,10,120 7.10.2026 20:53
5974810,10,117 5.10.2026 21:41
5805910,10,117 5.10.2026 21:02
6308510,10,117 5.10.2026 23:04
4266910,10,120 5.10.2026 02:58
1395410,10,117 30.09.2026 10:56
4359210,10,117 5.10.2026 09:00
1068410,20,126 30.09.2026 06:32
3369610,20,217 2.10.2026 02:27
1009710,20,217 30.09.2026 05:49
2685510,20,217 30.09.2026 22:56
7537210,20,220 8.10.2026 17:17
7357510,20,217 8.10.2026 16:34
1711110,20,217 30.09.2026 15:32
6809410,20,217 7.10.2026 20:50
3849910,20,220 4.10.2026 13:28
5547210,20,220 5.10.2026 17:58
4186010,20,217 5.10.2026 00:27
5060110,20,217 5.10.2026 12:33
2963110,20,217 1.10.2026 20:57
3923010,20,217 4.10.2026 13:31
2892310,20,217 1.10.2026 19:31
4636810,20,217 5.10.2026 09:49
812310,20,217 29.09.2026 21:26
1977310,20,220 30.09.2026 20:42
2312710,20,217 30.09.2026 22:15
6893310,20,220 7.10.2026 20:51
5464310,20,220 5.10.2026 17:49
2048410,20,220 30.09.2026 21:24
8257810,20,217 9.10.2026 19:25
5296210,20,220 5.10.2026 13:19
3176010,20,217 2.10.2026 00:05
2756010,20,217 1.10.2026 19:13
3577510,20,217 2.10.2026 17:32
2548410,20,217 30.09.2026 22:40
6641010,20,217 7.10.2026 20:12
1173620,20,222 30.09.2026 06:59
7623510,20,217 8.10.2026 18:57
3298610,20,217 2.10.2026 01:09
6732710,20,220 7.10.2026 20:49
1646910,20,220 30.09.2026 11:22
6393060,20,218 6.10.2026 05:50
3654830,20,217 2.10.2026 18:17
4102110,20,217 4.10.2026 22:07
6537010,20,217 7.10.2026 13:55
1231610,20,217 30.09.2026 07:00
5141310,20,220 5.10.2026 12:58
5715810,20,217 5.10.2026 20:19
764010,20,220 29.09.2026 20:13
1344910,20,217 30.09.2026 10:52
6221210,20,2116 5.10.2026 22:56
1121310,20,217 30.09.2026 06:58
3464310,20,217 2.10.2026 16:25
8157010,20,217 9.10.2026 17:45
1778310,20,220 30.09.2026 15:42
3110910,20,217 1.10.2026 21:13
7170810,20,217 8.10.2026 12:37
1592320,20,217 30.09.2026 11:20
859610,20,217 29.09.2026 21:50
5630710,20,217 5.10.2026 18:28
7444310,20,217 8.10.2026 16:38
4440310,20,217 5.10.2026 09:09
5891110,20,217 5.10.2026 21:38
8052010,20,220 9.10.2026 14:29
6144910,20,220 5.10.2026 22:55
2243510,20,217 30.09.2026 21:37
3507210,20,217 2.10.2026 17:24
6098160,20,222 29.09.2026 18:42
1908510,20,2101 30.09.2026 19:36
7714110,20,220 8.10.2026 19:59
5216010,20,220 5.10.2026 12:59
2371020,20,218 30.09.2026 22:19
1526920,20,217 30.09.2026 11:15
2180610,20,220 30.09.2026 21:34
4731510,20,217 5.10.2026 10:00
4561710,20,217 5.10.2026 09:48
5379110,20,220 5.10.2026 13:58
7964310,20,217 9.10.2026 14:27
1839510,20,220 30.09.2026 15:51
7867710,20,217 9.10.2026 13:15
2428220,20,218 30.09.2026 22:38
3740910,20,217 4.10.2026 08:55
6057610,20,217 5.10.2026 22:03
4806610,20,2119 5.10.2026 10:03
2825510,20,217 1.10.2026 19:19
9063100,20,233 30.09.2026 05:42
7082410,20,217 8.10.2026 12:20
3030910,30,317 1.10.2026 20:58
7259010,30,320 8.10.2026 14:01
1463310,30,326 30.09.2026 11:02
3234810,40,417 2.10.2026 00:06
4001710,50,520 4.10.2026 13:45
2116111,71,720 30.09.2026 21:32 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
INSERT DBA.CollectionRunLog (StartUtc, EndUtc, SourceType, ServerID, DatabaseName, Status)
    VALUES ('2026-01-04 03:00', '2026-01-04 03:01', 'METADATA', 1, N'db', 'OK')

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.