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