The responsiveness of Sophos Enterprise Console has slowed down significantly when switching views, editing policies, and scrolling. This may occur after an upgrade of the console.
The SOPHOS database SQL transaction log file may have increased in size due to a degradation in tasks performed in the console.
This article describes the steps to resolve these performance issues.
The following sections are covered:
Sophos product and version Enterprise Console 4.7.0Enterprise Console 5.0.0
For SQL Server 2005 Express Edition: http://www.microsoft.com/download/en/details.aspx?id=8961
For SQL Server 2008 Express Edition: http://www.microsoft.com/download/en/details.aspx?id=7593
See, Using backupdb.bat and restoredb.bat: How to back up and restore the Sophos databases.
See, View or Change the Recovery Model of a Database (SQL Server).
See, TechNet: Shrink a File
If you've spotted an error or would like to provide feedback on this article, please use the section below to rate and comment on the article. This is invaluable to us to ensure that we continually strive to give our customers the best information possible.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.