Quer saber qual comando esta demorando?
sp_whoisactive
insert into DBA_QueryCost
select Getdate(),
m.session_id,
m.dop,
requested_memory_kb,
granted_memory_kb,
required_memory_kb,
used_memory_kb,
query_cost,
qy.objectid,
wait_type,
cpu_time,
total_elapsed_time,
text_size,
qy.dbid,
program_name,
loginame,
qy.query_plan,
txt.text
from sys.dm_exec_query_memory_grants m
CROSS APPLY sys.dm_exec_query_plan(plan_handle) as qy
inner join sys.sysprocesses p
on p.spid = m.session_id
inner join sys.dm_exec_requests r
on p.spid = r.session_id
CROSS APPLY sys.dm_exec_sql_text(m.sql_handle) txt
where m.session_id <> @@spid
AND txt.text not like '%sys.dm_db_missing_index_groups%'
order by query_cost desc,
used_memory_kb desc
=================================
OPENROWSET (Transact-SQL) - SQL Server | Microsoft Learn
BULK 'data_file'
É o caminho completo do arquivo de dados cujos dados serão copiados para a tabela de destino.
SELECT * FROM OPENROWSET(
BULK 'C:\DATA\inv-2017-01-19.csv',
SINGLE_CLOB) AS DATA;