Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2012-12-09 : 18:18:43
|
| Is rebuilding indexs in a backup maintenance plan adviseable? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-09 : 20:09:17
|
| Instead of rebuilding indexes I would check for fragmentation of indexes and then rebuild or reorganize.Check for Tara's script. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2012-12-17 : 07:45:06
|
| you need to monitor the index usage and then decide which indexes to be rebuilt.rebuilding unused indexes will be a overhead. |
|
|
|
prett
Posting Yak Master
212 Posts |
|
|
lopez
Starting Member
8 Posts |
Posted - 2013-01-03 : 07:39:59
|
| For increase your server performance it is advisable but you need to distinguish between rebuilding the index & reorganising the indexes refer the following discussion http://www.sqlservercentral.com/Forums/Topic1400334-1550-1.aspx?Update=1 |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-03 : 08:29:12
|
| 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--------------------http://www.sqlserver-dba.com |
|
|
|
EsmondNorton
Starting Member
5 Posts |
Posted - 2014-11-07 : 05:13:00
|
| Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.[url][/url] |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-11-07 : 11:48:05
|
| I dont see any benefit in including Index rebuild in backup plan. MP behaves little erratically when multiple steps are there. I would like you to create separate plan because backup is MUST task for every day while same is not the case with index rebuild. Only rebuild when index is fragmented and having sufficient page countHope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-11-11 : 01:43:55
|
| In a busy production environment - where there can be a requirement for a 24 x 7 requirement on database servers - the backup window can be narrow. Adding index rebuilds increases the window. Index management is a priority but is more flexible if you can break the tasks downJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Rebuild Indexs in Backup Strategy?