11 2019 档案
摘要：SELECT wait_type , SUM(wait_time_ms / 1000) AS [wait_time_s] FROM sys.dm_os_wait_stats DOWS WHERE wait_type NOT IN ( 'SLEEP_TASK', 'BROKER_TASK_STOP', 'SQLTRACE_BUFFER_FLUSH', 'CLR_AUTO_EVENT', 'CLR_M
阅读全文
摘要：--创建对某个表的操作情况的跟踪 --注意修改路径 和 @value -- Create a Queue declare @rootPath NVARCHAR(200) = 'D:\inout\TraceLog\' declare @path nvarchar(500) declare @rc int declare @TraceID int declare @maxfilesize bigint
阅读全文
