Database Statistics Time Job vs. the Defragmentation stored procedure?
If you read this Microsoft White Paper Database maintenance for Office SharePoint Server 2007, on page 10 in the section Run the Database Statistics timer job, it says, "If you have installed Windows SharePoint Services 3.0 with SP2, the following occurs:" "If you are running SQL Server 2008 or SQL Server 2005, the job rebuilds all indexes in the content databases every time that it runs". But then in the next section Run the Defragmentation stored procedure it says: "To reduce the level of index fragmentation, run the following SQL Server stored procedure..." "...you can schedule the stored procedure to be run daily, weekly, or monthly depending..." If you rebuild all indexes every night, why would you need to run a stored procedure that also rebuilds your indexes weekly or monthly or whatever?
May 25th, 2011 2:18pm

Hi, Thanks to share your post. For the issue, in my mind, to run a stored procedure means that set the decline to cover the past indexes. This could improve the availability of storing space. Hope this could help you! Leo
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2011 3:41am

Previously, the sole responsibility of the Database Statistics job was to update query optimization statistics for content databases. As of SP2, the job also rebuilds content database indexes every time it runs. This automatic index rebuild helps to stop fragmentation and maintain database performance We have taken the decision to disable the sharepoint job as our DBA written job is more selective on what is processed and has been successfully running for some time I think the job in SP2 was introduced to assist in environments that don't have dedicated DBAs maintaining the DBs
May 27th, 2011 11:52am

We have taken the decision to disable the sharepoint job as our DBA written job is more selective on what is processed and has been successfully running for some time Are you saying you use the Defragmentation Stored Procedure that Microsoft supplies in its white paper? (link in my original question) And whatever it is that you use to defrag your indexes -- how do you determine how often to run it? Microsoft's recommendation in that white paper is "It depends''. :(
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2011 3:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics