What's the equivalent of mysql's 'SHOW PROCESSLIST' on SQL server?

Question

We're in the process of converting to SQL Server from MySQL. I'm trying to figure out why a call to sqsh isn't returning and I suspect that there's some lock I don't know about.

How do you find out what's going on (preferably via the database connection)?

Answer 1

You can look into sp_who and sp_who2 to see if they give you what you need. Otherwise, SQL Profiler can often help with problem diagnoses.

Answer 2

Try this

select * from master..sysprocesses