I work on sql server 2014
How to write query get long process job or query or stored procedure running on server ?
as example suppose i run
exec sp_joblong
how to know this procedure running now
and which place it stop and take long time
and how to know it finish execution on server