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://qa.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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply