Sophos Database

Hello Teddy,

how many endpoints are managed by this installation? Unless you have many alerts 4GB should be sufficient for 10,000 endpoints or so. Please see Performance issues in Enterprise Console in relation to the Sophos database and transaction logs and Sophos SQL Best Practice Guide for Endpoint products (especially sections 5. and 4.).

Christian

HI,

If you're really struggling you could upgrade it to SQL Express 2008 R2, that has a 10GB limit but as Christian says, it can probably be solved as there is no need for it to be using that much space.

The first thing I would do is from SQL Server Management Studio, connect to the SQL instance and run the built in report (right click on the database) and choose : Reports - Standard Reports - Disk Usage by Table.

It may well turn out to be all firewall alerts for example.  PurgeDB.exe then might prove useful based on the outcome.
 

Jak

hi,

It is sufficient for 10,000 users, however. how come that our db reached 4GB of data. Please see the link below.

http://www.ge.tt/#!/37re0aF/v/0

Regards,

tedz

Hello Teddy,

this doesn't look quite right - the log is rather small. Please run the report as Jak's suggested, it should give you an idea how much space is really in use (and therefore needed). Review the settings first as per the articles. Once you are sure they are correct compress the database (this is also covered in the articles and related links).

Christian