check data and log files grow and shrink log

DECLARE @logpath varchar(200)
SELECT @logpath =
SUBSTRING( [path], 1, LEN([path]) - PATINDEX('%\%', REVERSE([path]) ) )+'/log.trc' FROM sys.traces WHERE is_default = 1

SELECT TOP 100 HostName,
DatabaseID,
DatabaseName,
FileName,
CASE WHEN EventClass = 92 THEN 'Data File Auto Grow'
WHEN EventClass = 93 THEN 'Log File Auto Grow'
WHEN EventClass = 94 THEN 'Data File Auto Shrink'
WHEN EventClass = 95 THEN 'Log File Auto Shrink'
END AS EventClass,
StartTime,
EndTime
FROM fn_trace_gettable( @logpath, default )
WHERE EventClass Between 92 AND 95
ORDER BY StartTime DESC

-- 參考
-- ~楓花雪岳~ 檢查 SQL Server 是否觸發自動成長或自動壓縮