Maintenaince Plan Wizard help!

Question

Maintenaince Plan Wizard help!

mastersql

SSC Eights!

Points: 815
More actions
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

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

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

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

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

mastersql SSC Eights! Points: 815 More actions · Answer 2

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

Luis Cazares SSC Guru Points: 183698 More actions · Answer 3

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

mastersql SSC Eights! Points: 815 More actions · Answer 4

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

mastersql SSC Eights! Points: 815 More actions · Answer 5

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