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.
我们正在从MySQL转换到SQL Server。我试图弄清楚为什么对sqsh的调用没有返回，我怀疑有一些我不知道的锁。
How do you find out what's going on (preferably via the database connection)?
你怎么知道发生了什么（最好是通过数据库连接）？
3 个解决方案
#1
12
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.
您可以查看sp_who和sp_who2，看看它们是否能满足您的需求。否则，SQL事件探查器通常可以帮助解决问题。
#2
14
Try this
尝试这个
select * from master..sysprocesses
#3
1
SQL Server includes a few undocumented procs. sp_who2 lists all current processes connected to a SQL Server. It's located in the master database.
SQL Server包含一些未记录的过程。 sp_who2列出连接到SQL Server的所有当前进程。它位于master数据库中。
USE master;
GO
EXEC sp_who2;
GO
#1
12
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.
您可以查看sp_who和sp_who2，看看它们是否能满足您的需求。否则，SQL事件探查器通常可以帮助解决问题。
#2
14
Try this
尝试这个
select * from master..sysprocesses
#3
1
SQL Server includes a few undocumented procs. sp_who2 lists all current processes connected to a SQL Server. It's located in the master database.
SQL Server包含一些未记录的过程。 sp_who2列出连接到SQL Server的所有当前进程。它位于master数据库中。
USE master;
GO
EXEC sp_who2;
GO