Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

tempdb process- to cancel it

Posted on 2013-10-22
2
Medium Priority
?
352 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 1000 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 27

Accepted Solution

by:
Zberteoc earned 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

885 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