Pahalı sorgular0x40F1F815A52701EB
Demo modu

Sorgu 0x40F1F815A52701EB

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

Ort. süre 3,7 ms
Ort. CPU 3,2 ms
Bekleme payı %11,7
Ort. mantıksal okuma 837
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: 27 çalışma, ort. 0,2 ms24.09.2026: 30 çalışma, ort. 0,4 ms28.09.2026: 55 çalışma, ort. 1,3 ms29.09.2026: 102 çalışma, ort. 0,6 ms30.09.2026: 114 çalışma, ort. 0,5 ms1.10.2026: 42 çalışma, ort. 5,6 ms2.10.2026: 105 çalışma, ort. 4,3 ms3.10.2026: 91 çalışma, ort. 2,8 ms4.10.2026: 110 çalışma, ort. 8,6 ms5.10.2026: 168 çalışma, ort. 5,2 ms6.10.2026: 168 çalışma, ort. 3,4 ms7.10.2026: 119 çalışma, ort. 4,4 ms9.10.2026: 35 çalışma, ort. 6,1 ms max 168 çalışma max ort. süre 8,6 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 9090
  2. 11.10.2026 23:00 yeni plan plan 9110
  3. 11.10.2026 23:00 yeni plan plan 9115
  4. 11.10.2026 23:00 yeni plan plan 9125
  5. 9.10.2026 19:00 yeni plan plan 8974
  6. 9.10.2026 19:00 yeni plan plan 8981
  7. 9.10.2026 19:00 yeni plan plan 8989
  8. 9.10.2026 16:00 yeni plan plan 8909
  9. 9.10.2026 15:00 yeni plan plan 8885
  10. 9.10.2026 15:00 yeni plan plan 8889
  11. 9.10.2026 14:51 tanım değişti DBA.usp_Apply_Qds
  12. 9.10.2026 14:00 yeni plan plan 8816
  13. 9.10.2026 14:00 yeni plan plan 8846
  14. 9.10.2026 14:00 yeni plan plan 8851
  15. 7.10.2026 06:00 yeni plan plan 8654
  16. 7.10.2026 06:00 yeni plan plan 8655
  17. 6.10.2026 07:00 yeni plan plan 8630
  18. 5.10.2026 22:00 yeni plan plan 8536
  19. 5.10.2026 18:00 yeni plan plan 8526
  20. 5.10.2026 15:00 yeni plan plan 8514
  21. 5.10.2026 14:00 yeni plan plan 8505
  22. 5.10.2026 14:00 yeni plan plan 8507
  23. 5.10.2026 14:00 yeni plan plan 8512
  24. 5.10.2026 13:00 yeni plan plan 8497
  25. 5.10.2026 12:00 yeni plan plan 8489
  26. 5.10.2026 11:00 yeni plan plan 8463
  27. 5.10.2026 11:00 yeni plan plan 8468
  28. 5.10.2026 11:00 yeni plan plan 8474
  29. 5.10.2026 10:00 yeni plan plan 8361
  30. 5.10.2026 10:00 yeni plan plan 8364
  31. 5.10.2026 09:00 yeni plan plan 8348
  32. 5.10.2026 09:00 yeni plan plan 8352
  33. 5.10.2026 09:00 yeni plan plan 8355
  34. 5.10.2026 08:00 yeni plan plan 8274
  35. 5.10.2026 08:00 yeni plan plan 8279
  36. 5.10.2026 08:00 yeni plan plan 8285
  37. 5.10.2026 05:00 yeni plan plan 8214
  38. 5.10.2026 03:00 yeni plan plan 8155
  39. 5.10.2026 03:00 yeni plan plan 8160
  40. 5.10.2026 03:00 yeni plan plan 8164
  41. 5.10.2026 00:00 yeni plan plan 8113
  42. 4.10.2026 17:00 yeni plan plan 8085
  43. 4.10.2026 15:00 yeni plan plan 8082
  44. 4.10.2026 10:00 yeni plan plan 8069
  45. 3.10.2026 04:00 yeni plan plan 8015
  46. 2.10.2026 18:00 yeni plan plan 7931
  47. 2.10.2026 17:00 yeni plan plan 7921
  48. 2.10.2026 17:00 yeni plan plan 7925
  49. 2.10.2026 13:00 yeni plan plan 7900
  50. 2.10.2026 12:00 yeni plan plan 7888
  51. 2.10.2026 12:00 yeni plan plan 7893
  52. 2.10.2026 12:00 yeni plan plan 7897
  53. 2.10.2026 01:00 yeni plan plan 7872
  54. 2.10.2026 00:00 yeni plan plan 7864
  55. 1.10.2026 23:00 yeni plan plan 7851
  56. 1.10.2026 23:00 yeni plan plan 7856
  57. 1.10.2026 22:00 yeni plan plan 7813
  58. 1.10.2026 22:00 yeni plan plan 7818
  59. 1.10.2026 22:00 yeni plan plan 7823
  60. 1.10.2026 21:00 yeni plan plan 7729
  61. 1.10.2026 20:00 yeni plan plan 7713
  62. 1.10.2026 20:00 yeni plan plan 7719
  63. 1.10.2026 19:00 yeni plan plan 7676
  64. 1.10.2026 19:00 yeni plan plan 7685
  65. 1.10.2026 19:00 yeni plan plan 7692
  66. 30.09.2026 10:00 yeni plan plan 7507
  67. 30.09.2026 06:00 yeni plan plan 7403
  68. 29.09.2026 23:00 yeni plan plan 7350
  69. 29.09.2026 16:00 yeni plan plan 7209
  70. 29.09.2026 16:00 yeni plan plan 7216
  71. 29.09.2026 15:00 yeni plan plan 7176
  72. 29.09.2026 12:00 yeni plan plan 6933
  73. 29.09.2026 11:00 yeni plan plan 6919
  74. 29.09.2026 11:00 yeni plan plan 6926
  75. 28.09.2026 13:00 yeni plan plan 5938
  76. 28.09.2026 13:00 yeni plan plan 5945
  77. 28.09.2026 13:00 yeni plan plan 5951
  78. 28.09.2026 12:00 yeni plan plan 5031
  79. 28.09.2026 12:00 yeni plan plan 5066
  80. 28.09.2026 12:00 yeni plan plan 5071
  81. 28.09.2026 12:00 yeni plan plan 5131
  82. 28.09.2026 12:00 yeni plan plan 5345
  83. 28.09.2026 12:00 yeni plan plan 5717
  84. 28.09.2026 11:00 yeni plan plan 4728
  85. 28.09.2026 11:00 yeni plan plan 4734
  86. 28.09.2026 11:00 yeni plan plan 4739
  87. 28.09.2026 10:00 yeni plan plan 4440
  88. 28.09.2026 10:00 yeni plan plan 4511
  89. 28.09.2026 09:00 yeni plan plan 4220
  90. 24.09.2026 03:00 yeni plan plan 1532
  91. 24.09.2026 03:00 yeni plan plan 1538
  92. 24.09.2026 02:00 yeni plan plan 1389
  93. 24.09.2026 01:00 yeni plan plan 1212
  94. 24.09.2026 01:00 yeni plan plan 1325
  95. 23.09.2026 23:00 yeni plan plan 544
  96. 23.09.2026 23:00 yeni plan plan 585
  97. 23.09.2026 23:00 yeni plan plan 669
  98. 23.09.2026 23:00 yeni plan plan 747
  99. 23.09.2026 22:00 yeni plan plan 417
  100. 23.09.2026 22:00 yeni plan plan 488

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-23270,20,2 0,314
2026-09-24300,40,4 0,736
2026-09-28551,31,3 6,4622
2026-09-291020,60,6 2,3138
2026-09-301140,50,5 0,7156
2026-10-01424,95,6 34,2785
2026-10-021054,14,3 25,4866
2026-10-03912,82,8 6,4754
2026-10-041105,78,6 23,81.328
2026-10-051685,05,2 28,41.213
2026-10-061683,43,4 36,11.002
2026-10-071193,74,4 24,21.085
2026-10-09356,16,1 29,11.975

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
48840,20,227 23.09.2026 22:51 en iyi
74770,20,228 23.09.2026 23:11
153870,20,263 24.09.2026 06:10
66950,20,25 23.09.2026 23:08
41750,30,35 23.09.2026 22:49
513150,30,34 28.09.2026 12:10
422050,30,34 28.09.2026 09:59
58510,30,33 23.09.2026 23:03
54450,30,35 23.09.2026 23:01
153210,30,315 24.09.2026 03:10
7176350,30,35 29.09.2026 18:42
1389100,30,35 24.09.2026 02:10
503150,30,34 28.09.2026 12:01
451150,40,44 28.09.2026 10:35
571750,40,44 28.09.2026 12:43
6919100,40,44 29.09.2026 13:08
7507190,40,4171 30.09.2026 20:10
121250,40,45 24.09.2026 01:13
7403710,50,5164 30.09.2026 22:10
7350260,60,6126 30.09.2026 05:10
132570,60,676 24.09.2026 02:10
7209320,70,7163 29.09.2026 23:10
472820,70,790 28.09.2026 11:10
593820,70,787 28.09.2026 13:10
6926180,70,7216 29.09.2026 15:10
506620,80,8200 28.09.2026 12:10
767610,90,92 1.10.2026 19:05
5951130,90,9411 28.09.2026 16:10
898921,41,4166 9.10.2026 19:11
693331,91,8986 29.09.2026 15:10
828531,91,9456 5.10.2026 08:10
444041,91,91.257 28.09.2026 10:10
7823181,91,9308 2.10.2026 02:10
8164292,02,0379 5.10.2026 07:10
8851212,12,1602 9.10.2026 18:11
721622,22,2674 29.09.2026 18:10
84741972,22,2524 8.10.2026 21:12
84891822,52,3703 8.10.2026 14:13
865562,52,5879 8.10.2026 12:10
8355102,52,5472 5.10.2026 10:14
7692232,62,6378 1.10.2026 21:10
78971092,72,5641 5.10.2026 02:10
863073,02,8514 6.10.2026 08:10
79001143,03,0696 4.10.2026 20:10
890963,13,1494 9.10.2026 16:11
793163,43,3580 3.10.2026 02:10
811363,53,5503 5.10.2026 00:10
8085173,53,5491 5.10.2026 02:10
787213,73,71.220 2.10.2026 01:10
821423,93,91.703 5.10.2026 05:10
911543,93,91.420 11.10.2026 23:07
827413,93,91.245 5.10.2026 08:10
849733,93,91.494 8.10.2026 13:10
851214,14,11.170 5.10.2026 14:10
850554,64,61.860 8.10.2026 20:03
534524,74,73.448 28.09.2026 12:12
898144,84,81.375 9.10.2026 19:11
8514185,05,01.131 8.10.2026 09:11
785675,33,9597 2.10.2026 00:10
507125,55,43.311 28.09.2026 12:10
594515,95,63.055 28.09.2026 13:10
473916,16,13.337 28.09.2026 11:10
881626,46,42.746 9.10.2026 18:10
788856,56,54.412 4.10.2026 22:10
781316,66,01.711 1.10.2026 22:10
792136,66,42.233 2.10.2026 23:10
912586,64,0201 11.10.2026 23:10
909017,07,04.546 11.10.2026 23:06
768518,18,1212 1.10.2026 19:06
473418,48,43.051 28.09.2026 11:10
786449,08,81.138 2.10.2026 00:10
8279311,510,52.679 5.10.2026 08:10
84631912,811,22.449 8.10.2026 21:10
8348112,812,86.293 5.10.2026 09:10
8974112,812,82.074 9.10.2026 19:10
80151813,012,52.691 5.10.2026 01:10
7713113,213,22.400 1.10.2026 20:10
8361113,312,43.363 5.10.2026 10:10
8155313,513,02.413 5.10.2026 04:10
7729113,813,83.540 1.10.2026 21:10
8468513,813,82.426 5.10.2026 13:12
8352114,214,23.510 5.10.2026 09:14
8654215,314,65.538 7.10.2026 06:10
8160117,116,84.491 5.10.2026 03:12
8069317,416,53.608 4.10.2026 22:12
8885318,118,05.856 9.10.2026 17:12
7893519,118,24.387 5.10.2026 01:11
7818319,817,93.509 2.10.2026 02:10
8364121,220,74.848 5.10.2026 10:14
85262221,819,85.838 8.10.2026 20:04
8536522,722,76.570 8.10.2026 21:12
80821723,56,61.309 4.10.2026 21:10
85071127,324,17.553 7.10.2026 21:11
8889228,328,310.320 9.10.2026 18:11
7925328,524,63.318 4.10.2026 11:10
8846129,329,29.829 9.10.2026 14:55
7719132,332,33.612 1.10.2026 20:11
9110133,233,210.218 11.10.2026 23:07
7851137,016,04.673 1.10.2026 23:10 en kötü

Davranış

Wait kategorileri (QDS)
Buffer Latch:290,CPU:149,Buffer IO:59
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 q SET q.query_hash = g.query_hash, q.object_id = g.object_id, q.ObjectName = g.ObjectName,
                     q.context_settings_id = g.context_settings_id, q.LastExecutionUtc = g.LastExecutionUtc, q.LastSeenUtc = @now,
                     q.TextHash = COALESCE(x.TextHash, q.TextHash)
        FROM perf.QdsQuery AS q
        JOIN perf.Stg_QdsQuery AS g ON g.ServerID = q.ServerID AND g.DatabaseName = q.DatabaseName AND g.query_id = q.query_id
        LEFT JOIN #txt AS x ON x.query_text_id = g.query_text_id
        WHERE g.ServerID = @ServerID AND g.DatabaseName = @DatabaseName

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.