The responsiveness of Sophos Enterprise Console has dropped significantly, switching views, editing policies and general scrolling are affected (to varying levels) by delays. This may have become noticeable following an upgrade of the console.
Sophos product and version Enterprise Console 4.7.0Enterprise Console 5.0.0
Technical Information The SOPHOS database SQL transaction log file may have increased significantly in size. This increase in size attributes to a degradation in performance when performing tasks in the console.
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 article 110380. Changes will be made to the transaction log that should be accompanied by a full database backup.
How to: View or Change the Recovery Model of a Database (SQL Server Management Studio): http://msdn.microsoft.com/en-us/library/ms189272.aspx
Important notes regarding the following link:
How to: Shrink a File (SQL Server Management Studio): http://technet.microsoft.com/en-us/library/ms190757.aspx.
Recover from a full transaction log in a SQL Server database: http://support.microsoft.com/kb/873235
Sophos SQL Best Practice Guide for Endpoint products http://www.sophos.com/support/knowledgebase/article/111353.html
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.