Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 2479 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Suggested SQL maintenance tasks on SOPHOS45 DB?

RL

Hi,

We've been experiencing a few issues with SEC and I was advised that this could be due to the lack of maintenance tasks on our SOPHOS45 DB.

We have a remote SQL 2005 SP2 server (SQL Server 9.0.3080), with the SOPHOS45 database running alongside other DB's in the DEFAULT instance.

At the moment we don't perform any maintenance tasks on the SOPHOS45 DB and wondered what (if any) are the official Sophos documented recommendations for the SQL maintenance tasks on the SOPHOS45 DB, and if any what order these should be performed in?

If there are no official documented recommendations then what tasks does the community run and in what order, how frequent etc.

Numbers wise we are talking sub 200 clients. Currently our SOPHOS45  DB is 58Mb and the logs are 290MB. Both located on seperate drives, etc..

Thanks,

John

:4471


This thread was automatically locked due to age.
Parents
  • 0

    Hello John,

    the number of clients is small, sizes are reasonable - can't imagine it's the SOPHOS45 database. My SOPHOS4 database was on a local default instance alongside other more than moderately used databases and I had no issues with 2500+ clients. There are some articles on performance (search for database performance), the one about autoshrink and autoclose and the one about log size have been mentioned in this forum. But as I said - with the numbers you gave it's hard to imagine that the SOPHOS45 database is the cause.

    What are these "issues"? With 200 clients I don't expect that you run many remote consoles at the same time.

    Christian

    :4474
Reply
  • 0

    Hello John,

    the number of clients is small, sizes are reasonable - can't imagine it's the SOPHOS45 database. My SOPHOS4 database was on a local default instance alongside other more than moderately used databases and I had no issues with 2500+ clients. There are some articles on performance (search for database performance), the one about autoshrink and autoclose and the one about log size have been mentioned in this forum. But as I said - with the numbers you gave it's hard to imagine that the SOPHOS45 database is the cause.

    What are these "issues"? With 200 clients I don't expect that you run many remote consoles at the same time.

    Christian

    :4474
Children
No Data