Is there a way to look at the complete history of growth and shrink events for the last weeks/months on SQL Server 2014 ? (New instances to support, noticed from the ticketing system that they have previous history of "log drive full", so would like to dig into the root cause before it happens again.)
This was useful: Identify File Growth Events . Came up with below query, but it doesn't show any of the "manual" log shrink events, just the "auto" events. Am I doing this the wrong way, any other place to look for past info ?
select te.name as event_name, tr.DatabaseName, tr.FileName, tr.IntegerData, tr.IntegerData2, tr.LoginName, tr.StartTime, tr.EndTime --select * from sys.fn_trace_gettable(convert(nvarchar(255),(select value from sys.fn_trace_getinfo(0) where property=2)), 0) tr inner join sys.trace_events te on tr.EventClass = te.trace_event_id where tr.EventClass in (93, 95) --can't identify any other EventClass to add here order by EndTime desc;