铁板神数条文大全:MS SQL Server:查询死锁进程
来源:百度文库 编辑:中财网 时间:2024/05/04 16:29:47
查询死锁进程的方法:
一条SQL2005里查询进程信息的SQL语句
虽然简单,估计大家都能写出来,不过比较实用,返回的信息包括进程阻塞信息、登录的相关信息、执行的SQL语句信息、进程所消耗的CPU、内存、I/O信息、以及客户端IP信息,具体如下:
with tb
as
(
select blocking_session_id,
session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a
CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)
),
tb1 as
(
select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as 'memory_usage(KB)',
total_scheduled_time,reads,writes,logical_reads
from tb a inner join master.sys.dm_exec_sessions b
on a.session_id=b.session_id
)
select a.*,connect_time,client_tcp_port,client_net_address
from tb1 a inner join master.sys.dm_exec_connections b on a.session_id=b.session_id
go
use master
go
select a.spid, a.blocked
from sysprocesses a, sysprocesses b
where a.blocked > 0 and
b.blocked > 0 and
a.spid != b.spid and
a.blocked = b.spid and
b.blocked = a.spid
go
一条SQL2005里查询进程信息的SQL语句
虽然简单,估计大家都能写出来,不过比较实用,返回的信息包括进程阻塞信息、登录的相关信息、执行的SQL语句信息、进程所消耗的CPU、内存、I/O信息、以及客户端IP信息,具体如下:
with tb
as
(
select blocking_session_id,
session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a
CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)
),
tb1 as
(
select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as 'memory_usage(KB)',
total_scheduled_time,reads,writes,logical_reads
from tb a inner join master.sys.dm_exec_sessions b
on a.session_id=b.session_id
)
select a.*,connect_time,client_tcp_port,client_net_address
from tb1 a inner join master.sys.dm_exec_connections b on a.session_id=b.session_id
go
use master
go
select a.spid, a.blocked
from sysprocesses a, sysprocesses b
where a.blocked > 0 and
b.blocked > 0 and
a.spid != b.spid and
a.blocked = b.spid and
b.blocked = a.spid
go
什么是MS SQL Server
SQL SERVER不等于MS SQL?
ms sql server数据库问题
MS sql server存储过程
MS SQL Server安装问题
sql server查询
sql-server查询问题
Sql Server 查询数值变量
sql server 的筛选查询
MS SQL Server 导入数据出错。
如何用ms sql server创建报表?
linux可以运行ms sql server吗
SQL Server 2000 MS DTC不可用
MS SQL server 2000的启动问题!!!!!!!!!!!
连接MS SQL Server 2000的问题
怎样在WIN2003 server下建立MS SQL server
sql server 的远程查询问题!
sql server 怎样做分类查询
如何用SQL SERVER做进销存的查询
求带外键约束的查询sql server语句
[急]请问SQL Server中查询语句!
SQL Server查询分析器连接不成功
请问MS-SQL SERVER的基本命令是什么?
MS SQL Server 2000安装对系统有什么要求?