笔记50-徐 读取数据库的事务日志增长的trace文件

笔记50-徐 读取数据库的事务日志增长的trace文件

读取数据库的事务日志增长的trace文件 事件号是93 2013-6-13
DECLARE @tracefile NVARCHAR(MAX)
SET @tracefile = ( SELECT   LEFT([path],
                                 LEN([path]) - CHARINDEX('\', REVERSE([path]))) + '\log.trc'
                   FROM     sys.traces
                   WHERE    [is_default] = 1
                 )

SELECT TOP 100
        gt.[HostName], gt.[ServerName], gt.[DatabaseName], gt.[SPID],
        gt.[ObjectName], gt.[objecttype] [ObjectTypeID],
        sv.[subclass_name] [ObjectType], e.[category_id] [CategoryID],
        c.[Name] [Category], gt.[EventClass] [EventID], e.[Name] [EventName],
        gt.[LoginName], gt.[ApplicationName], gt.[StartTime], gt.[TextData]
FROM    FN_TRACE_GETTABLE(@tracefile, DEFAULT) gt
LEFT JOIN sys.trace_subclass_values sv ON gt.[eventclass] = sv.[trace_event_id] AND sv.[subclass_value] = gt.[objecttype]
INNER JOIN sys.trace_events e ON gt.[eventclass] = e.[trace_event_id]
INNER JOIN sys.trace_categories c ON e.[category_id] = c.[category_id]
WHERE   gt.[spid] > 50 AND e.[trace_event_id] = 93
ORDER BY [StartTime] DESC