January 23, 2010 at 9:02 pm
Hi,
Is there any script to keep track/moniotor the autogrowth of the .mdf and .ldf files???
Thank You!
January 24, 2010 at 10:24 am
There is a standard report available called Disk Usage that will show the autogrowth events since the last restart of SQL Server.
Those events are stored in the default trace.
With that said, you really need to look at monitoring the data space usage instead and manually grow the data files as needed. The transaction log files will grow as large as needed and stabilize at a certain size. The log files should not grow after that unless there is an unusual event that causes a larger than normal transaction to be performed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 24, 2010 at 10:04 pm
Thank You.
For that reason only, i asked you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply