Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log file growing too much

Status
Not open for further replies.

icemel

MIS
Oct 17, 2005
463
US
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
 
Please try the following undocummneted command:

Code:
 dbcc sqlperf(logspace)

you can insert the results into a table on a regular basis and investigate them automatically.
The size of your transaction log depends on the size of your transactions between database/transaction log backups (depend in which recovery mode you are).
You decide the maximal size, and backup whenever you need to truncate the transaction log.

M.

"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M. [hourglass]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top