I have 3 ASP.MVC App on one Server (hostname), hence, I have 3 different AppPool. Also, I have one SQL Server DB and each of application using it.
My question: Is it possible kill only these processes derived from one ASP.MVC App?
Asked
Active
Viewed 48 times
1 Answers
1
This might help you safely determine the SPIDs to kill:
select spid, program_name
from sys.sysprocesses
order by program_name
T.H.
- 819
- 5
- 4
-
Do you can show the user name from each spid in this query? – Edgard Leal Feb 02 '17 at 11:47
-
@EdgardLeal Yes, sys.sysprocesses has a Loginname column which can be used to determine the database user. – T.H. Feb 02 '17 at 14:26
-
Good. I think this can answer the question. – Edgard Leal Feb 02 '17 at 18:12