sqlserver数据库性能分析定位经典语句
发布时间：2020-12-12 14:27:46 所属栏目：MsSql教程 来源：网络整理
导读：--每秒死锁数量 SELECT??* FROM????sys.dm_os_performance_counters WHERE???counter_name?LIKE?'Number?of?Deadlocksc%'; --查询当前阻塞 WITH????CTE_SID?(?BSID,?SID,?sql_handle?) ??????????AS?(?SELECT???blocking_session_id?,??????????????????????
|
--每秒死锁数量 SELECT??* FROM????sys.dm_os_performance_counters WHERE???counter_name?LIKE?'Number?of?Deadlocksc%'; --查询当前阻塞 WITH????CTE_SID?(?BSID,?SID,?sql_handle?) ??????????AS?(?SELECT???blocking_session_id?,????????????????????????session_id?,????????????????????????sql_handle ???????????????FROM?????sys.dm_exec_requests ???????????????WHERE????blocking_session_id?<>?0 ???????????????UNION?ALL ???????????????SELECT???A.blocking_session_id?,????????????????????????A.session_id?,????????????????????????A.sql_handle ???????????????FROM?????sys.dm_exec_requests?A ????????????????????????JOIN?CTE_SID?B?ON?A.SESSION_ID?=?B.BSID ?????????????) ????SELECT??C.BSID?,????????????C.SID?,????????????S.login_name?,????????????S.host_name?,????????????S.status?,????????????S.cpu_time?,????????????S.memory_usage?,????????????S.last_request_start_time?,????????????S.last_request_end_time?,????????????S.logical_reads?,????????????S.row_count?,????????????q.text ????FROM????CTE_SID?C? ????????????JOIN?sys.dm_exec_sessions?S?ON?C.sid?=?s.session_id ????????????CROSS?APPLY?sys.dm_exec_sql_text(C.sql_handle)?Q ????ORDER?BY?sid
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |