February 3, 2011 at 9:37 am
I was told to check and to set up on production server a maintance plan and the only thing this server has reorginize index on tabeles and views on compact large object for every day, what would be the purpose of doing that? I usually don't set up on my maintance plans reorginizing indexes at all.
This is what I do usually:
1.CheckDatabaseIntegrity
2.Update Statistics
3.Rebulding Index
4.Cleanup History
5.Maintance Cleanup Task
February 3, 2011 at 1:28 pm
The purpose? It increases performance.
__________________________
Allzu viel ist ungesund...
February 3, 2011 at 1:33 pm
I think most people prefer to rebuild/reorg based on specific needs of tables and indexes, not all tables and indexes automatically in a maint plan.
February 3, 2011 at 1:56 pm
Krasavita (2/3/2011)
I was told to check and to set up on production server a maintance plan and the only thing this server has reorginize index on tabeles and views on compact large object for every day, what would be the purpose of doing that? I usually don't set up on my maintance plans reorginizing indexes at all.This is what I do usually:
1.CheckDatabaseIntegrity
2.Update Statistics
3.Rebulding Index
4.Cleanup History
5.Maintance Cleanup Task
No backups in here?
Note, rebuilding an index will update the statistics for that index. So, you are essentially updating the statistics twice for those tables which is just wasting resources and time.
If your rebuild index task is set to rebuild all indexes, I would put that before the update statistics and set the update statistics to only update column statistics.
I also wouldn't put the cleanup history portion in the same plan. I create a separate plan for that and run it every day at 12:01am.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 4, 2011 at 7:14 am
They running rebulding index everyday, why do you need to do rebulding index everuday?
Thank you
February 4, 2011 at 7:52 am
you mentioned earlier, they reorganize index daily, but thats also not required on a daily basis.
What i do is i reorganize indexes only if the fragmentation level of indexes is between 30-50, otherwise
I rebuild all my indexes.
You can run reorg/rebuild weekly in a maintenance plan with checking database integrity, reorg indexes, update stats, again checking database integrity.
If u r running rebuild indexes, then you dont need update stats..
Also, I suppose you have different maintenance plans for backing up your user and system databases.
Also make sure that this maintenance plan doesnt coincide with the backup time.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply