Pahalı sorgular0xD2DAF311C3C82885
Demo modu

Sorgu 0xD2DAF311C3C82885

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,6 ms
Ort. CPU 6,1 ms
Bekleme payı %8,2
Ort. mantıksal okuma 1.430
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,5 ms1.10.2026: 42 çalışma, ort. 33,1 ms2.10.2026: 105 çalışma, ort. 5,9 ms3.10.2026: 91 çalışma, ort. 2,7 ms4.10.2026: 110 çalışma, ort. 6,3 ms5.10.2026: 168 çalışma, ort. 8,0 ms6.10.2026: 168 çalışma, ort. 4,5 ms7.10.2026: 119 çalışma, ort. 11,8 ms9.10.2026: 35 çalışma, ort. 6,5 ms max 168 çalışma max ort. süre 33,1 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 9095
  2. 11.10.2026 23:00 yeni plan plan 9113
  3. 11.10.2026 23:00 yeni plan plan 9119
  4. 11.10.2026 23:00 yeni plan plan 9124
  5. 9.10.2026 19:00 yeni plan plan 8978
  6. 9.10.2026 19:00 yeni plan plan 8985
  7. 9.10.2026 19:00 yeni plan plan 8988
  8. 9.10.2026 16:00 yeni plan plan 8912
  9. 9.10.2026 15:00 yeni plan plan 8893
  10. 9.10.2026 15:00 yeni plan plan 8895
  11. 9.10.2026 14:51 tanım değişti DBA.usp_Apply_Qds
  12. 9.10.2026 14:00 yeni plan plan 8820
  13. 9.10.2026 14:00 yeni plan plan 8855
  14. 9.10.2026 14:00 yeni plan plan 8858
  15. 6.10.2026 22:00 yeni plan plan 8645
  16. 6.10.2026 18:00 yeni plan plan 8643
  17. 6.10.2026 14:00 yeni plan plan 8637
  18. 6.10.2026 13:00 yeni plan plan 8634
  19. 6.10.2026 12:00 yeni plan plan 8633
  20. 6.10.2026 06:00 yeni plan plan 8628
  21. 6.10.2026 03:00 yeni plan plan 8566
  22. 6.10.2026 03:00 yeni plan plan 8568
  23. 6.10.2026 03:00 yeni plan plan 8569
  24. 6.10.2026 00:00 yeni plan plan 8541
  25. 5.10.2026 22:00 yeni plan plan 8538
  26. 5.10.2026 20:00 yeni plan plan 8531
  27. 5.10.2026 19:00 yeni plan plan 8527
  28. 5.10.2026 16:00 yeni plan plan 8524
  29. 5.10.2026 14:00 yeni plan plan 8506
  30. 5.10.2026 14:00 yeni plan plan 8511
  31. 5.10.2026 12:00 yeni plan plan 8488
  32. 5.10.2026 11:00 yeni plan plan 8467
  33. 5.10.2026 11:00 yeni plan plan 8478
  34. 5.10.2026 09:00 yeni plan plan 8351
  35. 5.10.2026 08:00 yeni plan plan 8278
  36. 5.10.2026 08:00 yeni plan plan 8282
  37. 5.10.2026 08:00 yeni plan plan 8284
  38. 5.10.2026 06:00 yeni plan plan 8218
  39. 5.10.2026 05:00 yeni plan plan 8216
  40. 5.10.2026 04:00 yeni plan plan 8211
  41. 5.10.2026 04:00 yeni plan plan 8213
  42. 5.10.2026 03:00 yeni plan plan 8159
  43. 5.10.2026 03:00 yeni plan plan 8167
  44. 5.10.2026 00:00 yeni plan plan 8114
  45. 4.10.2026 09:00 yeni plan plan 8064
  46. 3.10.2026 10:00 yeni plan plan 8024
  47. 3.10.2026 05:00 yeni plan plan 8018
  48. 3.10.2026 05:00 yeni plan plan 8019
  49. 3.10.2026 03:00 yeni plan plan 7972
  50. 2.10.2026 21:00 yeni plan plan 7937
  51. 2.10.2026 15:00 yeni plan plan 7917
  52. 2.10.2026 14:00 yeni plan plan 7906
  53. 2.10.2026 13:00 yeni plan plan 7902
  54. 2.10.2026 12:00 yeni plan plan 7892
  55. 2.10.2026 12:00 yeni plan plan 7899
  56. 2.10.2026 00:00 yeni plan plan 7867
  57. 2.10.2026 00:00 yeni plan plan 7870
  58. 1.10.2026 23:00 yeni plan plan 7859
  59. 1.10.2026 22:00 yeni plan plan 7817
  60. 1.10.2026 22:00 yeni plan plan 7822
  61. 1.10.2026 22:00 yeni plan plan 7827
  62. 1.10.2026 20:00 yeni plan plan 7716
  63. 1.10.2026 20:00 yeni plan plan 7723
  64. 1.10.2026 19:00 yeni plan plan 7681
  65. 1.10.2026 19:00 yeni plan plan 7690
  66. 1.10.2026 19:00 yeni plan plan 7696
  67. 1.10.2026 19:00 yeni plan plan 7699
  68. 30.09.2026 09:00 yeni plan plan 7496
  69. 30.09.2026 07:00 yeni plan plan 7478
  70. 30.09.2026 06:00 yeni plan plan 7407
  71. 29.09.2026 22:00 yeni plan plan 7336
  72. 29.09.2026 20:00 yeni plan plan 7325
  73. 29.09.2026 16:00 yeni plan plan 7213
  74. 29.09.2026 16:00 yeni plan plan 7220
  75. 29.09.2026 15:00 yeni plan plan 7180

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-29710,60,6 1,743
2026-09-301130,50,5 1,463
2026-10-014231,633,1 412,712.112
2026-10-021055,55,9 53,21.248
2026-10-03912,72,7 4,5317
2026-10-041105,96,3 27,51.148
2026-10-051687,88,0 87,02.245
2026-10-061684,24,5 23,0608
2026-10-071199,311,8 58,11.041
2026-10-09356,26,5 44,41.519

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
7407760,30,372 30.09.2026 22:10 en iyi
7180350,40,416 29.09.2026 18:42
7213350,50,482 30.09.2026 04:10
732581,01,054 29.09.2026 21:10
749611,01,030 30.09.2026 09:10
7478121,11,131 30.09.2026 19:10
7336141,31,328 30.09.2026 05:10
898851,51,5140 9.10.2026 19:11
722031,51,533 29.09.2026 18:10
889551,61,6210 9.10.2026 15:11
8855181,81,8220 9.10.2026 18:11
8167172,02,0259 5.10.2026 07:10
862852,01,9229 6.10.2026 06:10
8284152,12,1260 5.10.2026 10:14
821672,22,2375 5.10.2026 07:10
7906912,32,3292 4.10.2026 23:10
7899722,42,3235 5.10.2026 01:11
786752,42,3289 2.10.2026 00:10
84782202,52,2269 8.10.2026 21:12
7827172,52,3252 2.10.2026 02:10
8524942,52,1333 8.10.2026 21:12
7696142,52,5305 1.10.2026 21:10
864352,62,6428 6.10.2026 18:10
821312,72,7123 5.10.2026 04:10
787013,23,2123 2.10.2026 00:10
9119113,33,1291 11.10.2026 23:10
821153,63,6413 5.10.2026 04:10
885823,62,8154 9.10.2026 14:55
852733,93,8302 7.10.2026 09:10
785963,93,3313 1.10.2026 23:10
891224,04,01.264 9.10.2026 17:12
863314,14,1281 6.10.2026 12:10
863774,24,1166 7.10.2026 10:10
7972254,33,8120 5.10.2026 02:10
8024154,54,2125 4.10.2026 19:10
8541124,53,8292 7.10.2026 20:10
827814,74,7863 5.10.2026 08:10
8569204,74,3140 8.10.2026 14:13
912414,84,8126 11.10.2026 23:07
7917104,94,8406 4.10.2026 21:10
8064105,04,8386 4.10.2026 23:10
7937155,33,9367 4.10.2026 17:10
897815,55,3810 9.10.2026 19:10
7902245,85,4507 5.10.2026 02:10
821825,95,9682 5.10.2026 06:10
8531176,56,0618 8.10.2026 10:12
811446,86,7327 5.10.2026 00:10
863496,86,5480 7.10.2026 16:10
8019167,06,5403 5.10.2026 02:10
8488137,67,3808 8.10.2026 20:03
8506147,96,2570 8.10.2026 19:10
856898,98,21.015 8.10.2026 11:10
801829,19,19.143 4.10.2026 10:11
856669,28,71.057 8.10.2026 12:11
828219,59,51.268 5.10.2026 08:10
9095113,510,41.491 11.10.2026 23:06
7699915,08,3171 1.10.2026 19:10
8985115,114,72.397 9.10.2026 19:11
8159315,715,65.391 5.10.2026 04:10
8893320,019,45.628 9.10.2026 18:10
7817521,921,37.757 2.10.2026 02:10
8820522,121,35.687 9.10.2026 18:11
78922223,622,77.622 5.10.2026 01:11
7716228,828,812.844 1.10.2026 21:10
8351436,436,417.135 5.10.2026 10:14
7822144,643,714.885 1.10.2026 22:10
85112746,544,812.538 8.10.2026 21:12
86451648,134,31.052 7.10.2026 11:10
8467451,651,624.775 5.10.2026 13:13
9113160,952,811.728 11.10.2026 23:07
8538196,787,834.947 5.10.2026 22:12
76811158,8158,878.029 1.10.2026 19:06
77231322,4322,435.404 1.10.2026 20:11
76901580,3580,3342.351 1.10.2026 19:07 en kötü

Davranış

Wait kategorileri (QDS)
CPU:303,Buffer IO:180,Preemptive:63
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,
                             force_failure_count, last_force_failure_reason_desc)
        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, g.force_failure_count, g.last_force_failure_reason_desc
        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.