Solved

tempdb process- to cancel it

Posted on 2013-10-22
2
332 Views
Last Modified: 2013-11-04
i was running something in tempdb for testing purpose by creating a temp table.. since it took more than a few seconds, i cancelled it.. but now after an hour, it is still saying 'canceling query...'.. how can i see what is going on? will this affect tempdb for other database usage?
0
Comment
Question by:25112
2 Comments
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 250 total points
ID: 39593181
About the only thing it should do is grow the size of the tempdb. If it it is really bad you need to find the process ID it was running under and kill it.
0
 
LVL 26

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 39594033
run an statement like:

exec sp_who2 active

and see which is the spid that is running that cancelling in tempdb. You can kill it with:

kill spid_number

you can also try to close that window from where you executed the query and say yes when the pop-up comes out. Cancelling usually rolls back the transactions although I am not sure why in tempdb would take so long. Maybe is just an UI issue and the process actually finished.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Detach & Attach 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.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now