어린왕자와 여우

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, ...