Pahalı sorgular0x79106CCB9EA4D5C5
Demo modu

Sorgu 0x79106CCB9EA4D5C5

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

Ort. süre 0,6 ms
Ort. CPU 0,6 ms
Bekleme payı %0,8
Ort. mantıksal okuma 77
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

23.09.2026: 67 çalışma, ort. 0,3 ms24.09.2026: 98 çalışma, ort. 0,4 ms25.09.2026: 10 çalışma, ort. 0,3 ms27.09.2026: 54 çalışma, ort. 0,9 ms28.09.2026: 162 çalışma, ort. 0,6 ms29.09.2026: 97 çalışma, ort. 1,0 ms max 162 çalışma max ort. süre 1,0 ms 23.09.2026 29.09.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 14:51 tanım değişti DBA.usp_Apply_Qds
  2. 29.09.2026 15:00 yeni plan plan 7066
  3. 29.09.2026 12:00 yeni plan plan 6936
  4. 29.09.2026 11:00 yeni plan plan 6864
  5. 29.09.2026 11:00 yeni plan plan 6923
  6. 29.09.2026 11:00 yeni plan plan 6930
  7. 28.09.2026 21:00 yeni plan plan 6676
  8. 28.09.2026 19:00 yeni plan plan 6521
  9. 28.09.2026 17:00 yeni plan plan 6433
  10. 28.09.2026 17:00 yeni plan plan 6437
  11. 28.09.2026 16:00 yeni plan plan 6182
  12. 28.09.2026 13:00 yeni plan plan 5942
  13. 28.09.2026 13:00 yeni plan plan 5944
  14. 28.09.2026 13:00 yeni plan plan 5948
  15. 28.09.2026 13:00 yeni plan plan 5954
  16. 28.09.2026 12:00 yeni plan plan 4801
  17. 28.09.2026 12:00 yeni plan plan 5035
  18. 28.09.2026 12:00 yeni plan plan 5070
  19. 28.09.2026 12:00 yeni plan plan 5074
  20. 28.09.2026 12:00 yeni plan plan 5077
  21. 28.09.2026 12:00 yeni plan plan 5135
  22. 28.09.2026 12:00 yeni plan plan 5349
  23. 28.09.2026 12:00 yeni plan plan 5365
  24. 28.09.2026 12:00 yeni plan plan 5371
  25. 28.09.2026 12:00 yeni plan plan 5448
  26. 28.09.2026 12:00 yeni plan plan 5721
  27. 28.09.2026 11:00 yeni plan plan 4733
  28. 28.09.2026 11:00 yeni plan plan 4738
  29. 28.09.2026 10:00 yeni plan plan 4445
  30. 28.09.2026 10:00 yeni plan plan 4515
  31. 28.09.2026 09:00 yeni plan plan 3460
  32. 28.09.2026 09:00 yeni plan plan 3696
  33. 28.09.2026 09:00 yeni plan plan 3957
  34. 28.09.2026 09:00 yeni plan plan 4224
  35. 28.09.2026 08:00 yeni plan plan 3216
  36. 27.09.2026 22:00 yeni plan plan 2788
  37. 27.09.2026 22:00 yeni plan plan 2799
  38. 27.09.2026 22:00 yeni plan plan 2818
  39. 27.09.2026 22:00 yeni plan plan 2826
  40. 25.09.2026 02:00 yeni plan plan 2434
  41. 25.09.2026 02:00 yeni plan plan 2628
  42. 24.09.2026 07:00 yeni plan plan 2135
  43. 24.09.2026 06:00 yeni plan plan 1627
  44. 24.09.2026 06:00 yeni plan plan 1786
  45. 24.09.2026 06:00 yeni plan plan 1955
  46. 24.09.2026 06:00 yeni plan plan 2107
  47. 24.09.2026 03:00 yeni plan plan 1536
  48. 24.09.2026 02:00 yeni plan plan 1393
  49. 24.09.2026 01:00 yeni plan plan 1216
  50. 24.09.2026 01:00 yeni plan plan 1329
  51. 23.09.2026 23:00 yeni plan plan 548
  52. 23.09.2026 23:00 yeni plan plan 590
  53. 23.09.2026 23:00 yeni plan plan 610
  54. 23.09.2026 23:00 yeni plan plan 616
  55. 23.09.2026 23:00 yeni plan plan 673
  56. 23.09.2026 23:00 yeni plan plan 751
  57. 23.09.2026 23:00 yeni plan plan 848
  58. 23.09.2026 23:00 yeni plan plan 943
  59. 23.09.2026 23:00 yeni plan plan 1020
  60. 23.09.2026 22:00 yeni plan plan 180
  61. 23.09.2026 22:00 yeni plan plan 213
  62. 23.09.2026 22:00 yeni plan plan 226
  63. 23.09.2026 22:00 yeni plan plan 421
  64. 23.09.2026 22:00 yeni plan plan 493

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-23670,30,3 0,436
2026-09-24980,40,4 0,735
2026-09-25100,30,3 0,316
2026-09-27540,90,9 8,1277
2026-09-281620,60,6 2,350
2026-09-29970,91,0 3,087

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
153680,20,254 24.09.2026 06:10 en iyi
21340,20,241 23.09.2026 22:45
75170,20,275 23.09.2026 23:11
59010,20,23 23.09.2026 23:03
480150,30,316 28.09.2026 12:00
346050,30,316 28.09.2026 09:33
369650,30,316 28.09.2026 09:50
213540,30,338 24.09.2026 08:10
61010,30,318 23.09.2026 23:05
395750,30,316 28.09.2026 09:53
42150,30,320 23.09.2026 22:49
513550,30,316 28.09.2026 12:10
243450,30,316 25.09.2026 02:44
178650,30,332 24.09.2026 06:33
61650,30,321 23.09.2026 23:05
180100,30,319 23.09.2026 22:39
162750,30,332 24.09.2026 06:32
49340,30,3144 23.09.2026 22:51
67350,30,321 23.09.2026 23:08
422450,30,316 28.09.2026 09:59
1393100,30,320 24.09.2026 02:10
2107350,30,320 24.09.2026 08:28
54850,30,321 23.09.2026 23:01
544850,30,316 28.09.2026 12:16
503550,30,316 28.09.2026 12:01
451550,30,316 28.09.2026 10:35
6521300,30,319 29.09.2026 11:49
6182100,40,420 28.09.2026 17:03
132970,40,4106 24.09.2026 02:10
2628600,40,418 28.09.2026 01:05
22650,40,419 23.09.2026 22:45
102090,40,470 24.09.2026 01:10
6923100,40,426 29.09.2026 13:08
537150,40,316 28.09.2026 12:12
572150,40,416 28.09.2026 12:43
321650,40,416 28.09.2026 08:44
943150,40,419 24.09.2026 01:11
706650,40,416 29.09.2026 15:14
121650,50,519 24.09.2026 01:13
84850,50,519 23.09.2026 23:16
6930190,50,5103 29.09.2026 15:10
6433450,50,5118 29.09.2026 11:10
507020,60,6100 28.09.2026 12:10
536510,70,617 28.09.2026 12:12
594210,70,735 28.09.2026 13:10
195550,80,832 24.09.2026 06:43
594410,90,971 28.09.2026 13:10
473321,11,140 28.09.2026 11:10
5954131,11,136 28.09.2026 16:10
6437211,21,234 29.09.2026 09:10
444541,41,4188 28.09.2026 10:10
693621,71,6248 29.09.2026 15:10
686412,02,0278 29.09.2026 11:10
534922,12,0330 28.09.2026 12:12
507412,12,1275 28.09.2026 12:10
507712,32,3330 28.09.2026 12:10
594812,32,3282 28.09.2026 13:10
473822,52,5270 28.09.2026 11:10
278832,72,71.651 27.09.2026 22:54
6676152,72,7124 29.09.2026 08:10
282642,92,9775 27.09.2026 22:54
281817,47,42.659 27.09.2026 22:54
279918,28,23.372 27.09.2026 22:54 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 
(@ServerID int,@DatabaseName nvarchar(128),@now datetime)INSERT perf.QdsPlan (ServerID, DatabaseName, plan_id, query_id, query_plan_hash, PlanHash, is_forced_plan, compatibility_level, LastCompileUtc, LastExecutionUtc, LastSeenUtc)
        SELECT g.ServerID, g.DatabaseName, g.plan_id, g.query_id, g.query_plan_hash, x.PlanHash, g.is_forced_plan, g.compatibility_level,
               g.LastCompileUtc, g.LastExecutionUtc, @now
        FROM perf.Stg_QdsPlan AS g
        LEFT JOIN #px AS x ON x.plan_id = g.plan_id
        WHERE g.ServerID = @ServerID AND g.DatabaseName = @DatabaseName
          AND NOT EXISTS (SELECT 1 FROM perf.QdsPlan AS p WHERE p.ServerID = g.ServerID AND p.DatabaseName = g.DatabaseName AND p.plan_id = g.plan_id)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.