MOSS 2007 SP2 DB index maintanance

Posted by Mike H on Server Fault See other posts from Server Fault or by Mike H
Published on 2010-07-02T06:38:32Z Indexed on 2011/06/22 16:24 UTC
Read the original article Hit count: 238

Filed under:

sql-server

|

sharepoint-2007

I've read in the "About Service Pack 2 for SharePoint Products and Technologies" paper that SP2 includes an update for the Update Statistics Timer Job that causes SharePoint to run SQL Server's online index rebuild feature (p.4).

I'm uncertain of the terminology here but is this the rebuild that SQL Server uses for minor fragmentation (up to around 40%) and leaves the DB online? I'm also guessing that this will therefore not rebuild severely fragmented indexes as I think this requires the DB to come offline. Can someone please confirm my belief here?

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about sharepoint-2007

Les alertes dans SharePoint 2007 - Comment SharePoint 2007 g?re les User Alerts

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Une des fonctionnalit?s de base de SharePoint, aussi bien dans Windows SharePoint Services (WSS) que dans Microsoft Office SharePoint Server (MOSS), est la capacit? de d?finir des alertes. Nous verrons donc dans cet article ce qu'est une alerte, comment cela fonctionne plus en d?tail et comment effectuer… >>> More
RSS Comment Feeds from SharePoint 2007 Blog

as seen on Super User - Search for 'Super User'
Is there any way to subscribe to RSS comment feeds from a SharePoint 2007 blog? Or to include comments in the standard RSS feed? Some easy way to be notified or new comments to a thread via RSS? >>> More
SharePoint 2007 - Current Timer jobs?

as seen on Stack Overflow - Search for 'Stack Overflow'
How to find the currently running SharePoint 2007 Timer jobs using STSADM? >>> More
The relative effort of SharePoint 2010 vs. 2007

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
SharePoint 2007 was the best demo-ware ever. It’s like going to the pet store and seeing a great dog that does backflips all kinds of tricks – and it really is a smart dog and it does all those tricks – but when you get it home you realize that what you need is a dog that gets the paper. SharePoint… >>> More
SharePoint 2010 Workflow for Multiple Items (Architecture)

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had the question today of whether SharePoint 2010 supports workflow on multiple items, since Groove's workflow apparently supported multiple items and that model disappeared when Groove Workspaces were amalgamated into SharePoint Sites and SharePoint Workspace (the client utility). It's a great… >>> More