June 11, 2011 at 11:32 am
In sql server management studio, if right click a database - reports -standard reports -disk usage,
for data/log autogrow events, I can see history of when the log files autogrowed.
Last night I got an alert of the log file of a database is 96% full, but in this morning I check it is only 1% full, so I guess it is autogrowed, but I cannot see there is a history in the report that shows the log file growed last night, why is that?
June 11, 2011 at 12:20 pm
Going from 90% full to 1% full would have to be a huge growth, depending on the size of the log file.
More likely, the transaction log was backed up instead (perhaps just before a growth).
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 11, 2011 at 1:03 pm
There is no Right-Click report to show you the history.
There was probably a Log Backup between the alert and the time you ran the report.
You could setup a job to log Transaction Log size, % used and other DMV/DMF info into a history table and go view later.
You should also check to see if there is a job shrink the Transaction Log file, because if you see it growing in the Disk Usage report, there might be an issue with it shrinking. There is no auto shrink on the Transaction Log by itself.
Check the database to see if Auto Shrink is turned on. You might want to turn Auto Shrink off on the database.
Thomas
Thomas LeBlanc, MVP Data Platform Consultant
June 11, 2011 at 1:40 pm
Thank you all, it is a transaction log backup make it to smaller percentage of usage.
we have autoshrink off, and no shrink db jobs.
June 12, 2011 at 10:05 pm
Backing up the TLog is suppose get rida of the Usage if appropriately times.
Thomas
Thomas LeBlanc, MVP Data Platform Consultant
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply