数据库资源
文章平均质量分 85
sound02
这个作者很懒,什么都没留下…
展开
-
查看数据库资源的消耗情况
with tb as ( 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 · 1530 阅读 · 0 评论 -
查看表某个字段被哪些存储过程引用了
SELECT sm.object_id, OBJECT_NAME(sm.object_id), sm.definition FROM sys.sql_modules AS sm JOIN sys.objects AS o ON sm.object_id = o.object_id AND o.type='p' AND definition LIKE '%DataUnitId%'转载 2012-11-28 17:28:32 · 1520 阅读 · 0 评论 -
查询数据库死锁
USE [master] GO /****** Object: StoredProcedure [dbo].[sp_Locks] Script Date: 11/28/2012 17:24:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_原创 2012-11-28 17:22:53 · 551 阅读 · 0 评论