msdb percent log used above 84%

Question

msdb percent log used above 84%

dell1

SSC-Addicted

Points: 432
More actions
June 15, 2004 at 2:45 am

#162037

The SQL Server performance counter 'Percent Log Used' (instance 'msdb') of object 'SQLServeratabases' is now above the threshold of 70.00 (the current value is 84.00).
transaction log space allocated is 1mb, set to automatically grow by 5mb, and is restricted to 100mb. The data file is 77mb, set to automatically grow by 10mb, to size of 200mb. This may have occured because I shrunk the database.
What do I need to do to rectify this?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

hoo-t SSChampion Points: 12713 More actions · Answer 1

Based on what you said, I don't think you have a problem. The log should automatically grow by 5mb if necessary. BUT, you can eliminate the "percent log used" message by manually expanding the log to 2mb.

In Enterprise Manager, right click on the msdb database and select properties. Click the Transaction Log tab. Click in the "Space Allocated (MB)" column, then change the size to whatever you want.

Steve

duhonh SSC Enthusiast Points: 136 More actions · Answer 2

To reduce space used in a transaction log, you have to run "BACKUP TRANSACTION".

Alamir SSCertifiable Points: 6085 More actions · Answer 3

yes you have to make full bakup daily .. and bakup log every 1 hour .. so your transaction log does not grow by large amount.

Alamir Mohamed
Alamir_mohamed@yahoo.com

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 4

If you don't want to do log backups on the msdb database, and I don't know why you would, you can just set the recovery mode to simple. This will take care of the issue for you.

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.