Pahalı sorgular0xE3BCC53DE5B2EAF6
Demo modu

Sorgu 0xE3BCC53DE5B2EAF6

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,2 ms
Ort. CPU 0,2 ms
Bekleme payı %0,9
Ort. mantıksal okuma 74
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,2 ms29.09.2026: 107 çalışma, ort. 0,2 ms30.09.2026: 313 çalışma, ort. 0,1 ms1.10.2026: 49 çalışma, ort. 0,2 ms2.10.2026: 59 çalışma, ort. 0,2 ms4.10.2026: 8 çalışma, ort. 0,1 ms5.10.2026: 193 çalışma, ort. 0,2 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,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 82526
  2. 9.10.2026 17:00 yeni plan plan 81531
  3. 9.10.2026 14:00 yeni plan plan 80488
  4. 9.10.2026 14:00 yeni plan plan 79586
  5. 9.10.2026 13:00 yeni plan plan 78643
  6. 8.10.2026 18:00 yeni plan plan 76251
  7. 8.10.2026 17:00 yeni plan plan 75314
  8. 8.10.2026 16:00 yeni plan plan 74415
  9. 8.10.2026 16:00 yeni plan plan 73540
  10. 8.10.2026 14:00 yeni plan plan 72560
  11. 8.10.2026 12:00 yeni plan plan 71648
  12. 8.10.2026 12:00 yeni plan plan 70767
  13. 7.10.2026 20:00 yeni plan plan 68888
  14. 7.10.2026 20:00 yeni plan plan 67292
  15. 7.10.2026 13:00 yeni plan plan 65310
  16. 5.10.2026 23:00 yeni plan plan 63036
  17. 5.10.2026 22:00 yeni plan plan 61423
  18. 5.10.2026 22:00 yeni plan plan 60538
  19. 5.10.2026 21:00 yeni plan plan 58018
  20. 5.10.2026 21:00 yeni plan plan 58880
  21. 5.10.2026 21:00 yeni plan plan 59701
  22. 5.10.2026 20:00 yeni plan plan 57122
  23. 5.10.2026 18:00 yeni plan plan 56276
  24. 5.10.2026 17:00 yeni plan plan 55428
  25. 5.10.2026 17:00 yeni plan plan 54607
  26. 5.10.2026 13:00 yeni plan plan 53735
  27. 5.10.2026 13:00 yeni plan plan 52916
  28. 5.10.2026 12:00 yeni plan plan 51389
  29. 5.10.2026 12:00 yeni plan plan 49855
  30. 5.10.2026 10:00 tanım değişti rag.usp_PlanChange_Detect
  31. 5.10.2026 10:00 yeni plan plan 48961
  32. 5.10.2026 10:00 yeni plan plan 48079
  33. 5.10.2026 10:00 yeni plan plan 47276
  34. 5.10.2026 09:00 yeni plan plan 45582
  35. 5.10.2026 09:00 yeni plan plan 43563
  36. 5.10.2026 08:00 yeni plan plan 43221
  37. 5.10.2026 00:00 yeni plan plan 41805
  38. 4.10.2026 13:00 yeni plan plan 39243
  39. 2.10.2026 17:00 yeni plan plan 35791
  40. 2.10.2026 17:00 yeni plan plan 35045
  41. 2.10.2026 16:00 yeni plan plan 34101
  42. 2.10.2026 02:00 yeni plan plan 33656
  43. 2.10.2026 01:00 yeni plan plan 32958
  44. 2.10.2026 00:00 yeni plan plan 31736
  45. 1.10.2026 21:00 yeni plan plan 31079
  46. 1.10.2026 21:00 yeni plan plan 30682
  47. 1.10.2026 20:00 yeni plan plan 30252
  48. 1.10.2026 20:00 yeni plan plan 29602
  49. 1.10.2026 19:00 yeni plan plan 28877
  50. 1.10.2026 19:00 yeni plan plan 28198
  51. 1.10.2026 19:00 yeni plan plan 27527
  52. 30.09.2026 22:00 yeni plan plan 26826
  53. 30.09.2026 22:00 yeni plan plan 26180
  54. 30.09.2026 22:00 yeni plan plan 25500
  55. 30.09.2026 22:00 yeni plan plan 24550
  56. 30.09.2026 22:00 yeni plan plan 24256
  57. 30.09.2026 22:00 yeni plan plan 23080
  58. 30.09.2026 21:00 yeni plan plan 22402
  59. 30.09.2026 21:00 yeni plan plan 21759
  60. 30.09.2026 21:00 yeni plan plan 21109
  61. 30.09.2026 20:00 yeni plan plan 19745
  62. 30.09.2026 15:00 yeni plan plan 17073
  63. 30.09.2026 15:00 yeni plan plan 17725
  64. 30.09.2026 15:00 yeni plan plan 18357
  65. 30.09.2026 11:00 yeni plan plan 15547
  66. 30.09.2026 11:00 yeni plan plan 15214
  67. 30.09.2026 11:00 yeni plan plan 14576
  68. 30.09.2026 10:00 yeni plan plan 13970
  69. 30.09.2026 10:00 yeni plan plan 12874
  70. 30.09.2026 06:00 yeni plan plan 11960
  71. 30.09.2026 06:00 yeni plan plan 11185
  72. 30.09.2026 06:00 yeni plan plan 10622
  73. 30.09.2026 05:00 yeni plan plan 10059
  74. 30.09.2026 03:00 yeni plan plan 9480
  75. 30.09.2026 00:00 yeni plan plan 9023
  76. 29.09.2026 21:00 yeni plan plan 8567
  77. 29.09.2026 21:00 yeni plan plan 8139
  78. 29.09.2026 20:00 yeni plan plan 7659
  79. 28.09.2026 22:00 yeni plan plan 6683
  80. 28.09.2026 19:00 yeni plan plan 6555
  81. 28.09.2026 19:00 yeni plan plan 6468
  82. 28.09.2026 16:00 yeni plan plan 6062
  83. 28.09.2026 16:00 yeni plan plan 6020

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-28520,20,2 1,870
2026-09-291070,20,2 0,972
2026-09-303130,10,1 0,273
2026-10-01490,20,2 1,574
2026-10-02590,20,2 0,279
2026-10-0480,10,1 0,173
2026-10-051930,20,2 0,275
2026-10-07400,10,1 0,173
2026-10-09320,10,1 0,173

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
8252680,10,173 9.10.2026 19:25 en iyi
1707380,10,173 30.09.2026 15:32
3365680,10,173 2.10.2026 02:27
2425680,10,173 30.09.2026 22:35
2550080,10,173 30.09.2026 22:40
6053880,10,173 5.10.2026 22:04
4727680,10,173 5.10.2026 10:00
5712280,10,173 5.10.2026 20:19
1062280,10,173 30.09.2026 06:32
2308080,10,173 30.09.2026 22:15
6531080,10,173 7.10.2026 13:55
5627680,10,173 5.10.2026 18:28
11185160,10,173 30.09.2026 06:59
11960160,10,173 30.09.2026 07:00
1397080,10,173 30.09.2026 10:56
2960280,10,173 1.10.2026 20:57
6062240,10,173 28.09.2026 17:03
856780,10,173 29.09.2026 21:50
8048880,10,173 9.10.2026 14:29
1005980,10,173 30.09.2026 05:49
2682680,10,173 30.09.2026 22:56
1772580,10,173 30.09.2026 15:42
3579180,10,173 2.10.2026 17:32
4807980,10,173 5.10.2026 10:03
7164880,10,173 8.10.2026 12:37
1521480,10,173 30.09.2026 11:08
5291680,10,173 5.10.2026 13:19
1974580,10,173 30.09.2026 20:42
5888080,10,173 5.10.2026 21:38
2887780,10,173 1.10.2026 19:31
6303680,10,173 5.10.2026 23:04
765980,10,173 29.09.2026 20:13
5460780,10,173 5.10.2026 17:49
45582160,10,173 5.10.2026 09:49
3107980,10,173 1.10.2026 21:13
7958680,10,173 9.10.2026 14:27
7441580,10,173 8.10.2026 16:38
67292160,10,173 7.10.2026 20:50
8153180,10,173 9.10.2026 17:45
813980,10,173 29.09.2026 21:26
2240280,10,173 30.09.2026 21:37
6888880,10,173 7.10.2026 20:51
3504580,10,173 2.10.2026 17:24
4356380,10,173 5.10.2026 09:01
5801880,10,173 5.10.2026 21:02
7256080,10,173 8.10.2026 14:01
4896180,10,173 5.10.2026 10:42
2819880,10,173 1.10.2026 19:19
15547320,10,173 30.09.2026 11:22
5970180,10,173 5.10.2026 21:41
7625180,10,173 8.10.2026 18:57
1835780,10,173 30.09.2026 15:51
12874160,10,173 30.09.2026 10:52
7864380,10,173 9.10.2026 13:15
2752780,10,173 1.10.2026 19:13
24550160,10,173 30.09.2026 22:38
4180580,10,173 5.10.2026 00:27
3924380,10,173 4.10.2026 13:31
61423160,10,173 5.10.2026 22:57
5542880,10,173 5.10.2026 17:58
65551040,20,273 29.09.2026 18:42
2618080,20,273 30.09.2026 22:53
1457680,20,273 30.09.2026 11:02
51389160,20,273 5.10.2026 12:59
49855160,20,273 5.10.2026 12:33
3295880,20,273 2.10.2026 01:09
5373580,20,273 5.10.2026 13:58
9023800,20,273 30.09.2026 05:42
2110980,20,273 30.09.2026 21:32
7354080,20,273 8.10.2026 16:34
7531480,20,173 8.10.2026 17:17
3025280,20,273 1.10.2026 20:58
34101110,20,2107 2.10.2026 16:25
2175980,20,273 30.09.2026 21:34
7076780,20,273 8.10.2026 12:20
31736160,30,373 2.10.2026 00:06
948010,40,422 30.09.2026 03:30
668350,90,827 29.09.2026 13:36
646811,61,626 28.09.2026 19:21
602012,02,028 28.09.2026 16:25
3068212,11,3134 1.10.2026 21:13
43221118,218,2315 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 s FROM rag.PlanChangeSeries AS s WHERE s.CaseID IN (SELECT CaseID FROM #pair)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.