Post reply

Maintenance Plan: View History takes long to open

  • December 14, 2012 at 2:09 am

    #271638

    Hello all,

    this is something that really annoys me: when I want to check my Maintenance Plan for backup history, it takes ages (i.e. > 10 min:-D) for all logs to get initialized.

    Can you tell me a handy way to get the entries faster without changing log file retention or else?

    Thank you very much

  • December 14, 2012 at 2:28 am

    #1568595

    Have you ever cleaned backup history?

    http://technet.microsoft.com/en-us/library/ms188328.aspx

    exec msdb.dbo.sp_delete_backuphistory 'oldest_date'

  • December 14, 2012 at 2:35 am

    #1568597

    Thank you for the fast reply,

    no, I didn't, because I don't want to touch the history, if it is possible.

    I know, it sounds like wanting to eat the cake and keeping it.

  • December 14, 2012 at 5:07 am

    #1568648

    Hmm, maybe that was a misunderstanding: I want to reduce the time it takes to see the History Log of the Maintenance Plan, has nothing to do with backups or anything.

  • December 14, 2012 at 7:09 am

    #1568685

    Arthur Kirchner (12/14/2012)

    Hmm, maybe that was a misunderstanding: I want to reduce the time it takes to see the History Log of the Maintenance Plan, has nothing to do with backups or anything.

    In that case, I hope you're doing "Point-in-Time" log backups on the MSDB database. 😉

    The GUI for these things is notoriously slow. You can help that a bit by using "filters" on the screen but I still find it slow if you never truncate the history.

    One thing you could do is write a proc to copy the history each night and then truncate the real history. That way you can eat the cake and keep it. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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