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

ahmed elbarbary

4y1.2k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke4y ago
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 Mohanty4y ago
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 Jaiswal4y ago
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/