-- 查找被阻塞進程 Select * from master..sysprocesses where dbid = 9 and blocked > 0 -- 查找阻塞頭進程 select * from master..sysprocesses p where dbid = 9 and blocked <= 0 and exists ( select 1 from master..sysprocesses where blocked = p.spid) -- 查找等待時間長的進程 Select * from master..sysprocesses where dbid = 9 order by waittime desc -- 進程正在執行的 SQL 語句 dbcc inputbuffer( 61 ); -- 中止進程 -- kill 177 -- 定位消耗cpu,io 最高的進程信息 select spid,dbid,cpu,physical_io,login_time,last_batch,status, hostname,program_name,hostprocess,cmd,nt_username from sysprocesses where dbid = 9 order by cpu,physical_io desc ; -- select OBJECT_NAME(1962490070) -- select db_id('CTI') -- IO消耗大的SQL SELECT TOP 20 [ Total IO ] = (qs.total_logical_reads + qs.total_logical_writes) , [ Average IO ] = (qs.total_logical_reads + qs.total_logical_writes) / qs.execution_count , qs.execution_count , SUBSTRING (qt. text ,(qs.statement_start_offset / 2 ) + 1 , (( CASE WHEN qs.statement_end_offset = - 1 THEN LEN ( CONVERT ( NVARCHAR ( MAX ), qt. text )) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset) / 2 ) + 1 ) AS [ Individual Query ] , qt. text AS [ Parent Query ] , DB_NAME (qt.dbid) AS DatabaseName , qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp ORDER BY [ Total IO ] DESC -- 連接數總數 SELECT COUNT (session_id) AS session_count FROM sys.dm_exec_sessions where database_id = 9 -- 各服務器連接數 select host_name ,login_name, count (session_id) FROM sys.dm_exec_sessions where database_id = 9 group by host_name , login_name order by host_name
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
