Sql Server中通过sql命令获得cpu占用及产生锁的sql
获得SQLSERVER中产生锁的SQL语句
SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN ⑴ THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2) + 1) as statement_text
FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st where qs.sql_handle in (select distinct sql_handle from sys.dm_exec_requests where session_id in (SELECT request_session_id as Spid
FROM sys.dm_tran_locks l
LEFT JOIN sys.partitions p
ON l.resource_associated_entity_id = p.hobt_id
LEFT JOIN sys.indexes i
ON p.object_id = i.object_id
AND p.index_id = i.index_id
LEFT JOIN sys.objects o
ON p.object_id = o.object_id
LEFT JOIN sys.schemas s
ON o.schema_id = s.schema_id
LEFT JOIN sys.objects o2
ON l.resource_associated_entity_id = o2.object_id
LEFT JOIN sys.schemas s2
ON o2.schema_id = s2.schema_id
LEFT JOIN sys.databases db
ON l.resource_database_id = db.database_id
WHERE resource_database_id = DB_ID() and request_mode in (‘X’)
))
查询 某个时间点的,所有履行中的sql语句的CPU占用时间(倒排序)
查询 区别sql语句产生阻塞的情况(主要是由于锁产生的等待)
到此这篇关于Sql Server中通过sql命令获得cpu占用及产生锁的sql的文章就介绍到这了,更多相关cpu占用及产生锁内容请搜索之前的文章或继续浏览下面的相关文章希望大家以后多多支持!
文章来源:丸子建站
文章标题:Sql Server中通过sql命令获得cpu占用及产生锁的sql
https://www.wanzijz.com/view/61786.html