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

x
?
Solved

kill a query in management studio

Posted on 2008-06-10
2
Medium Priority
?
1,125 Views
Last Modified: 2012-06-22
Is there a better way to kill a runaway query being executed in the Management Studio than just exiting out of it?
0
Comment
Question by:dwiseman3
  • 2
2 Comments
 
LVL 13

Expert Comment

by:rickchild
ID: 21752691
From Management -> Activity Monitor you can kill queries.

You can also see locks, and CPU & IO usage etc.
0
 
LVL 13

Accepted Solution

by:
rickchild earned 1500 total points
ID: 21752700
If you look at the bottom right of the query window the query you are currently running will have a Process ID in brackets next to the logged in username.

You may notice other Process ID's in Activity Monitor though, which are related to the query you are running, such as SELECT INTO tempDB, this is temporary page storage used by your query.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

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.
In this article I will describe the Copy Database Wizard 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.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

782 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