Pahalı sorgular0x1B1A7E9675535237
Demo modu

Sorgu 0x1B1A7E9675535237

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

Ort. süre 49,2 ms
Ort. CPU 36,8 ms
Bekleme payı %25,2
Ort. mantıksal okuma 1.266
En büyük bellek izni 12 MB

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

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-23671,71,9 6,297
2026-09-24981,71,9 10,167
2026-09-25100,60,7 0,730
2026-09-275424,225,9 174,6916
2026-09-281613,03,3 19,397
2026-09-291682,22,4 10,977
2026-09-301132,02,9 7,665
2026-10-0142240,6305,6 2.588,96.442
2026-10-0210554,579,0 2.131,11.573
2026-10-03913,84,1 15,3117
2026-10-0411232,773,0 996,31.153
2026-10-0516577,193,7 1.715,63.029
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
536310,20,24 28.09.2026 12:12 en iyi
58810,20,24 23.09.2026 23:03
67150,60,655 23.09.2026 23:08
178450,60,632 24.09.2026 06:33
479950,60,631 28.09.2026 12:00
178100,60,647 23.09.2026 22:39
22450,60,641 23.09.2026 22:45
369450,60,630 28.09.2026 09:50
41950,60,644 23.09.2026 22:49
61450,70,655 23.09.2026 23:05
513350,70,631 28.09.2026 12:10
162550,70,632 24.09.2026 06:32
536950,70,632 28.09.2026 12:12
243250,70,630 25.09.2026 02:44
395550,70,630 28.09.2026 09:53
503350,70,730 28.09.2026 12:01
422250,70,730 28.09.2026 09:59
2105350,70,737 24.09.2026 08:28
544650,70,746 28.09.2026 12:16
6180100,70,754 28.09.2026 17:03
6519300,70,740 29.09.2026 11:49
321450,80,731 28.09.2026 08:44
1391100,80,752 24.09.2026 02:10
345850,80,745 28.09.2026 09:33
7178350,80,742 29.09.2026 18:42
571950,80,730 28.09.2026 12:43
451350,80,731 28.09.2026 10:35
54650,80,755 23.09.2026 23:01
84650,80,832 23.09.2026 23:16
706450,90,844 29.09.2026 15:14
6921100,90,851 29.09.2026 13:08
153480,90,843 24.09.2026 06:10
121450,90,832 24.09.2026 01:13
941150,90,833 24.09.2026 01:11
60811,01,062 23.09.2026 23:05
195351,11,032 24.09.2026 06:43
2626601,10,742 28.09.2026 01:05
21141,71,675 23.09.2026 22:45
836651,91,667 5.10.2026 10:14
815762,22,083 5.10.2026 03:12
6431812,42,265 29.09.2026 11:10
8853262,52,372 9.10.2026 18:11
7211602,52,364 30.09.2026 05:10
7405892,81,762 30.09.2026 22:10
5940152,92,789 28.09.2026 16:10
213343,12,998 24.09.2026 08:10
74973,93,0235 23.09.2026 23:11
6928213,93,7122 29.09.2026 15:10
7694234,83,193 1.10.2026 21:10
84762135,03,3103 8.10.2026 21:12
101895,24,6156 24.09.2026 01:10
7825306,93,893 2.10.2026 02:10
897669,17,9214 9.10.2026 19:11
1327710,59,4307 24.09.2026 02:10
491410,610,0480 23.09.2026 22:51
789020211,86,4126 5.10.2026 02:10
4443416,515,6487 28.09.2026 10:10
2839116,815,3738 27.09.2026 22:54
4731417,616,3417 28.09.2026 11:10
5068422,521,3592 28.09.2026 12:10
81622927,525,0990 5.10.2026 07:10
91171231,67,6166 11.10.2026 23:10
5347236,334,31.070 28.09.2026 12:12
6862198,395,53.041 29.09.2026 11:10
8465270106,078,12.920 8.10.2026 20:05
7895106127,871,12.335 5.10.2026 01:11
827613150,3132,24.969 5.10.2026 10:14
28165163,8153,85.872 27.09.2026 22:54
27863176,5163,95.805 27.09.2026 22:54
78155799,6639,619.948 2.10.2026 02:10
771411.008,4881,012.324 1.10.2026 20:10
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
768832.230,21.707,349.119 1.10.2026 21:10
767912.491,22.176,160.744 1.10.2026 19:06 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:6727,Memory:505,Preemptive:159
Session'da görülen wait'ler
–
Başka oturumları bloklama
1
En büyük memory grant
11.776 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 — 114:00 — 115:00 — 01516:00 — 017:00 — 018:00 — 01819:00 — 120: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.