troubleshooting Question

can't kill a SQL spid

Avatar of marrowyung
marrowyung asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
40 Comments1 Solution11745 ViewsLast Modified:
Dear all,

Right now I ran the SQL monitor.exe from :

http://sqltouch.blogspot.ca/2013/05/sql-performance-monitoring-tool-simple.html

but when it can't connect to a SQL instance it will left some code in the tempDB of the SQL server it failed to connect:

EXEC shb_generate_waitstats    /************************************************************  ** category wait stats  ************************************************************/  USE tempdb

and when i kill it, it seems ok, and if I kill it again, it shows:

"SPID xx: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds."

it just keep hanging around there and we have 4 x connections like this now..

how can I force to kill it without restarting the SQL service?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 40 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 40 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros