• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1126
  • Last Modified:

kill a query in management studio

Is there a better way to kill a runaway query being executed in the Management Studio than just exiting out of it?
0
dwiseman3
Asked:
dwiseman3
  • 2
1 Solution
 
rickchildCommented:
From Management -> Activity Monitor you can kill queries.

You can also see locks, and CPU & IO usage etc.
0
 
rickchildCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now