I am rather new to SQL Server administrations, I am running an SSIS that never ends...
A) looking at the processes using
SELECT r.*, t.text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.status IN (N'Suspended', N'Running', N'Runnable', N'Pending')
I see the session is SUSPENDED
B) looking at the actual execution plan using
SELECT plan_handle
FROM sys.dm_exec_requests
WHERE session_id = 55
SELECT query_plan
FROM sys.dm_exec_query_plan (0x06000A00FB4E0A2240615FAE010000000000000000000000)
I see 95% of time spent on parallelism
How can I solve this issue?
Thanks in advance, Assaf