Extended SP to identify which Process

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Extended SP to identify which Process

Author

Topic

aoriju
Posting Yak Master

156 Posts

Posted - 2011-06-02 : 09:16:37

Hi All,

How to identify which process is running long time

Is there any Extended SP available ?
Then Pls give me.
And how to kill that Process..
Is any Sp available ?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-02 : 09:31:01

sp_whoisactive is an excellent procedure to show running processes and their resources, waits and locks. There's a download link here:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

Once you find a spid/session ID that's hung you can stop it with the KILL command, which is documented in Books Online: http://msdn.microsoft.com/en-us/library/ms173730.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources