sqlserver 服务器监控

1.表锁

查看被锁的表：select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'

 

解锁：kill 204  -- spid

 

2.性能

Activity Monitor 查看最耗时的SQL语句

3. 查看数据库连接情况

 

　　select * from master.dbo.sysprocesses
　　exec sp_who
　　打开Activity Monitor 查看processes