Post reply

msdb percent log used above 84%

  • 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?

  • June 15, 2004 at 12:20 pm

    #510517

    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

  • June 16, 2004 at 6:46 am

    #510624

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

  • June 22, 2004 at 6:32 am

    #511398

    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

  • June 22, 2004 at 6:47 am

    #511405

    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.

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

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