How to write query get long process job or query or stored procedure r

Question

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

Nitin Sontakke · Answer

Hello, Performance improvement needs a multi-pronged approach. Generating performance related reports (and even graphs) is now much more easier than before, thanks to new features added right in Microsoft SQL Server Management Studio (SSMS). You can run reports shown in following screen shot and they provide exhaustive information you will need to start looking into. Remember that the reports are generated (to the best of my knowledge) from the cached information with SQL Server. If your servers are being rebooted on every Sunday, no point in doing this on Monday. Instead do this on Friday. More the server running time closure the reports will be to the reality. Hope it helps!

Amit Mohanty · Answer

Hey plese check the below link, this may help you. https://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL%20Server%20Agent%20jobs.aspx

Rajat Jaiswal · Answer

Hi, You can follow the below link to find out what is running on your SQL server with wait type and current status https://indiandotnet.wordpress.com/2011/09/05/how-to-find-what-is-currently-running-on-your-sql-server/