Maintenance Plans – I don’t think they are doing it right

Are they rebuilding all their indexes and then updating stats at 20%?
Or, perhaps, rebuilding all indexes where fragmentation is greater than 50%, reorganizing all indexes where fragmentation is greater than 20% and not updating any statistics at all?
Or, my personal favorite, autogrow in 1MB increments followed by a weekly shrink. OH YEAH! http://youtu.be/OG_6CopW9GQ”

Objectively point out where the maintenance plan does not line up with this link: http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog

Let the data do the talking. If they still circular file your recommendations, then you have to do a risk assessment on whether it is worth having the DBAs hate you when you go over their heads.

I don't know how to answer that question

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s