February 24, 2010 at 4:58 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?
thanks
February 24, 2010 at 10:05 pm
What about other SQL instances? Don't you have Defrag maintenance job on other SQL servers? Use same script it doesn't matter, we use same script for all SQL servers including sharpoint SQL server.
EnjoY!
February 25, 2010 at 1:07 am
we use same script for all SQL servers including sharpoint SQL server
But MS says that it will NOT support if we use any other script to defrag indexes of share point databases other than the stored procedures given by MS
so, that's why I started to analyze these stored procs. For other sql server databases, I do use my own script to reorganize/rebuild indexes. But my concern is about Share point databases
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply