Software Applications Programming Errors and solutions.

  You can user below  Server query to find long running process in database. Please try in query editor thanks. SELECT r . session_id , r . start_time , TotalElapsedTime_ms = r . total_elapsed_time , r .[ status ] , r . command , DatabaseName = DB_Name ( r . database_id ) , r . wait_type , r . last_wait_type , r . wait_resource , r . cpu_time , r . reads , r . writes , r . logical_reads , t .[ text ] AS [ executing batch ] , SUBSTRING ( t .[ text ], r . statement_start_offset / 2 , ( CASE WHEN r . statement_end_offset = -1 THEN DATALENGTH ( t .[ text ]) ELSE r . statement_end_offset END - r . statement_start_offset ) / 2 ) AS [ executing statement ] , p . query_plan FROM sys . dm_exec_requests r CROSS APPLY sys . dm_exec_sql_text ( r . sql_handle ) AS t CROSS APPLY sys . dm_exec_query_plan ( r . plan_handle ) AS p ORDER BY r . total_elapsed_time DESC ;