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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 6:57 AM
Points: 624, Visits: 2,371
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: Wednesday, March 11, 2015 4:10 AM
Points: 168, Visits: 702
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: Friday, November 28, 2014 8:49 AM
Points: 862, Visits: 374
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: Friday, May 8, 2015 1:48 AM
Points: 5,224, Visits: 5,136
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 4:53 PM
Points: 722, Visits: 1,482
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