August 4, 2011 at 9:10 am
Hi
I'm finding at the moment that I have to rebuild all our indexes around every six weeks or so to keep the performance at an acceptable level. Is this normal?
Thanks
Matt
August 4, 2011 at 9:29 am
Not really.
Check this out for my implantation here : http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx
August 4, 2011 at 9:32 am
It all depends of the rate of change within the tables. A good idea is set up a weekly schedule to go through find the fragmentation of the tables and rebuild, reorg or ignore them depending on the level of fragmentation.
You'll find an excellent script here http://ola.hallengren.com/ which might help you.
August 4, 2011 at 11:50 am
Rebuilding every six weeks or so might be OK. The real question is, how often are your statistics maintained? Those age much quicker than indexes fragment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply