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

user_190226 0
Viewed 50076

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)?

sql-server
3 Answers

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.

Tom_H_56966080

Try this

select * from master..sysprocesses
user_2109080
Related