SQL Server Kill Process

Posted on December 22, 2009 by Derek Dieter
2
2

« Best SQL Server Pagination Method

Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF. »

The kill command is used against a SPID. (Server Process ID). This command is typically used because something is misbehaving. In order to use the Kill command, simply type the word “kill” followed by a space and then the number of the Server Process ID to kill.

[cc lang=”sql”]
— Kill Server process ID 98
kill 98
[/cc]

The kill command has three parameters. Two of which I have no idea what they mean:

KILL { session ID | UOW } [ WITH STATUSONLY ]

Post a comment

2 comments

leo 07 Aug 2014 at 5:55 pm

‘Two of which I have no idea what they mean’ is funny, thanks good article.

Reply to this comment

Leonardo Raygoza 06 Apr 2011 at 2:17 pm

good article I think this blog is going to be one of my favorites 🙂

Reply to this comment

Featured Articles

How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.

Site Author

Thanks for visiting!

Resources