Prev: on line documentation for SQLSERVER 2005
Next: Change log shipping to mirroring w/o db backup?
From: Iter on 27 May 2010 17:17
Hi Guy,
Do you know any way to collect the data and log file growth trend in past in
sql 2005? Any DMV records this? Thanks
From: Andrew J. Kelly on 27 May 2010 23:30
The default trace files track this but they only track so many events before
the trace file is over written with a new one. You can usually find the
trace files in the instance folder under the LOG folder. Use
fn_trace_gettable() to view them and look for autogrow events.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Iter" <Iter(a)discussions.microsoft.com> wrote in message
news:B310150D-AD9C-42AF-82C7-051E8F6D13B7(a)microsoft.com...
> Hi Guy,
> Do you know any way to collect the data and log file growth trend in past
> in
> sql 2005? Any DMV records this? Thanks

From: Uri Dimant on 30 May 2010 04:08
Iter
You can create a simple table and keep the log/data file size in per day,
and then compare them late on


"Iter" <Iter(a)discussions.microsoft.com> wrote in message
news:B310150D-AD9C-42AF-82C7-051E8F6D13B7(a)microsoft.com...
> Hi Guy,
> Do you know any way to collect the data and log file growth trend in past
> in
> sql 2005? Any DMV records this? Thanks


 | 
Pages: 1
Prev: on line documentation for SQLSERVER 2005
Next: Change log shipping to mirroring w/o db backup?