Pahalı sorgular0xEF323D8DAD03C60B
Demo modu

Sorgu 0xEF323D8DAD03C60B

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

Ort. süre 0,1 ms
Ort. CPU 0,1 ms
Bekleme payı %1,6
Ort. mantıksal okuma 5
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: 52 çalışma, ort. 0,1 ms29.09.2026: 107 çalışma, ort. 0,1 ms30.09.2026: 313 çalışma, ort. 0,1 ms1.10.2026: 49 çalışma, ort. 0,1 ms2.10.2026: 59 çalışma, ort. 0,1 ms4.10.2026: 8 çalışma, ort. 0,1 ms5.10.2026: 193 çalışma, ort. 0,1 ms7.10.2026: 40 çalışma, ort. 0,1 ms9.10.2026: 32 çalışma, ort. 0,1 ms max 313 çalışma max ort. süre 0,1 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 82525
  2. 9.10.2026 17:00 yeni plan plan 81530
  3. 9.10.2026 14:00 yeni plan plan 80487
  4. 9.10.2026 14:00 yeni plan plan 79585
  5. 9.10.2026 13:00 yeni plan plan 78642
  6. 8.10.2026 18:00 yeni plan plan 76250
  7. 8.10.2026 17:00 yeni plan plan 75313
  8. 8.10.2026 16:00 yeni plan plan 74414
  9. 8.10.2026 16:00 yeni plan plan 73539
  10. 8.10.2026 14:00 yeni plan plan 72559
  11. 8.10.2026 12:00 yeni plan plan 71647
  12. 8.10.2026 12:00 yeni plan plan 70766
  13. 7.10.2026 20:00 yeni plan plan 68887
  14. 7.10.2026 20:00 yeni plan plan 67291
  15. 7.10.2026 13:00 yeni plan plan 65309
  16. 5.10.2026 23:00 yeni plan plan 63035
  17. 5.10.2026 22:00 yeni plan plan 61422
  18. 5.10.2026 22:00 yeni plan plan 60537
  19. 5.10.2026 21:00 yeni plan plan 58017
  20. 5.10.2026 21:00 yeni plan plan 58879
  21. 5.10.2026 21:00 yeni plan plan 59700
  22. 5.10.2026 20:00 yeni plan plan 57121
  23. 5.10.2026 18:00 yeni plan plan 56275
  24. 5.10.2026 17:00 yeni plan plan 55427
  25. 5.10.2026 17:00 yeni plan plan 54606
  26. 5.10.2026 13:00 yeni plan plan 53734
  27. 5.10.2026 13:00 yeni plan plan 52915
  28. 5.10.2026 12:00 yeni plan plan 51388
  29. 5.10.2026 12:00 yeni plan plan 49854
  30. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  31. 5.10.2026 10:00 yeni plan plan 48960
  32. 5.10.2026 10:00 yeni plan plan 48078
  33. 5.10.2026 10:00 yeni plan plan 47275
  34. 5.10.2026 09:00 yeni plan plan 45581
  35. 5.10.2026 09:00 yeni plan plan 43562
  36. 5.10.2026 08:00 yeni plan plan 43220
  37. 5.10.2026 00:00 yeni plan plan 41804
  38. 4.10.2026 13:00 yeni plan plan 39242
  39. 2.10.2026 17:00 yeni plan plan 35790
  40. 2.10.2026 17:00 yeni plan plan 35044
  41. 2.10.2026 16:00 yeni plan plan 34100
  42. 2.10.2026 02:00 yeni plan plan 33655
  43. 2.10.2026 01:00 yeni plan plan 32957
  44. 2.10.2026 00:00 yeni plan plan 31735
  45. 1.10.2026 21:00 yeni plan plan 31078
  46. 1.10.2026 21:00 yeni plan plan 30681
  47. 1.10.2026 20:00 yeni plan plan 30251
  48. 1.10.2026 20:00 yeni plan plan 29601
  49. 1.10.2026 19:00 yeni plan plan 28876
  50. 1.10.2026 19:00 yeni plan plan 28197
  51. 1.10.2026 19:00 yeni plan plan 27526
  52. 30.09.2026 22:00 yeni plan plan 26825
  53. 30.09.2026 22:00 yeni plan plan 26179
  54. 30.09.2026 22:00 yeni plan plan 25499
  55. 30.09.2026 22:00 yeni plan plan 24549
  56. 30.09.2026 22:00 yeni plan plan 24255
  57. 30.09.2026 22:00 yeni plan plan 23079
  58. 30.09.2026 21:00 yeni plan plan 22401
  59. 30.09.2026 21:00 yeni plan plan 21758
  60. 30.09.2026 21:00 yeni plan plan 21108
  61. 30.09.2026 20:00 yeni plan plan 19744
  62. 30.09.2026 15:00 yeni plan plan 17072
  63. 30.09.2026 15:00 yeni plan plan 17724
  64. 30.09.2026 15:00 yeni plan plan 18356
  65. 30.09.2026 11:00 yeni plan plan 15546
  66. 30.09.2026 11:00 yeni plan plan 15213
  67. 30.09.2026 11:00 yeni plan plan 14575
  68. 30.09.2026 10:00 yeni plan plan 13969
  69. 30.09.2026 10:00 yeni plan plan 12873
  70. 30.09.2026 06:00 yeni plan plan 11959
  71. 30.09.2026 06:00 yeni plan plan 11184
  72. 30.09.2026 06:00 yeni plan plan 10621
  73. 30.09.2026 05:00 yeni plan plan 10058
  74. 30.09.2026 03:00 yeni plan plan 9479
  75. 30.09.2026 00:00 yeni plan plan 9022
  76. 29.09.2026 21:00 yeni plan plan 8566
  77. 29.09.2026 21:00 yeni plan plan 8138
  78. 29.09.2026 20:00 yeni plan plan 7658
  79. 28.09.2026 19:00 yeni plan plan 6554
  80. 28.09.2026 19:00 yeni plan plan 6467
  81. 28.09.2026 16:00 yeni plan plan 6061
  82. 28.09.2026 16:00 yeni plan plan 6019

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28520,10,1 0,210
2026-09-291070,10,1 0,35
2026-09-303130,10,1 0,14
2026-10-01490,10,1 1,513
2026-10-02590,10,1 0,14
2026-10-0480,10,1 0,13
2026-10-051930,10,1 0,14
2026-10-07400,10,1 0,13
2026-10-09320,10,1 0,13

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
1005880,10,13 30.09.2026 05:49 en iyi
1707280,10,13 30.09.2026 15:32
1396980,10,13 30.09.2026 10:56
12873160,10,13 30.09.2026 10:52
5801780,10,13 5.10.2026 21:02
1062180,10,13 30.09.2026 06:32
3025180,10,13 1.10.2026 20:58
8252580,10,13 9.10.2026 19:25
67291160,10,13 7.10.2026 20:50
11959160,10,13 30.09.2026 07:00
5460680,10,13 5.10.2026 17:49
3365580,10,13 2.10.2026 02:27
11184160,10,13 30.09.2026 06:59
2960180,10,13 1.10.2026 20:57
8153080,10,13 9.10.2026 17:45
24549160,10,13 30.09.2026 22:38
5542780,10,13 5.10.2026 17:58
813880,10,13 29.09.2026 21:26
6888780,10,13 7.10.2026 20:51
1457580,10,13 30.09.2026 11:02
2549980,10,13 30.09.2026 22:40
6061240,10,13 28.09.2026 17:03
5970080,10,13 5.10.2026 21:41
856680,10,13 29.09.2026 21:50
8048780,10,13 9.10.2026 14:29
2682580,10,13 30.09.2026 22:56
2425580,10,13 30.09.2026 22:35
6530980,10,13 7.10.2026 13:55
5712180,10,13 5.10.2026 20:19
4727580,10,13 5.10.2026 10:00
3579080,10,13 2.10.2026 17:32
2307980,10,13 30.09.2026 22:15
7441480,10,13 8.10.2026 16:38
2175880,10,13 30.09.2026 21:34
2240180,10,13 30.09.2026 21:37
2752680,10,13 1.10.2026 19:13
6053780,10,13 5.10.2026 22:04
7958580,10,13 9.10.2026 14:27
5887980,10,13 5.10.2026 21:38
4896080,10,13 5.10.2026 10:42
7164780,10,13 8.10.2026 12:37
6303580,10,13 5.10.2026 23:04
5291580,10,13 5.10.2026 13:19
2887680,10,13 1.10.2026 19:31
1974480,10,13 30.09.2026 20:42
1772480,10,13 30.09.2026 15:42
765880,10,13 29.09.2026 20:13
5627580,10,13 5.10.2026 18:28
3295780,10,13 2.10.2026 01:09
45581160,10,13 5.10.2026 09:49
61422160,10,13 5.10.2026 22:57
1835680,10,13 30.09.2026 15:51
34100110,10,15 2.10.2026 16:25
7076680,10,13 8.10.2026 12:20
7255980,10,13 8.10.2026 14:01
65541040,10,13 29.09.2026 18:42
7531380,10,13 8.10.2026 17:17
4807880,10,13 5.10.2026 10:03
3504480,10,13 2.10.2026 17:24
2110880,10,13 30.09.2026 21:32
4180480,10,13 5.10.2026 00:27
1521380,10,13 30.09.2026 11:08
49854160,10,13 5.10.2026 12:33
7864280,10,13 9.10.2026 13:15
3107880,10,13 1.10.2026 21:13
3924280,10,13 4.10.2026 13:31
9022800,10,13 30.09.2026 05:42
51388160,10,13 5.10.2026 12:59
2617980,10,13 30.09.2026 22:53
7625080,10,13 8.10.2026 18:57
4356280,10,13 5.10.2026 09:01
5373480,10,13 5.10.2026 13:58
15546320,10,13 30.09.2026 11:22
2819780,10,13 1.10.2026 19:19
31735160,10,13 2.10.2026 00:06
646760,20,276 29.09.2026 13:36
601910,20,267 28.09.2026 16:25
7353980,30,33 8.10.2026 16:34
4322011,91,940 5.10.2026 08:59
3068112,01,0473 1.10.2026 21:13
947912,32,3131 30.09.2026 03:30 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 
DELETE m FROM rag.PlanChangeMetric AS m WHERE m.CaseID IN (SELECT CaseID FROM #pair)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.