Pahalı sorgular0x72D0DB6D73F273CF
Demo modu

Sorgu 0x72D0DB6D73F273CF

SQL-1 · DB-10 · dönem 2026-10-03 → 2026-10-09 · 7 çalışma · Pahalı sorgulara dön

Analizi aç (#1191)
Ort. süre 7.792,5 ms
Ort. CPU 7.716,4 ms
Bekleme payı %1
Ort. mantıksal okuma 160.646
En büyük bellek izni –

Önceki dönemde çalışma yok; değişim hesaplanmadı.

Takip

Karar bekliyor

Analiz #1191 tamamlandı; 2 öneri karar bekliyor. "Analiz et" yeni analiz açmaz, bu analizi açar.

Bilinen sorgu, ertele:

Günlük trend

5.10.2026: 2 çalışma, ort. 5.124,7 ms6.10.2026: 2 çalışma, ort. 4.407,0 ms7.10.2026: 1 çalışma, ort. 9.321,2 ms9.10.2026: 2 çalışma, ort. 13.081,5 ms max 2 çalışma max ort. süre 13.081,5 ms 5.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. 9.10.2026 19:44 analiz #1191
  2. 9.10.2026 14:00 yeni plan plan 976
  3. 8.10.2026 20:00 yeni plan plan 969
  4. 8.10.2026 08:00 yeni plan plan 963
  5. 7.10.2026 20:00 yeni plan plan 958
  6. 6.10.2026 02:00 yeni plan plan 857
  7. 5.10.2026 21:00 yeni plan plan 838

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0525.122,55.124,7 6.033,9160.058
2026-10-0624.406,54.407,0 4.555,4160.022
2026-10-0719.271,29.321,2 9.321,2160.915
2026-10-09212.843,013.081,5 13.081,5161.726

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
85724.407,04.406,5160.022 6.10.2026 22:15 en iyi
83825.124,75.122,5160.058 5.10.2026 22:03
96316.716,05.912,3160.219 8.10.2026 08:30
95819.321,29.271,2160.915 7.10.2026 20:40
969110.996,710.786,2185.037 8.10.2026 20:03
976213.081,512.843,0161.726 9.10.2026 14:52 en kötü

Davranış

Wait kategorileri (QDS)
Memory:2656,CPU:1523,Buffer IO:31
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 
(@tz nvarchar(128),@off int)SELECT 1, N'DB-10', i.object_id, i.index_id, CAST('20261007' AS datetime), ISNULL(u.user_seeks, 0), ISNULL(u.user_scans, 0), ISNULL(u.user_lookups, 0), ISNULL(u.user_updates, 0),
       CASE WHEN @tz IS NULL THEN DATEADD(minute, @off, u.last_user_seek) ELSE CONVERT(datetime, u.last_user_seek AT TIME ZONE @tz AT TIME ZONE N'UTC') END, CASE WHEN @tz IS NULL THEN DATEADD(minute, @off, u.last_user_scan) ELSE CONVERT(datetime, u.last_user_scan AT TIME ZONE @tz AT TIME ZONE N'UTC') END, CASE WHEN @tz IS NULL THEN DATEADD(minute, @off, u.last_user_lookup) ELSE CONVERT(datetime, u.last_user_lookup AT TIME ZONE @tz AT TIME ZONE N'UTC') END, CASE WHEN @tz IS NULL THEN DATEADD(minute, @off, u.last_user_update) ELSE CONVERT(datetime, u.last_user_update AT TIME ZONE @tz AT TIME ZONE N'UTC') END,
       (SELECT CASE WHEN @tz IS NULL THEN DATEADD(minute, @off, sqlserver_start_time) ELSE CONVERT(datetime, sqlserver_start_time AT TIME ZONE @tz AT TIME ZONE N'UTC') END FROM sys.dm_os_sys_info),
       sz.RowCnt, sz.SizeMB, op.Ins, op.Upd, op.Del, op.Alloc, op.LockMs, op.LatchMs, op.IoMs
       FROM sys.indexes AS i JOIN sys.objects AS o ON o.object_id = i.object_id
       LEFT JOIN sys.dm_db_index_usage_stats AS u ON u.database_id = DB_ID() AND u.object_id = i.object_id AND u.index_id = i.index_id
       OUTER APPLY (SELECT SUM(ps.row_count) AS RowCnt, CAST(SUM(ps.used_page_count) * 8 / 1024.0 AS decimal(18,2)) AS SizeMB
                    FROM sys.dm_db_partition_stats AS ps WHERE ps.object_id = i.object_id AND ps.index_id = i.index_id) AS sz
       OUTER APPLY (SELECT SUM(x.leaf_insert_count) AS Ins, SUM(x.leaf_update_count) AS Upd, SUM(x.leaf_delete_count) AS Del,
                           SUM(x.leaf_allocation_count) AS Alloc, SUM(x.row_lock_wait_in_ms) AS LockMs, SUM(x.page_latch_wait_in_ms) AS LatchMs,
                           SUM(x.page_io_latch_wait_in_ms) AS IoMs
                    FROM sys.dm_db_index_operational_stats(DB_ID(), i.object_id, i.index_id, NULL) AS x) AS op
       WHERE o.is_ms_shipped = 0 AND o.type IN ('U','V') AND i.is_hypothetical = 0

Bu sorgunun analizleri

#OluşturmaİsteyenDurumÖneriler
#11919.10.2026 19:44kullanıcı Bitti 2 öneri · 0 onay · 0 red · 0 uygulandı