rebuild index in share point

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » rebuild index in share point

rebuild index in share point

Rate Topic

Display Mode

Topic Options

Author

Message

ramyours2003

Posted Thursday, November 08, 2012 6:18 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 1:37 AM
Points: 358, Visits: 1,485

is it possible to rebuild indexes in share point server?

Post #1382454

bleroy

Posted Thursday, November 08, 2012 6:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:59 PM
Points: 137, Visits: 546

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

tafountain

Posted Thursday, November 08, 2012 7:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:59 AM
Points: 104, Visits: 333

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

hs24

Posted Thursday, November 08, 2012 7:24 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 7:29 AM
Points: 765, Visits: 328

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

anthony.green

Posted Thursday, November 08, 2012 7:26 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

hs24 (11/8/2012)

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

Joie Andrew

Posted Thursday, November 08, 2012 7:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 548, Visits: 1,026

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 »

Permissions