Pahalı sorgular0x1B1A7E9675535237
Demo modu

Sorgu 0x1B1A7E9675535237

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

Ort. süre 80,9 ms▲ %40,3
Ort. CPU 62,9 ms▲ %51,1
Bekleme payı %22,2▼ %20,1
Ort. mantıksal okuma 2.281▲ %65,7
En büyük bellek izni 2 MB

Değişim: önceki dönem 2026-09-29 → 2026-10-05 ile karşılaştırma (çalışma ağırlıklı ortalama).

Takip

Yeni

Bu sorgu henüz analiz edilmedi.

Bilinen sorgu, ertele:

Günlük trend

6.10.2026: 168 çalışma, ort. 18,7 ms7.10.2026: 119 çalışma, ort. 43,6 ms9.10.2026: 35 çalışma, ort. 506,1 ms max 168 çalışma max ort. süre 506,1 ms 6.10.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. 12.10.2026 00:00 yeni plan plan 9174
  2. 11.10.2026 23:00 yeni plan plan 9117
  3. 11.10.2026 23:00 yeni plan plan 9092
  4. 9.10.2026 19:00 yeni plan plan 8983
  5. 9.10.2026 19:00 yeni plan plan 8976
  6. 9.10.2026 14:51 tanım değişti DBA.usp_Apply_Qds
  7. 9.10.2026 14:00 yeni plan plan 8853
  8. 9.10.2026 14:00 yeni plan plan 8818
  9. 5.10.2026 11:00 plan değişimi P458 8465→8476
  10. 5.10.2026 11:00 yeni plan plan 8476
  11. 5.10.2026 11:00 yeni plan plan 8465
  12. 5.10.2026 10:00 yeni plan plan 8366
  13. 5.10.2026 08:00 yeni plan plan 8276
  14. 5.10.2026 03:00 yeni plan plan 8162
  15. 5.10.2026 03:00 yeni plan plan 8157
  16. 2.10.2026 12:00 plan değişimi P457 7890→7895
  17. 2.10.2026 12:00 yeni plan plan 7895
  18. 2.10.2026 12:00 yeni plan plan 7890
  19. 1.10.2026 22:00 yeni plan plan 7815
  20. 1.10.2026 22:00 yeni plan plan 7825
  21. 1.10.2026 20:00 yeni plan plan 7714
  22. 1.10.2026 19:00 yeni plan plan 7694
  23. 1.10.2026 19:00 yeni plan plan 7688
  24. 1.10.2026 19:00 yeni plan plan 7679
  25. 30.09.2026 06:00 yeni plan plan 7405
  26. 29.09.2026 16:00 yeni plan plan 7211
  27. 29.09.2026 15:00 yeni plan plan 7064
  28. 29.09.2026 15:00 yeni plan plan 7178
  29. 29.09.2026 11:00 yeni plan plan 6862
  30. 29.09.2026 11:00 yeni plan plan 6928
  31. 29.09.2026 11:00 yeni plan plan 6921
  32. 28.09.2026 19:00 yeni plan plan 6519
  33. 28.09.2026 17:00 yeni plan plan 6431
  34. 28.09.2026 16:00 yeni plan plan 6180
  35. 28.09.2026 13:00 yeni plan plan 5940
  36. 28.09.2026 12:00 yeni plan plan 5133
  37. 28.09.2026 12:00 yeni plan plan 5033
  38. 28.09.2026 12:00 yeni plan plan 5363
  39. 28.09.2026 12:00 yeni plan plan 5369
  40. 28.09.2026 12:00 yeni plan plan 5719
  41. 28.09.2026 12:00 yeni plan plan 5068
  42. 28.09.2026 12:00 yeni plan plan 4799
  43. 28.09.2026 12:00 yeni plan plan 5446
  44. 28.09.2026 12:00 yeni plan plan 5347
  45. 28.09.2026 11:00 yeni plan plan 4731
  46. 28.09.2026 10:00 yeni plan plan 4513
  47. 28.09.2026 10:00 yeni plan plan 4443
  48. 28.09.2026 09:00 yeni plan plan 3458
  49. 28.09.2026 09:00 yeni plan plan 3955
  50. 28.09.2026 09:00 yeni plan plan 3694
  51. 28.09.2026 09:00 yeni plan plan 4222
  52. 28.09.2026 08:00 yeni plan plan 3214
  53. 27.09.2026 22:00 yeni plan plan 2786
  54. 27.09.2026 22:00 yeni plan plan 2839
  55. 27.09.2026 22:00 yeni plan plan 2816
  56. 25.09.2026 02:00 yeni plan plan 2626
  57. 25.09.2026 02:00 yeni plan plan 2432
  58. 24.09.2026 07:00 yeni plan plan 2133
  59. 24.09.2026 06:00 yeni plan plan 1784
  60. 24.09.2026 06:00 yeni plan plan 2105
  61. 24.09.2026 06:00 yeni plan plan 1953
  62. 24.09.2026 06:00 yeni plan plan 1625
  63. 24.09.2026 03:00 yeni plan plan 1534
  64. 24.09.2026 02:00 yeni plan plan 1391
  65. 24.09.2026 01:00 yeni plan plan 1327
  66. 24.09.2026 01:00 yeni plan plan 1214
  67. 23.09.2026 23:00 yeni plan plan 671
  68. 23.09.2026 23:00 yeni plan plan 588
  69. 23.09.2026 23:00 yeni plan plan 614
  70. 23.09.2026 23:00 yeni plan plan 749
  71. 23.09.2026 23:00 yeni plan plan 941
  72. 23.09.2026 23:00 yeni plan plan 1018
  73. 23.09.2026 23:00 yeni plan plan 546
  74. 23.09.2026 23:00 yeni plan plan 608
  75. 23.09.2026 23:00 yeni plan plan 846
  76. 23.09.2026 22:00 yeni plan plan 211
  77. 23.09.2026 22:00 yeni plan plan 491
  78. 23.09.2026 22:00 yeni plan plan 224
  79. 23.09.2026 22:00 yeni plan plan 419
  80. 23.09.2026 22:00 yeni plan plan 178

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0616814,818,7 744,6512
2026-10-0711925,343,6 1.084,5850
2026-10-0935422,4506,1 2.532,615.639

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
8853262,52,372 9.10.2026 18:11 en iyi
84761315,43,292 8.10.2026 21:12
897669,17,9214 9.10.2026 19:11
91171231,67,6166 11.10.2026 23:10
9174733,326,4836 12.10.2026 00:10
846526165,344,61.591 8.10.2026 20:05
909221.162,9841,530.842 11.10.2026 23:07
898311.635,21.321,057.116 9.10.2026 19:11
881891.961,01.636,360.609 9.10.2026 18:11 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:4410,Memory:168,Preemptive:81
Session'da görülen wait'ler
–
Başka oturumları bloklama
0
En büyük memory grant
2.376 KB

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 — 115:00 — 01516:00 — 017:00 — 018:00 — 01819:00 — 020:00 — 021:00 — 02122:00 — 023:00 — 0

Sorgu metni

SQL 
(@now datetime)WITH p AS (SELECT PlanHash, PlanXml, ROW_NUMBER() OVER (PARTITION BY PlanHash ORDER BY plan_id) AS rn FROM #px)
        INSERT perf.QdsPlanXml (PlanHash, PlanXmlCompressed, FirstSeenUtc, LastSeenUtc)
        SELECT PlanHash, COMPRESS(PlanXml), @now, @now FROM p
        WHERE rn = 1 AND NOT EXISTS (SELECT 1 FROM perf.QdsPlanXml AS e WHERE e.PlanHash = p.PlanHash)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.