SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Rebuild Indexs in Backup Strategy?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

132 Posts

Posted - 12/09/2012 :  18:18:43  Show Profile  Reply with Quote
Is rebuilding indexs in a backup maintenance plan adviseable?

Flowing Fount of Yak Knowledge

7174 Posts

Posted - 12/09/2012 :  20:09:17  Show Profile  Reply with Quote
Instead of rebuilding indexes I would check for fragmentation of indexes and then rebuild or reorganize.Check for Tara's script.
Go to Top of Page

Aged Yak Warrior

656 Posts

Posted - 12/17/2012 :  07:45:06  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
you need to monitor the index usage and then decide which indexes to be rebuilt.
rebuilding unused indexes will be a overhead.
Go to Top of Page

Posting Yak Master

203 Posts

Posted - 12/27/2012 :  05:10:16  Show Profile  Visit prett's Homepage  Reply with Quote
Please check this link: http://justgeeks.blogspot.in/2012/07/sql-server-maintenance-plan-best.html

The topic covers all useful steps for 'SQL Server Maintenance Plan'.
Go to Top of Page

Starting Member

8 Posts

Posted - 01/03/2013 :  07:39:59  Show Profile  Reply with Quote
For increase your server performance it is advisable but you need to distinguish between rebuilding the index & reorganising the indexes
refer the following discussion

Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 01/03/2013 :  08:29:12  Show Profile  Visit jackv's Homepage  Reply with Quote
Following on from ahmeds08 - consider implementing a regular review of index usage - which is all basic information available via DMVs. During these reviews - work ith the app owners to discuss and analyse indexes that have have large amount of writes with very little or no reads. Usually a hint that that the index is added to but then not read. Of course, make sure there is a good understanding of the queries - before you start dropping indexes.

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000