Search
InstantDoc ID
GO

Browse By: Author | Issue

May 22, 2009 09:22 PM

Rebuild Indexes Online

Customize this online index job for your SQL Server environment
Rating: (0)
Brian Smyk
SQL Server Magazine
InstantDoc ID #101777

Executive Summary:
You can use this job to rebuild your indexes online to avoid the blocking caused by reorganizing indexes and the table locking caused by offline index rebuilds. You can customize this job for your environment by enabling and disabling various steps and parameters. Learn how to implement this job and what each step in the job does.


Recent...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

If you dont have time to manage defragmentation check out this video.
http://www.youtube.com/watch?v=6KvAkdmcBqU

jeremy.gaige@idera.com 6/5/2009 3:19:07 PM

Ok, I just did the math again, and it is possible to reboot a machine within 43 minutes. My mistake.

MarcosGalvani 6/3/2009 12:56:33 PM

Ok, I just did the math again, and it is possible to reboot a machine within 43 minutes. My mistake.

MarcosGalvani 6/3/2009 12:56:33 PM

More over, how to acomplish a 99,999% uptime in SQL Server? At some point, you will have to aply a patch, or something else that will require a reboot. I doubt a reboot will take less then 0,001% or your month up-time.

MarcosGalvani 6/3/2009 11:26:12 AM

You are so lucky guy.
I applied it so very frequently accessed tables. Then, the cpu was too high could not the services long time after recompiie the sp, using these tables.
The sp uses 45 tables & 450GB size of total tables to inner & outer joins. and, called 350/sec... I used alread the keep fixedplan hint. But, it's not worth in this situations.

How to avoid this worst activation?

gmarketDBA 6/1/2009 12:19:14 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.