Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

rebuild index in share point Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 6:18 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:00 AM
Points: 522, Visits: 2,012
is it possible to rebuild indexes in share point server?
Post #1382454
Posted Thursday, November 8, 2012 6:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:12 AM
Points: 165, Visits: 681
You will need to provide more details - SharePoint relies on a number of underlying databases, if you want to rebuild the indexes within those databases, you probably can ... but it may have an impact on your support agreement, you will to double check that just to be sure.

B
Post #1382458
Posted Thursday, November 8, 2012 7:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
You can - we do too. We found that the timer job that rebuilds indexes only rebuilds an index once it becomes 30% fragmented. It never does any sort of reorganization and this became an issue with some of the larger tables since 30% of the fragmentation would be 10s of GB.

If you Google "sharepoint index defrag" you'll get a lot of good information - including what steps you need to do to replace it with your own.
Post #1382483
Posted Thursday, November 8, 2012 7:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:15 AM
Points: 835, Visits: 358
There is a good post in relation this at
[url=http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx][/url]

and[url=http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx]
Post #1382488
Posted Thursday, November 8, 2012 7:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
hs24 (11/8/2012)
There is a good post in relation this at
[url=http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx][/url]

and[url=http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx]

For clickability

http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx
http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1382490
Posted Thursday, November 8, 2012 7:50 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 7:28 AM
Points: 709, Visits: 1,417
It also depends on other factors as well, such as:

SP version and service pack level
what databases

SharePoint included a procedure called defragmentIndices after SharePoint 2007 SP2.


Joie Andrew
"Since 1982"
Post #1382506
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse