Performance issues in Enterprise Console in relation to the Sophos database and transaction logs

  • Artikel-ID: 110258
  • Aktualisiert: 12 Aug 2014


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 5.0.0
Enterprise Console 4.7.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.

What to do

  • Download and install Microsoft SQL Server Management Studio Express
  • Make a backup of the SOPHOS database and transaction log.
  • Change the recovery model to 'simple'.
  • Shrink the transaction log file.

1. Download and install Microsoft SQL Server Management Studio Express

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

2. Backup the SOPHOS Database

See article 110380. Changes will be made to the transaction log that should be accompanied by a full database backup.

3. Change the Recovery Model with Microsoft SQL Server Management Studio Express

How to: View or Change the Recovery Model of a Database (SQL Server Management Studio):
http://msdn.microsoft.com/en-us/library/ms189272.aspx

4. Shrink the transaction log file for the SOPHOS database

Important notes regarding the following link:

  • Step 5, 'Release unused space' is the safest and recommended option as it will shrink the log to the smallest size possible. Always use this option on your first attempt to reduce the transaction log.
  • Step 6, 'Reorganize pages before releasing unused space' should be used when 'Release unused space' has not made a substantial difference to the size and performance of the Sophos Console. The option in Step 7 'Reorganize files before releasing unused space' should be selected with this

How to: Shrink a File (SQL Server Management Studio):
http://technet.microsoft.com/en-us/library/ms190757.aspx.

Further information

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

 
Wenn Sie weitere Informationen oder Unterstützung benötigen, wenden Sie sich bitte an den technischen Support.

Artikel bewerten

Ungenügend Hervorragend

Anmerkungen