Hi,
I just ran a performance analysis on one of our production databases, and it indicated that some of the logfiles are growing too much and too often.
I would like to verify this myself. What is the best way to track what's going on with the logfiles... that is, can I view how often the log files are growing, and what time of day this is occurring? Is there a history of this somewhere?
And how can I determine the optimal size of the logfile?
I am kind of confused as to how to go about this.
Thanks
I just ran a performance analysis on one of our production databases, and it indicated that some of the logfiles are growing too much and too often.
I would like to verify this myself. What is the best way to track what's going on with the logfiles... that is, can I view how often the log files are growing, and what time of day this is occurring? Is there a history of this somewhere?
And how can I determine the optimal size of the logfile?
I am kind of confused as to how to go about this.
Thanks