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?
dwiseman3Asked:
Who is Participating?
 
rickchildConnect With a Mentor Commented:
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
 
rickchildCommented:
From Management -> Activity Monitor you can kill queries.

You can also see locks, and CPU & IO usage etc.
0
All Courses

From novice to tech pro — start learning today.