Pahalı sorgular0xE62FB66BC7A4A60D
Demo modu

Sorgu 0xE62FB66BC7A4A60D

SQL-1 · DB-12· DBA.usp_Apply_Qds · dönem 2026-09-12 → 2026-10-11 · 1.022 çalışma · Pahalı sorgulara dön

Ort. süre 6,9 ms
Ort. CPU 5,9 ms
Bekleme payı %15,2
Ort. mantıksal okuma 1.597
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

29.09.2026: 71 çalışma, ort. 0,6 ms30.09.2026: 113 çalışma, ort. 0,7 ms1.10.2026: 42 çalışma, ort. 11,4 ms2.10.2026: 105 çalışma, ort. 9,1 ms3.10.2026: 91 çalışma, ort. 4,2 ms4.10.2026: 110 çalışma, ort. 12,6 ms5.10.2026: 168 çalışma, ort. 8,1 ms6.10.2026: 168 çalışma, ort. 6,4 ms7.10.2026: 119 çalışma, ort. 8,3 ms9.10.2026: 35 çalışma, ort. 9,3 ms max 168 çalışma max ort. süre 12,6 ms 29.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. 11.10.2026 23:00 yeni plan plan 9094
  2. 11.10.2026 23:00 yeni plan plan 9112
  3. 11.10.2026 23:00 yeni plan plan 9118
  4. 9.10.2026 19:00 yeni plan plan 8977
  5. 9.10.2026 19:00 yeni plan plan 8984
  6. 9.10.2026 19:00 yeni plan plan 8987
  7. 9.10.2026 17:00 yeni plan plan 8940
  8. 9.10.2026 16:00 yeni plan plan 8911
  9. 9.10.2026 15:00 yeni plan plan 8894
  10. 9.10.2026 14:51 tanım değişti DBA.usp_Apply_Qds
  11. 9.10.2026 14:00 yeni plan plan 8819
  12. 9.10.2026 14:00 yeni plan plan 8848
  13. 9.10.2026 14:00 yeni plan plan 8854
  14. 7.10.2026 20:00 yeni plan plan 8659
  15. 7.10.2026 20:00 yeni plan plan 8661
  16. 6.10.2026 15:00 yeni plan plan 8638
  17. 6.10.2026 06:00 yeni plan plan 8627
  18. 6.10.2026 05:00 yeni plan plan 8626
  19. 5.10.2026 16:00 yeni plan plan 8523
  20. 5.10.2026 15:00 yeni plan plan 8513
  21. 5.10.2026 15:00 yeni plan plan 8515
  22. 5.10.2026 14:00 yeni plan plan 8510
  23. 5.10.2026 12:00 yeni plan plan 8485
  24. 5.10.2026 12:00 yeni plan plan 8487
  25. 5.10.2026 11:00 yeni plan plan 8466
  26. 5.10.2026 11:00 yeni plan plan 8470
  27. 5.10.2026 11:00 yeni plan plan 8477
  28. 5.10.2026 10:00 yeni plan plan 8363
  29. 5.10.2026 09:00 yeni plan plan 8350
  30. 5.10.2026 09:00 yeni plan plan 8354
  31. 5.10.2026 08:00 yeni plan plan 8277
  32. 5.10.2026 08:00 yeni plan plan 8281
  33. 5.10.2026 08:00 yeni plan plan 8283
  34. 5.10.2026 05:00 yeni plan plan 8215
  35. 5.10.2026 05:00 yeni plan plan 8217
  36. 5.10.2026 04:00 yeni plan plan 8210
  37. 5.10.2026 04:00 yeni plan plan 8212
  38. 5.10.2026 03:00 yeni plan plan 8158
  39. 5.10.2026 03:00 yeni plan plan 8163
  40. 5.10.2026 03:00 yeni plan plan 8166
  41. 4.10.2026 12:00 yeni plan plan 8078
  42. 4.10.2026 10:00 yeni plan plan 8071
  43. 4.10.2026 10:00 yeni plan plan 8073
  44. 3.10.2026 04:00 yeni plan plan 8016
  45. 3.10.2026 02:00 yeni plan plan 7940
  46. 2.10.2026 19:00 yeni plan plan 7934
  47. 2.10.2026 14:00 yeni plan plan 7903
  48. 2.10.2026 14:00 yeni plan plan 7905
  49. 2.10.2026 12:00 yeni plan plan 7891
  50. 2.10.2026 12:00 yeni plan plan 7896
  51. 2.10.2026 12:00 yeni plan plan 7898
  52. 2.10.2026 01:00 yeni plan plan 7873
  53. 2.10.2026 00:00 yeni plan plan 7866
  54. 2.10.2026 00:00 yeni plan plan 7869
  55. 1.10.2026 23:00 yeni plan plan 7858
  56. 1.10.2026 22:00 yeni plan plan 7816
  57. 1.10.2026 22:00 yeni plan plan 7821
  58. 1.10.2026 22:00 yeni plan plan 7826
  59. 1.10.2026 20:00 yeni plan plan 7715
  60. 1.10.2026 20:00 yeni plan plan 7722
  61. 1.10.2026 19:00 yeni plan plan 7680
  62. 1.10.2026 19:00 yeni plan plan 7689
  63. 1.10.2026 19:00 yeni plan plan 7695
  64. 1.10.2026 19:00 yeni plan plan 7698
  65. 30.09.2026 09:00 yeni plan plan 7495
  66. 30.09.2026 07:00 yeni plan plan 7477
  67. 30.09.2026 06:00 yeni plan plan 7406
  68. 30.09.2026 04:00 yeni plan plan 7366
  69. 29.09.2026 16:00 yeni plan plan 7212
  70. 29.09.2026 16:00 yeni plan plan 7219
  71. 29.09.2026 15:00 yeni plan plan 7179

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-29710,60,6 2,3133
2026-09-301130,70,7 1,6193
2026-10-01429,811,4 75,11.628
2026-10-021057,69,1 44,21.596
2026-10-03914,24,2 10,01.058
2026-10-041107,912,6 62,62.164
2026-10-051687,68,1 54,32.340
2026-10-061686,16,4 55,91.734
2026-10-071196,88,3 66,12.009
2026-10-09358,89,3 63,33.047

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
7179350,30,35 29.09.2026 18:42 en iyi
736670,50,5122 30.09.2026 05:10
7477510,60,6210 30.09.2026 22:10
7406370,70,6163 30.09.2026 20:10
7212500,80,8193 30.09.2026 04:10
768011,21,22 1.10.2026 19:06
898751,81,8260 9.10.2026 19:11
889452,02,0391 9.10.2026 15:11
721932,12,1886 29.09.2026 18:10
8854202,32,3541 9.10.2026 18:11
816652,52,5537 5.10.2026 03:12
768912,52,5200 1.10.2026 19:07
821272,62,6613 5.10.2026 07:10
8283152,82,8564 5.10.2026 10:14
84772472,82,8602 8.10.2026 21:12
7826162,82,8500 2.10.2026 02:10
749512,82,51.151 30.09.2026 09:10
8217123,03,0654 5.10.2026 07:10
8627123,03,0759 8.10.2026 21:12
786913,03,0448 2.10.2026 00:10
7695143,03,0669 1.10.2026 21:10
8626843,13,0529 7.10.2026 13:10
769893,23,2222 1.10.2026 19:10
7898943,23,0433 5.10.2026 02:10
807313,83,8926 4.10.2026 10:11
852393,93,0707 6.10.2026 14:10
9118124,04,0720 11.10.2026 23:10
8078194,23,7490 4.10.2026 23:10
7905924,64,6741 4.10.2026 08:10
866134,84,8352 7.10.2026 20:39
865965,93,2866 7.10.2026 20:10
863816,16,13.054 6.10.2026 15:10
821516,26,22.111 5.10.2026 05:10
794016,26,21.343 3.10.2026 02:10
787317,17,12.130 2.10.2026 01:10
790337,17,12.482 5.10.2026 01:10
851357,57,42.284 6.10.2026 08:10
821018,08,01.350 5.10.2026 04:10
891128,28,12.200 9.10.2026 17:12
909419,19,11.441 11.10.2026 23:06
827719,19,14.651 5.10.2026 08:10
7858119,25,4792 2.10.2026 00:10
8485479,69,32.931 8.10.2026 21:10
801619,99,91.974 3.10.2026 04:10
8977110,910,94.731 9.10.2026 19:10
8163611,110,13.088 5.10.2026 04:10
78914111,811,14.116 5.10.2026 02:10
8363112,211,84.277 5.10.2026 10:10
7866112,511,73.378 2.10.2026 00:10
8819312,512,41.842 9.10.2026 16:10
8158312,610,73.318 5.10.2026 06:10
8940212,912,93.792 9.10.2026 18:10
84701514,113,33.302 7.10.2026 09:10
8350114,414,41.790 5.10.2026 09:10
7934821,912,04.091 5.10.2026 00:10
7816225,718,61.738 1.10.2026 23:10
8466226,925,81.914 6.10.2026 04:10
78964327,114,43.406 5.10.2026 02:10
8354127,424,79.978 5.10.2026 09:14
8071329,726,69.496 4.10.2026 22:12
8487131,729,28.937 5.10.2026 12:11
8281232,329,111.179 5.10.2026 10:14
8984134,132,011.881 9.10.2026 19:11
7821338,434,012.124 2.10.2026 02:10
8515440,037,513.674 8.10.2026 21:12
85104746,236,213.581 8.10.2026 20:05
7722255,351,413.413 1.10.2026 21:10
8848362,958,125.451 9.10.2026 18:11
9112172,066,025.323 11.10.2026 23:07
7715187,387,33.868 1.10.2026 20:10 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:1135,Preemptive:185,Buffer IO:163
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 
(@ServerID int,@DatabaseName nvarchar(128),@now datetime)UPDATE p SET p.query_id = g.query_id, p.query_plan_hash = g.query_plan_hash, p.is_forced_plan = g.is_forced_plan,
                     p.compatibility_level = g.compatibility_level, p.LastCompileUtc = g.LastCompileUtc,
                     p.LastExecutionUtc = g.LastExecutionUtc, p.LastSeenUtc = @now, p.PlanHash = COALESCE(x.PlanHash, p.PlanHash),
                     p.force_failure_count = g.force_failure_count, p.last_force_failure_reason_desc = g.last_force_failure_reason_desc
        FROM perf.QdsPlan AS p
        JOIN perf.Stg_QdsPlan AS g ON g.ServerID = p.ServerID AND g.DatabaseName = p.DatabaseName AND g.plan_id = p.plan_id
        LEFT JOIN #px AS x ON x.plan_id = g.plan_id
        WHERE g.ServerID = @ServerID AND g.DatabaseName = @DatabaseName

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.