?
Solved

How do SQL 2008 : Kill a runaway process that I cant stop nor identify. Original query was infinite loop that we aborted.

Posted on 2011-10-04
2
Medium Priority
?
3,485 Views
Last Modified: 2012-05-12
How do Kill a runaway process that I cant stop nor identify. Original query was infinite loop that we aborted.

Proces was kicked off via web app that called a SP.
Its queueing emails nonstop.
The query was a loop that sent out emails.

We have restarted SQl, Server Agent and restarted the server Only thing left to try is get out the 12 gauge.

 Lost on how to kill  or identify this runaway process. Its sending mail and has my dbmail server clogged.

Help needed asap.

0
Comment
Question by:LeadCo
2 Comments
 
LVL 5

Accepted Solution

by:
AlokJain0412 earned 2000 total points
ID: 36915278
In  sql server 2008
use master
GO
select * from sysprocesses (nolock) where blocked = 0 and spid !=@@spid
Identify
and then use

--Kill spid  

Which you want to kill

Other then through SSMS identify and Kill the perticular process ID

You can use this Link reference

http://www.kodyaz.com/articles/kill-all-processes-of-a-database.aspx
 
 
0
 

Author Closing Comment

by:LeadCo
ID: 36915291
Thanks.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question