Pahalı sorgular0x40ED0BE22D211CD5
Demo modu

Sorgu 0x40ED0BE22D211CD5

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ı %6,5
Ort. mantıksal okuma 11
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,3 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,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 82528
  2. 9.10.2026 17:00 yeni plan plan 81533
  3. 9.10.2026 14:00 yeni plan plan 80490
  4. 9.10.2026 14:00 yeni plan plan 79588
  5. 9.10.2026 13:00 yeni plan plan 78645
  6. 8.10.2026 18:00 yeni plan plan 76253
  7. 8.10.2026 17:00 yeni plan plan 75316
  8. 8.10.2026 16:00 yeni plan plan 74417
  9. 8.10.2026 16:00 yeni plan plan 73542
  10. 8.10.2026 14:00 yeni plan plan 72562
  11. 8.10.2026 12:00 yeni plan plan 71650
  12. 8.10.2026 12:00 yeni plan plan 70769
  13. 7.10.2026 20:00 yeni plan plan 68890
  14. 7.10.2026 20:00 yeni plan plan 67294
  15. 7.10.2026 13:00 yeni plan plan 65312
  16. 5.10.2026 23:00 yeni plan plan 63038
  17. 5.10.2026 22:00 yeni plan plan 61425
  18. 5.10.2026 22:00 yeni plan plan 60540
  19. 5.10.2026 21:00 yeni plan plan 58020
  20. 5.10.2026 21:00 yeni plan plan 58882
  21. 5.10.2026 21:00 yeni plan plan 59703
  22. 5.10.2026 20:00 yeni plan plan 57124
  23. 5.10.2026 18:00 yeni plan plan 56278
  24. 5.10.2026 17:00 yeni plan plan 55430
  25. 5.10.2026 17:00 yeni plan plan 54609
  26. 5.10.2026 13:00 yeni plan plan 53737
  27. 5.10.2026 13:00 yeni plan plan 52918
  28. 5.10.2026 12:00 yeni plan plan 51391
  29. 5.10.2026 12:00 yeni plan plan 49857
  30. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  31. 5.10.2026 10:00 yeni plan plan 48963
  32. 5.10.2026 10:00 yeni plan plan 48081
  33. 5.10.2026 10:00 yeni plan plan 47278
  34. 5.10.2026 09:00 yeni plan plan 45584
  35. 5.10.2026 09:00 yeni plan plan 43565
  36. 5.10.2026 08:00 yeni plan plan 43223
  37. 5.10.2026 00:00 yeni plan plan 41807
  38. 4.10.2026 13:00 yeni plan plan 39245
  39. 2.10.2026 17:00 yeni plan plan 35793
  40. 2.10.2026 17:00 yeni plan plan 35047
  41. 2.10.2026 16:00 yeni plan plan 34103
  42. 2.10.2026 02:00 yeni plan plan 33658
  43. 2.10.2026 01:00 yeni plan plan 32960
  44. 2.10.2026 00:00 yeni plan plan 31738
  45. 1.10.2026 21:00 yeni plan plan 31081
  46. 1.10.2026 21:00 yeni plan plan 30684
  47. 1.10.2026 20:00 yeni plan plan 30254
  48. 1.10.2026 20:00 yeni plan plan 29604
  49. 1.10.2026 19:00 yeni plan plan 28879
  50. 1.10.2026 19:00 yeni plan plan 28200
  51. 1.10.2026 19:00 yeni plan plan 27529
  52. 30.09.2026 22:00 yeni plan plan 26828
  53. 30.09.2026 22:00 yeni plan plan 26182
  54. 30.09.2026 22:00 yeni plan plan 25502
  55. 30.09.2026 22:00 yeni plan plan 24552
  56. 30.09.2026 22:00 yeni plan plan 24258
  57. 30.09.2026 22:00 yeni plan plan 23082
  58. 30.09.2026 21:00 yeni plan plan 22404
  59. 30.09.2026 21:00 yeni plan plan 21761
  60. 30.09.2026 21:00 yeni plan plan 21111
  61. 30.09.2026 20:00 yeni plan plan 19747
  62. 30.09.2026 15:00 yeni plan plan 17075
  63. 30.09.2026 15:00 yeni plan plan 17727
  64. 30.09.2026 15:00 yeni plan plan 18359
  65. 30.09.2026 11:00 yeni plan plan 15549
  66. 30.09.2026 11:00 yeni plan plan 15216
  67. 30.09.2026 11:00 yeni plan plan 14578
  68. 30.09.2026 10:00 yeni plan plan 13972
  69. 30.09.2026 10:00 yeni plan plan 12876
  70. 30.09.2026 06:00 yeni plan plan 11962
  71. 30.09.2026 06:00 yeni plan plan 11187
  72. 30.09.2026 06:00 yeni plan plan 10624
  73. 30.09.2026 05:00 yeni plan plan 10061
  74. 30.09.2026 03:00 yeni plan plan 9482
  75. 30.09.2026 00:00 yeni plan plan 9025
  76. 29.09.2026 21:00 yeni plan plan 8569
  77. 29.09.2026 21:00 yeni plan plan 8141
  78. 29.09.2026 20:00 yeni plan plan 7661
  79. 28.09.2026 19:00 yeni plan plan 6557
  80. 28.09.2026 19:00 yeni plan plan 6470
  81. 28.09.2026 16:00 yeni plan plan 6064
  82. 28.09.2026 16:00 yeni plan plan 6022

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28520,10,1 0,10
2026-09-291070,10,1 0,40
2026-09-303130,10,1 0,20
2026-10-01490,10,1 0,68
2026-10-02590,10,1 0,10
2026-10-0480,10,1 0,10
2026-10-051930,30,3 0,147
2026-10-07400,10,1 0,10
2026-10-09320,10,1 0,10

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
5802080,10,10 5.10.2026 21:02 en iyi
2550280,10,10 30.09.2026 22:40
1006180,10,10 30.09.2026 05:49
67294160,10,10 7.10.2026 20:50
5460980,10,10 5.10.2026 17:49
4356580,10,10 5.10.2026 09:01
8153380,10,10 9.10.2026 17:45
11962160,10,10 30.09.2026 07:00
5627880,10,10 5.10.2026 18:28
4727880,10,10 5.10.2026 10:00
3025480,10,10 1.10.2026 20:58
8252880,10,10 9.10.2026 19:25
24552160,10,10 30.09.2026 22:38
1707580,10,10 30.09.2026 15:32
5712480,10,10 5.10.2026 20:19
2682880,10,10 30.09.2026 22:56
5543080,10,10 5.10.2026 17:58
2960480,10,10 1.10.2026 20:57
8049080,10,10 9.10.2026 14:29
3365880,10,10 2.10.2026 02:27
1772780,10,10 30.09.2026 15:42
2240480,10,10 30.09.2026 21:37
6889080,10,10 7.10.2026 20:51
5888280,10,10 5.10.2026 21:38
12876160,10,10 30.09.2026 10:52
11187160,10,10 30.09.2026 06:59
6064240,10,10 28.09.2026 17:03
4808180,10,10 5.10.2026 10:03
1062480,10,10 30.09.2026 06:32
766180,10,10 29.09.2026 20:13
6054080,10,10 5.10.2026 22:04
5291880,10,10 5.10.2026 13:19
45584160,10,10 5.10.2026 09:49
3296080,10,10 2.10.2026 01:09
5970380,10,10 5.10.2026 21:41
1974780,10,10 30.09.2026 20:42
7441780,10,10 8.10.2026 16:38
1521680,10,10 30.09.2026 11:08
6531280,10,10 7.10.2026 13:55
3579380,10,10 2.10.2026 17:32
2752980,10,10 1.10.2026 19:13
814180,10,10 29.09.2026 21:26
2618280,10,10 30.09.2026 22:53
2887980,10,10 1.10.2026 19:31
4896380,10,10 5.10.2026 10:42
2308280,10,10 30.09.2026 22:15
7165080,10,10 8.10.2026 12:37
7076980,10,10 8.10.2026 12:20
6303880,10,10 5.10.2026 23:04
61425160,10,10 5.10.2026 22:56
15549320,10,10 30.09.2026 11:22
65571040,10,10 29.09.2026 18:42
2176180,10,10 30.09.2026 21:34
856980,10,10 29.09.2026 21:50
1397280,10,10 30.09.2026 10:56
4180780,10,10 5.10.2026 00:27
34103110,10,10 2.10.2026 16:25
2425880,10,10 30.09.2026 22:35
1835980,10,10 30.09.2026 15:51
2111180,10,10 30.09.2026 21:32
7958880,10,10 9.10.2026 14:27
49857160,10,10 5.10.2026 12:33
2820080,10,10 1.10.2026 19:19
5373780,10,10 5.10.2026 13:58
3108180,10,10 1.10.2026 21:13
7864580,10,10 9.10.2026 13:15
7354280,10,10 8.10.2026 16:34
3924580,10,10 4.10.2026 13:31
9025800,10,10 30.09.2026 05:42
7256280,10,10 8.10.2026 14:01
7625380,10,10 8.10.2026 18:57
7531680,10,10 8.10.2026 17:17
602210,10,10 28.09.2026 16:25
51391160,10,10 5.10.2026 12:59
31738160,10,10 2.10.2026 00:06
3504780,10,10 2.10.2026 17:24
1457880,20,20 30.09.2026 11:02
647060,20,14 29.09.2026 13:36
948210,20,233 30.09.2026 03:30
3068410,90,8404 1.10.2026 21:13
43223145,438,88.997 5.10.2026 08:59 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:9
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 e FROM rag.PlanChangeEvent AS e WHERE e.CaseID IN (SELECT CaseID FROM #pair)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.