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