MSSQL에서 프로세스 리스트를 확인하고 Lock된 프로세스를 찾을 때 SP_WHO2를 사용한다.
MySQL에서는 Show ProcessList를 이용하여 Lock된 프로세스를 찾을 수 있으며, MSSQL과 마찬가지로 Kill (ProcessID)를 이용하여 프로세스의 제거가 가능하다.
The “SHOW PROCESSLIST;” equivalent inMicrosoft SQL-Server
We, MySQLusers, are spoiled. We don't realize it, until we have a Microsoft SQL-Serverin front of us. For MySQL, you have the following wonderful command.
mysql > SHOW PROCESSSLIST;
mysql > SHOW FULL PROCESSLIST;
That willlist all active connections, the query being executed and the state (waitingfor MySQL to process it, sending data, sleeping, ... ).
If you're inSQL Server Management Studio, you can do the following via "NewQuery".
sp_who;
Or
sp_who2;
Not quitethe same, but it also shows you the connected users and the state of thatconnection. "sp_who;" will list all users, and "sp_who2;"will increase the output with things like CPU time, Disk IO, ...
참고 :
http://mattiasgeniar.be/2011/03/17/the-show-processlist-equivalent-in-microsoft-sql-server
