Indexkontrolle:
SELECT
i.name,
s.user_seeks, s.user_scans, s.user_lookups, s.user_updates
FROM sys.indexes i
LEFT JOIN sys.dm_db_index_usage_stats s
ON s.object_id = i.object_id
AND s.index_id = i.index_id
AND s.database_id = DB_ID()
WHERE i.object_id = OBJECT_ID('dbo.DatenbankTabelle')
ORDER BY (ISNULL(s.user_seeks,0) + ISNULL(s.user_scans,0) + ISNULL(s.user_lookups,0)) DESC;
Queryplan kontrollieren:
SELECT
q.query_id,
p.plan_id,
LEFT(qt.query_sql_text, 4000) AS query_text,
p.query_plan
FROM sys.query_store_plan p
JOIN sys.query_store_query q ON p.query_id = q.query_id
JOIN sys.query_store_query_text qt ON q.query_text_id = qt.query_text_id
WHERE p.plan_id IN (10884, 652, 3669, 651); -- anpassen
|