查询死锁和索引

--查询死锁（存过上一篇文章）
exec master..sp_who_lock
exec master..sp_who_run
--连接情况
Select * from sys.dm_exec_connections
-- 有多少会话
select session_id,status,login_name,login_time,* from sys.dm_exec_sessions   

select DB_NAME(t1.database_id) dbname,login_name,t1.session_id,
t1.request_id,t2.status,t1.start_time, host_name
from sys.dm_exec_requests t1
inner join sys.dm_exec_sessions t2
on t1.session_id=t2.session_id

 

---查询索引情况
DBCC   SHOWCONTIG(WFPUSER_T0301)

--重建索引
DBCC DBREINDEX (WFPUSER_T0301, '', 70) WITH NO_INFOMSGS