用户在Row lock上发生阻塞的频率代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】用户在Row lock上发生阻塞的频率

作者:dezai / 发布于2014/2/8/ 725

查询当前数据库上所有用户表格在Row lock上发生阻塞的频率

-- 查询当前数据库上所有用户表格在Row lock上发生阻塞的频率
declare @dbid int
select @dbid = db_id()
Select dbid=database_id, objectname=object_name(s.object_id),
indexname=i.name, i.index_id  
--, partition_number, row_lock_count,
row_lock_wait_count, [block %]=cast (100.0 * row_lock_wait_count / (1 + row_lock_count)
as numeric(15,2)), row_lock_wait_in_ms,
[avg row lock waits in ms]=cast (1.0 * row_lock_wait_in_ms / (1 + row_lock_wait_count)
as numeric(15,2))
from sys.dm_db_index_operational_stats (@dbid, NULL, NULL, NULL) s, 
 sys.indexes i where objectproperty(s.object_id,'IsUserTable') = 1
 and i.object_id = s.object_id and i.index_id = s.index_id
 order
 by row_lock_wait_count desc

试试其它关键字

　Row　　lock　

同语言下

可能有用的

dezai贡献的其它代码(1065)