Post reply

Maintenaince Plan Wizard help!

  • December 3, 2015 at 8:10 am

    #305918

    Hi

    I've upgraded a server from SQL 2005 to SQL 2008 but the database runs slower when running certain Stored Procedures especially against records which contain more data than others.

    Its been suggested that I run a basic reindex to see if this resolves.

    Can someone take a log at the screens-hot and advise if this will remove any data from my database - if so then this isn't the right thing to do.

    Thanks James

    p.s I will now attach a screen-shot if I can as not done that before using this Forum

  • December 3, 2015 at 9:11 am

    #1843813

    It won't delete data, but you really want to remove the Shrink Database option from your maintenance plan.

    For more information, read this (and the links in that article): http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • December 3, 2015 at 9:24 am

    #1843817

    Hi Luis

    I've now removed the Shrink database part of the plan.

    For a stand-alone server serving 35 users, how often would you recommend that this is run?

    Cheers

    James

  • December 3, 2015 at 10:05 am

    #1843836

    It's not exactly about the users, but about how the data changes.

    Ideally, you'll do it daily. However, you might not need to have index/statistics maintenance tasks daily and you can set them to run weekly. DB integrity should be run daily, unless the maintenance window won't allow it. The Cleanup task has other considerations to schedule.

    For detailed information, I suggest that you check this book: http://www.sqlservercentral.com/articles/books/68380/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • December 3, 2015 at 10:38 am

    #1843845

    Hi Luis

    This is a real eye-opener. Thanks for recommending this book - I'm reading it already. Can't wait to figure it all out better 🙂

    Kind Regards

    James

  • December 5, 2015 at 8:50 am

    #1844210

    Hi Luis

    I've hit a snag. I've set a customers system to rebuild all their databases this weekend. I'm just a bit worried that the reindexing will still be running on Monday. I've this idea from Brad's book but not sure if I'll be able to cancel the rebuild job correctly if I need to. I know I should be able to cancel the job within SQL Job Agent but not sure if the option is within Maintenance Planner if you could advise please.

    Kind Regards

    James

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

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