数据库资源
文章平均质量分 85
sound02
这个作者很懒,什么都没留下…
展开
-
查看数据库资源的消耗情况
with tbas(select --blocking_session_id,session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a With(nolock)CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle))原创 2012-11-28 17:17:21 · 1568 阅读 · 0 评论 -
查看表某个字段被哪些存储过程引用了
SELECT sm.object_id, OBJECT_NAME(sm.object_id), sm.definitionFROM sys.sql_modules AS smJOIN sys.objects AS o ON sm.object_id = o.object_idAND o.type='p' AND definition LIKE '%DataUnitId%'转载 2012-11-28 17:28:32 · 1558 阅读 · 0 评论 -
查询数据库死锁
USE [master]GO/****** Object: StoredProcedure [dbo].[sp_Locks] Script Date: 11/28/2012 17:24:55 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO ALTER PROCEDURE [dbo].[sp_原创 2012-11-28 17:22:53 · 564 阅读 · 0 评论