Pahalı sorgular0x4603DD195DEDCF00
Demo modu

Sorgu 0x4603DD195DEDCF00

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ı %0,5
Ort. mantıksal okuma 2
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 82527
  2. 9.10.2026 17:00 yeni plan plan 81532
  3. 9.10.2026 14:00 yeni plan plan 80489
  4. 9.10.2026 14:00 yeni plan plan 79587
  5. 9.10.2026 13:00 yeni plan plan 78644
  6. 8.10.2026 18:00 yeni plan plan 76252
  7. 8.10.2026 17:00 yeni plan plan 75315
  8. 8.10.2026 16:00 yeni plan plan 74416
  9. 8.10.2026 16:00 yeni plan plan 73541
  10. 8.10.2026 14:00 yeni plan plan 72561
  11. 8.10.2026 12:00 yeni plan plan 71649
  12. 8.10.2026 12:00 yeni plan plan 70768
  13. 7.10.2026 20:00 yeni plan plan 68889
  14. 7.10.2026 20:00 yeni plan plan 67293
  15. 7.10.2026 13:00 yeni plan plan 65311
  16. 5.10.2026 23:00 yeni plan plan 63037
  17. 5.10.2026 22:00 yeni plan plan 61424
  18. 5.10.2026 22:00 yeni plan plan 60539
  19. 5.10.2026 21:00 yeni plan plan 58019
  20. 5.10.2026 21:00 yeni plan plan 58881
  21. 5.10.2026 21:00 yeni plan plan 59702
  22. 5.10.2026 20:00 yeni plan plan 57123
  23. 5.10.2026 18:00 yeni plan plan 56277
  24. 5.10.2026 17:00 yeni plan plan 55429
  25. 5.10.2026 17:00 yeni plan plan 54608
  26. 5.10.2026 13:00 yeni plan plan 53736
  27. 5.10.2026 13:00 yeni plan plan 52917
  28. 5.10.2026 12:00 yeni plan plan 51390
  29. 5.10.2026 12:00 yeni plan plan 49856
  30. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  31. 5.10.2026 10:00 yeni plan plan 48962
  32. 5.10.2026 10:00 yeni plan plan 48080
  33. 5.10.2026 10:00 yeni plan plan 47277
  34. 5.10.2026 09:00 yeni plan plan 45583
  35. 5.10.2026 09:00 yeni plan plan 43564
  36. 5.10.2026 08:00 yeni plan plan 43222
  37. 5.10.2026 00:00 yeni plan plan 41806
  38. 4.10.2026 13:00 yeni plan plan 39244
  39. 2.10.2026 17:00 yeni plan plan 35792
  40. 2.10.2026 17:00 yeni plan plan 35046
  41. 2.10.2026 16:00 yeni plan plan 34102
  42. 2.10.2026 02:00 yeni plan plan 33657
  43. 2.10.2026 01:00 yeni plan plan 32959
  44. 2.10.2026 00:00 yeni plan plan 31737
  45. 1.10.2026 21:00 yeni plan plan 31080
  46. 1.10.2026 21:00 yeni plan plan 30683
  47. 1.10.2026 20:00 yeni plan plan 30253
  48. 1.10.2026 20:00 yeni plan plan 29603
  49. 1.10.2026 19:00 yeni plan plan 28878
  50. 1.10.2026 19:00 yeni plan plan 28199
  51. 1.10.2026 19:00 yeni plan plan 27528
  52. 30.09.2026 22:00 yeni plan plan 26827
  53. 30.09.2026 22:00 yeni plan plan 26181
  54. 30.09.2026 22:00 yeni plan plan 25501
  55. 30.09.2026 22:00 yeni plan plan 24551
  56. 30.09.2026 22:00 yeni plan plan 24257
  57. 30.09.2026 22:00 yeni plan plan 23081
  58. 30.09.2026 21:00 yeni plan plan 22403
  59. 30.09.2026 21:00 yeni plan plan 21760
  60. 30.09.2026 21:00 yeni plan plan 21110
  61. 30.09.2026 20:00 yeni plan plan 19746
  62. 30.09.2026 15:00 yeni plan plan 17074
  63. 30.09.2026 15:00 yeni plan plan 17726
  64. 30.09.2026 15:00 yeni plan plan 18358
  65. 30.09.2026 11:00 yeni plan plan 15548
  66. 30.09.2026 11:00 yeni plan plan 15215
  67. 30.09.2026 11:00 yeni plan plan 14577
  68. 30.09.2026 10:00 yeni plan plan 13971
  69. 30.09.2026 10:00 yeni plan plan 12875
  70. 30.09.2026 06:00 yeni plan plan 11961
  71. 30.09.2026 06:00 yeni plan plan 11186
  72. 30.09.2026 06:00 yeni plan plan 10623
  73. 30.09.2026 05:00 yeni plan plan 10060
  74. 30.09.2026 03:00 yeni plan plan 9481
  75. 30.09.2026 00:00 yeni plan plan 9024
  76. 29.09.2026 21:00 yeni plan plan 8568
  77. 29.09.2026 21:00 yeni plan plan 8140
  78. 29.09.2026 20:00 yeni plan plan 7660
  79. 28.09.2026 19:00 yeni plan plan 6556
  80. 28.09.2026 19:00 yeni plan plan 6469
  81. 28.09.2026 16:00 yeni plan plan 6063
  82. 28.09.2026 16:00 yeni plan plan 6021

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28520,10,1 0,318
2026-09-291070,10,1 0,45
2026-09-303130,10,1 0,11
2026-10-01490,10,1 0,32
2026-10-02590,10,1 0,10
2026-10-0480,10,1 0,10
2026-10-051930,10,1 0,10
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
1006080,10,10 30.09.2026 05:49 en iyi
6053980,10,10 5.10.2026 22:04
12875160,10,10 30.09.2026 10:52
2550180,10,10 30.09.2026 22:40
8252780,10,10 9.10.2026 19:25
67293160,10,10 7.10.2026 20:50
1707480,10,10 30.09.2026 15:32
5801980,10,10 5.10.2026 21:02
4727780,10,10 5.10.2026 10:00
5712380,10,10 5.10.2026 20:19
3025380,10,10 1.10.2026 20:58
2308180,10,10 30.09.2026 22:15
7164980,10,10 8.10.2026 12:37
6063240,10,10 28.09.2026 17:03
2425780,10,10 30.09.2026 22:35
24551160,10,10 30.09.2026 22:38
6531180,10,10 7.10.2026 13:55
5888180,10,10 5.10.2026 21:38
11961160,10,10 30.09.2026 07:00
3295980,10,10 2.10.2026 01:09
3365780,10,10 2.10.2026 02:27
2682780,10,10 30.09.2026 22:56
5627780,10,10 5.10.2026 18:28
34102110,10,10 2.10.2026 16:25
2240380,10,10 30.09.2026 21:37
814080,10,10 29.09.2026 21:26
5460880,10,10 5.10.2026 17:49
6303780,10,10 5.10.2026 23:04
7076880,10,10 8.10.2026 12:20
1062380,10,10 30.09.2026 06:32
1457780,10,10 30.09.2026 11:02
8048980,10,10 9.10.2026 14:29
1772680,10,10 30.09.2026 15:42
11186160,10,10 30.09.2026 06:59
6888980,10,10 7.10.2026 20:51
7256180,10,10 8.10.2026 14:01
2960380,10,10 1.10.2026 20:57
4356480,10,10 5.10.2026 09:01
3108080,10,10 1.10.2026 21:13
7441680,10,10 8.10.2026 16:38
8153280,10,10 9.10.2026 17:45
2618180,10,10 30.09.2026 22:53
1835880,10,10 30.09.2026 15:51
4808080,10,10 5.10.2026 10:03
4896280,10,10 5.10.2026 10:42
4180680,10,10 5.10.2026 00:27
1974680,10,10 30.09.2026 20:42
5373680,10,10 5.10.2026 13:58
2752880,10,10 1.10.2026 19:13
1521580,10,10 30.09.2026 11:08
856880,10,10 29.09.2026 21:50
5542980,10,10 5.10.2026 17:58
61424160,10,10 5.10.2026 22:56
45583160,10,10 5.10.2026 09:49
1397180,10,10 30.09.2026 10:56
2887880,10,10 1.10.2026 19:31
7958780,10,10 9.10.2026 14:27
3504680,10,10 2.10.2026 17:24
5291780,10,10 5.10.2026 13:19
3579280,10,10 2.10.2026 17:32
2176080,10,10 30.09.2026 21:34
7531580,10,10 8.10.2026 17:17
65561040,10,10 29.09.2026 18:42
49856160,10,10 5.10.2026 12:33
15548320,10,10 30.09.2026 11:22
7864480,10,10 9.10.2026 13:15
2819980,10,10 1.10.2026 19:19
5970280,10,10 5.10.2026 21:41
9024800,10,10 30.09.2026 05:42
3924480,10,10 4.10.2026 13:31
7625280,10,10 8.10.2026 18:57
7354180,10,10 8.10.2026 16:34
766080,10,10 29.09.2026 20:13
51390160,10,10 5.10.2026 12:59
31737160,10,10 2.10.2026 00:06
2111080,20,20 30.09.2026 21:32
646960,30,3211 29.09.2026 13:36
602110,30,3191 28.09.2026 16:25
948110,40,4356 30.09.2026 03:30
3068310,40,4121 1.10.2026 21:13
4322213,53,534 5.10.2026 08:59 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 
DELETE w FROM rag.PlanChangeWait AS w WHERE w.CaseID IN (SELECT CaseID FROM #pair)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.