I'm running SQLServer 2000. I am in the process of looking over our current filegroups and providing reports based on file size increases.
One thing I'd like to know is when (date and time) a filegroup last "auto-grew". Is there a way to know when this occurs?
thanks,
Jason
SQL Profiler, Events, Database...
Data File Auto Grow
Data File Auto Shrink
Log File Auto Grow
Log File Auto Shrink
|||Derek,
Thanks for the info. I should have re-worded my question I think:
Is there a way to know when the date/time a filegroup last auto-resized? Let's say it auto-resized last friday, is this timestamp stored somewhere? Profiler would tell me only if I was running it at the time of the resize.
I'm trying to correlate the time of an error with the last time a large filegroup resized.
thanks
Jason
|||No. In general if you do not trace database activity it is lost. SQL Server has a builtin error log but it collects exceptions.|||Thanks for the info. Appreciate the help.
Jason
