Die Auslastung kann man wie üblich mit jedem Leistungsmonitor sehen, allerdings ist diese für WAWI-Instanzen gar nicht so erheblich, da die Ameise sequenziell arbeitet. Bei Massenimports schlucken die Page- und Rowlocks die meiste Zeit.
SELECT
OBJECT_NAME(P.object_id) AS TableName,
Resource_type,
request_session_id,
L.request_mode
FROM
sys.dm_tran_locks L
join sys.partitions P
ON L.resource_associated_entity_id = p.hobt_idSELECT
blocking_session_id AS BlockingSessionID,
session_id AS VictimSessionID,
(SELECT [text] FROM sys.sysprocesses
CROSS APPLY sys.dm_exec_sql_text([sql_handle])
WHERE spid = blocking_session_id) AS BlockingQuery,
[text] AS VictimQuery,
wait_time/1000 AS WaitDurationSecond,
wait_type AS WaitType,
percent_complete AS BlockingQueryCompletePercent
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text([sql_handle])
WHERE blocking_session_id > 0