Pahalı sorgular0x65AA794138FF52B1
Demo modu

Sorgu 0x65AA794138FF52B1

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

Ort. süre 0,5 ms
Ort. CPU 0,5 ms
Bekleme payı %4,8
Ort. mantıksal okuma 60
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,4 ms24.09.2026: 98 çalışma, ort. 0,5 ms25.09.2026: 10 çalışma, ort. 0,6 ms27.09.2026: 54 çalışma, ort. 1,1 ms28.09.2026: 161 çalışma, ort. 0,4 ms29.09.2026: 168 çalışma, ort. 0,4 ms30.09.2026: 113 çalışma, ort. 0,2 ms1.10.2026: 42 çalışma, ort. 6,3 ms2.10.2026: 105 çalışma, ort. 0,4 ms3.10.2026: 91 çalışma, ort. 0,2 ms4.10.2026: 112 çalışma, ort. 0,3 ms5.10.2026: 168 çalışma, ort. 0,3 ms6.10.2026: 168 çalışma, ort. 0,3 ms7.10.2026: 119 çalışma, ort. 0,3 ms9.10.2026: 35 çalışma, ort. 0,3 ms max 168 çalışma max ort. süre 6,3 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 9089
  2. 9.10.2026 19:00 yeni plan plan 8973
  3. 9.10.2026 14:51 tanım değişti DBA.usp_Apply_Qds
  4. 9.10.2026 14:00 yeni plan plan 8815
  5. 5.10.2026 14:00 yeni plan plan 8504
  6. 5.10.2026 11:00 yeni plan plan 8462
  7. 5.10.2026 08:00 yeni plan plan 8273
  8. 5.10.2026 03:00 yeni plan plan 8154
  9. 2.10.2026 17:00 yeni plan plan 7924
  10. 2.10.2026 12:00 yeni plan plan 7887
  11. 1.10.2026 22:00 yeni plan plan 7812
  12. 1.10.2026 19:00 yeni plan plan 7675
  13. 1.10.2026 19:00 yeni plan plan 7691
  14. 30.09.2026 06:00 yeni plan plan 7402
  15. 29.09.2026 16:00 yeni plan plan 7208
  16. 29.09.2026 15:00 yeni plan plan 7061
  17. 29.09.2026 15:00 yeni plan plan 7175
  18. 29.09.2026 11:00 yeni plan plan 6918
  19. 29.09.2026 11:00 yeni plan plan 6925
  20. 28.09.2026 19:00 yeni plan plan 6516
  21. 28.09.2026 17:00 yeni plan plan 6428
  22. 28.09.2026 16:00 yeni plan plan 6177
  23. 28.09.2026 13:00 yeni plan plan 5937
  24. 28.09.2026 12:00 yeni plan plan 4796
  25. 28.09.2026 12:00 yeni plan plan 5030
  26. 28.09.2026 12:00 yeni plan plan 5065
  27. 28.09.2026 12:00 yeni plan plan 5130
  28. 28.09.2026 12:00 yeni plan plan 5344
  29. 28.09.2026 12:00 yeni plan plan 5360
  30. 28.09.2026 12:00 yeni plan plan 5366
  31. 28.09.2026 12:00 yeni plan plan 5443
  32. 28.09.2026 12:00 yeni plan plan 5716
  33. 28.09.2026 11:00 yeni plan plan 4727
  34. 28.09.2026 10:00 yeni plan plan 4439
  35. 28.09.2026 10:00 yeni plan plan 4510
  36. 28.09.2026 09:00 yeni plan plan 3455
  37. 28.09.2026 09:00 yeni plan plan 3691
  38. 28.09.2026 09:00 yeni plan plan 3952
  39. 28.09.2026 09:00 yeni plan plan 4219
  40. 28.09.2026 08:00 yeni plan plan 3211
  41. 27.09.2026 22:00 yeni plan plan 2783
  42. 27.09.2026 22:00 yeni plan plan 2812
  43. 25.09.2026 02:00 yeni plan plan 2429
  44. 25.09.2026 02:00 yeni plan plan 2623
  45. 24.09.2026 07:00 yeni plan plan 2130
  46. 24.09.2026 06:00 yeni plan plan 1622
  47. 24.09.2026 06:00 yeni plan plan 1781
  48. 24.09.2026 06:00 yeni plan plan 1950
  49. 24.09.2026 06:00 yeni plan plan 2102
  50. 24.09.2026 03:00 yeni plan plan 1531
  51. 24.09.2026 03:00 yeni plan plan 1537
  52. 24.09.2026 02:00 yeni plan plan 1388
  53. 24.09.2026 01:00 yeni plan plan 1109
  54. 24.09.2026 01:00 yeni plan plan 1211
  55. 24.09.2026 01:00 yeni plan plan 1324
  56. 23.09.2026 23:00 yeni plan plan 543
  57. 23.09.2026 23:00 yeni plan plan 584
  58. 23.09.2026 23:00 yeni plan plan 605
  59. 23.09.2026 23:00 yeni plan plan 611
  60. 23.09.2026 23:00 yeni plan plan 668
  61. 23.09.2026 23:00 yeni plan plan 746
  62. 23.09.2026 23:00 yeni plan plan 843
  63. 23.09.2026 23:00 yeni plan plan 938
  64. 23.09.2026 23:00 yeni plan plan 1015
  65. 23.09.2026 22:00 yeni plan plan 175
  66. 23.09.2026 22:00 yeni plan plan 208
  67. 23.09.2026 22:00 yeni plan plan 221
  68. 23.09.2026 22:00 yeni plan plan 416
  69. 23.09.2026 22:00 yeni plan plan 487

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-23670,40,4 0,640
2026-09-24980,50,5 1,241
2026-09-25100,50,6 0,733
2026-09-27541,11,1 5,3300
2026-09-281610,40,4 0,840
2026-09-291680,30,4 0,725
2026-09-301130,20,2 0,321
2026-10-01426,06,3 76,5637
2026-10-021050,30,4 1,129
2026-10-03910,20,2 0,319
2026-10-041120,20,3 0,841
2026-10-051680,30,3 0,950
2026-10-061680,30,3 1,028
2026-10-071190,20,3 0,822
2026-10-09350,30,3 0,774

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
8154350,10,111 5.10.2026 07:10 en iyi
7402890,10,121 30.09.2026 22:10
5937150,20,222 28.09.2026 16:10
897370,20,213 9.10.2026 19:11
6428820,20,224 29.09.2026 11:10
78872820,20,227 5.10.2026 02:10
153110,20,24 24.09.2026 03:10
74670,20,250 23.09.2026 23:11
7208600,20,220 30.09.2026 05:10
536010,20,24 28.09.2026 12:12
58410,20,24 23.09.2026 23:03
20840,30,336 23.09.2026 22:45
60510,30,36 23.09.2026 23:05
153770,30,343 24.09.2026 06:10
101570,30,318 24.09.2026 00:10
213040,30,328 24.09.2026 08:10
6925210,30,336 29.09.2026 15:10
84621950,30,340 6.10.2026 22:14
8815350,30,374 9.10.2026 18:11
9089140,40,456 11.10.2026 23:10
66850,40,431 23.09.2026 23:08
85042880,40,326 8.10.2026 21:12
61150,40,431 23.09.2026 23:05
48740,40,4131 23.09.2026 22:51
8273210,40,4126 5.10.2026 10:14
22150,40,442 23.09.2026 22:45
6177100,40,429 28.09.2026 17:03
395250,40,429 28.09.2026 09:53
242950,40,429 25.09.2026 02:44
345550,40,430 28.09.2026 09:33
175100,40,432 23.09.2026 22:39
178150,40,432 24.09.2026 06:33
451050,40,428 28.09.2026 10:35
513050,40,429 28.09.2026 12:10
479650,50,529 28.09.2026 12:00
506540,50,5151 28.09.2026 12:10
544350,50,529 28.09.2026 12:16
2102350,50,532 24.09.2026 08:28
41650,50,531 23.09.2026 22:49
1388100,50,538 24.09.2026 02:10
54350,50,531 23.09.2026 23:01
443940,50,5132 28.09.2026 10:10
421950,50,529 28.09.2026 09:59
7175350,50,527 29.09.2026 18:42
369150,50,529 28.09.2026 09:50
162250,50,532 24.09.2026 06:32
321150,50,544 28.09.2026 08:44
503050,50,529 28.09.2026 12:01
6516300,50,531 29.09.2026 11:49
536650,50,529 28.09.2026 12:12
938150,50,543 24.09.2026 01:11
2623600,60,629 28.09.2026 01:05
472740,60,693 28.09.2026 11:10
84350,60,643 23.09.2026 23:16
6918100,60,628 29.09.2026 13:08
706150,60,628 29.09.2026 15:14
571650,60,630 28.09.2026 12:43
121150,70,743 24.09.2026 01:13
195050,70,732 24.09.2026 06:43
7924260,80,672 2.10.2026 20:10
7812350,80,530 2.10.2026 02:10
132470,90,9116 24.09.2026 02:10
534421,01,0365 28.09.2026 12:12
110921,21,184 24.09.2026 01:10
7691261,51,5114 1.10.2026 21:10
281264,04,01.520 27.09.2026 22:54
278335,45,41.933 27.09.2026 22:54
76752100,3100,211.550 1.10.2026 19:06 en kötü

Davranış

Wait kategorileri (QDS)
Buffer IO:36,Memory:4
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 
(@now datetime)WITH t AS (SELECT TextHash, query_sql_text, ROW_NUMBER() OVER (PARTITION BY TextHash ORDER BY query_text_id) AS rn FROM #txt WHERE TextHash IS NOT NULL)
        INSERT perf.QdsQueryText (TextHash, query_sql_text, FirstSeenUtc, LastSeenUtc)
        SELECT TextHash, query_sql_text, @now, @now FROM t
        WHERE rn = 1 AND NOT EXISTS (SELECT 1 FROM perf.QdsQueryText AS e WHERE e.TextHash = t.TextHash)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.