Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sree25
Starting Member
5 Posts |
 Posted - 2015-03-31 : 20:45:52
|
| Whenever my query takes long time to run my DBA calls me up and says he is going to kill job because its slowing down other process.. My question is1. how does my DBA know which user is taking more resources?2. how to kill my sql statement ..( I heard even if i click red button on sql server query runs at background) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2015-04-01 : 08:57:36
|
| 1 EXEC SP_WHO2 KILL SPIDProvided you have enough permission to do soMadhivananFailing to plan is Planning to fail |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
How do you know which user is running query