How To KILL Process in SQL Sever.
In organization Application Team, M.I.S Team,
Development Team (Transactions, such as ASP.NET & JAVA dependent tool) send
bulk of SQL
statements to process the request.
After the job execution, the process ID stays in the server
and waits for next command with sleeping status. Since this process does not go
away, next job adds another process and eventually, the server is overloaded
with these processes and dies.
Follow the below steps:
Login to SQL server & connect to Particular Instance as
shown below: Connect (Click on) <server Name> server
Go
to “Management “option-à expand à click on activity monitor
