March 2, 2010 at 1:01 pm
Hi,
We have MOSS 2007 SP1 databases on SQL Server 2005 EE x64 with SP3. I would like to use the stored procedures mentioned in the below links to perform index defrag for Search & Content databases.
Link: 1
http://support.microsoft.com/default.aspx/kb/943345/en-us
Stored procedure:
proc_DefragmentIndices
Question: From the above link,
NOTE These steps will not be needed for WSS databases (content and config) after Windows SharePoint Services 3.0 SP2 if you are running Sql 2005.
We have MOSS 2007. So can we use this stored procedure to peform index defrag for Search & Content databases? please advice
link: 2
http://technet.microsoft.com/en-us/library/cc262731.aspx
PDF:
Database Maintenance for SharePoint.pdf
Stored procedure:
proc_DefragIndexes
Question:
1. Can we use this stored procedure to peform index defrag for Search & Content databases?
2. Which stored procedure is the best one to use peform index defrag for Search & Content databases? proc_DefragmentIndices or proc_DefragIndexes?
3. If we have SQL server 2005 EE with SP3, then MOSS 2007 will automatically take care of index defrag for content & config databases? We need to do NO INDEX DEFRAG if we have SQL server 2005 EE with SP3? Is that feature exist? where can I see that?
4. How you are doing the index defrag for Share point databases?
thanks for your help
March 3, 2010 at 9:23 pm
please advice me. I'm not clear on which direction I need go to defragment the share point database's indexes
please advice me how you guys are dealing with this
thanks
March 4, 2010 at 12:21 pm
You plan to defragment indexes in the database and the links provide tools to do that. However, you may want to be familiar with the indexes before working on them. Some basic research may be helpful to identify the root causes of fragmentation. The document of the second link provides a nice outline for index analysis. Here are some thoughts:
1) Discover the current index fragmentation status (methods described in the second link).
2) Determine the data growth pattern of each major index (that usually causes fragmentation).
3) Review the fill factor of each major index to see if this parameter is proper for the data growth pattern,
4) Change index fill factor (usually leave more free space for data growth) as needed.
5) Adapt or develop a stored procedure to dynamically defragment indexes (daily or weekly).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply