SQL maintenance index plan

If I'm rebuilding indexes weekly, how useful is the reorganize index and rebuild statistics plan?
barnescoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

plusone3055Commented:
The Help in Microsoft SQL Management Studio recommends reorganizing indexes that have fragmentation levels between 5% and 30% and rebuilding index that have fragmentation levels greater than 30%
0
x-menIT super heroCommented:
Rebuild - data is offline, no user access.
Reorg - data is online, but not as efficient as rebuild.

Statistics - help the Engine "guess" where to find the data.

info: http://blog.idera.com/sql-server/understanding-sql-server-statistics/
0
barnescoAuthor Commented:
Maybe I can narrow the question: I have hundreds of servers, so I won't monitor each one for "reorganizing indexes that have fragmentation levels between 5% and 30% and rebuilding index that have fragmentation levels greater than 30%."

I need a practical maintenance plan. I had read somewhere that if I rebuild indexes, reorganizing may not be necessary.

Will reorganizing indexes do something that a rebuild index won't do? Please don't answer the reorg does it on the leaf level, etc...I want to know if there is any benefit to doing all three jobs in a maintenance plan in one night.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

x-menIT super heroCommented:
no, if you "REBUILD" then you dont REORG.
0
Scott PletcherSenior DBACommented:
You will significantly hurt performance by recomputing statistics after a rebuild.

So you definitely don't want to do both for the same table(s).
0
PortletPaulfreelancerCommented:
>>Maybe I can narrow the question: I have hundreds of servers,

Many here will strongly recommend Ola Hallengrens Maintenance Solution and I think you would find it very useful.

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2012, 2011, and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.
Ola Hallengren
http://ola.hallengren.com/
recommended video:

also refer to
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28163719.html#a39265474
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
barnescoAuthor Commented:
PortletPaul's answser is definitely the best...provides a lot of info to follow up on. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.