You are here

Optimizing Microsoft SQL Server to work with Alfresco Content Services

Make sure you manage Microsoft SQL Server to optimise performance.
To ensure that your performance does not degrade, it is useful to carry out the following weekly maintenance operations on your SQL server, especially in repositories with a high transaction count and frequency:
  • Recompute statistics by running the command: EXEC sp_updatestats
  • Clear the buffers by running the command: DBCC DROPCLEANBUFFERS
  • Clear the cache by running the command: DBCC FREEPROCCACHE
  • Run an index fragmentation check and:
    • Rebuild anything that is >30% fragmented
    • Reorganize anything that is between 5 and 30% fragmented
    See Reorganize and Rebuild Indexes for more information.

Sending feedback to the Alfresco documentation team

You don't appear to have JavaScript enabled in your browser. With JavaScript enabled, you can provide feedback to us using our simple form. Here are some instructions on how to enable JavaScript in your web browser.