SQLServer常用语句

SQLServer常用语句

时间:2021-08-23

本文章向大家介绍SQLServer常用语句，主要包括SQLServer常用语句使用实例、应用技巧、基本知识点总结和需要注意事项，具有一定的参考价值mssql 语句快速参考，需要的朋友可以参考一下。

查询当前数据库上执行的SQL语句

SELECT  'kill '+CONVERT(varchar(50),session_id),
  [session_id],
  [wait_time] AS '等待时间',
  [request_id],
  [start_time] AS '开始时间',
  [status] AS '状态',
  [command] AS '命令',
  dest.[text] AS 'sql语句', 
  DB_NAME([database_id]) AS '数据库名',
 [blocking_session_id] AS '正在阻塞其他会话的会话ID',
 [wait_type] AS '等待资源类型',
 [wait_resource] AS '等待的资源',
 [reads] AS '物理读次数',
 [writes] AS '写次数',
 [logical_reads] AS '逻辑读次数',
 [row_count] AS '返回结果行数'
 FROM sys.[dm_exec_requests] AS der 
 CROSS APPLY 
 sys.[dm_exec_sql_text](der.[sql_handle]) AS dest 
 WHERE [session_id]>50 
 ORDER BY [cpu_time] DESC
SELECT *
FROM   sys.[sysprocesses] AS syspro
       CROSS apply sys.Dm_exec_sql_text(syspro.sql_handle) AS t
WHERE  status != 'sleeping'
ORDER  BY physical_io DESC; 

--查看AlwaysON同步延迟时间
SELECT Datediff(s, last_redone_time, Getdate()) DelayTimeS
FROM   ( ( sys.availability_groups AS ag
           JOIN sys.availability_replicas AS ar
             ON ag.group_id = ar.group_id )
         JOIN sys.dm_hadr_availability_replica_states AS ar_state
           ON ar.replica_id = ar_state.replica_id )
       JOIN sys.dm_hadr_database_replica_states dr_state
         ON ag.group_id = dr_state.group_id
            AND dr_state.replica_id = ar_state.replica_id

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!