摘要:
----------------------------------------------------------------------------------------------------------- --查询数据库中当前阻塞及被阻塞的程序-- Code for dbo.dba_BlockTracerCREATE Function [dbo].[dba_GetSQLForSpid]( @spid SMALLINT)RETURNS NVARCHAR(4000)/*-------------------------------------------------Purpose: .. 阅读全文
摘要:
----------------------------------------------------------------------------------------------------------- --查询出当前数据库正在执行的程序-- Code for dbo.dba_WhatSQLIsExecutingCREATE PROC [dbo].[dba_WhatSQLIsExecuting]AS/*----------------------------------------------------------------------Purpose: Shows what i 阅读全文
摘要:
----------------------------------------------------------------------------------------------------------- -- Code for dbo.dba_WhatSQLIsExecutingCREATE PROC [dbo].[dba_WhatSQLIsExecuting]AS/*---------------------------------------------------------------------- Purpose: Shows what individual SQL st 阅读全文