Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 14 replies
  • Subscribers 1 subscriber
  • Views 6316 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

Slow SEC 5 response

CDC

I've found since upgrading to SEC5 the console is very slow when clicking on a computer in the status view in order to view its details.  The screen will come up blank and then just over 2mins later the details finally appear.

Anyone else have this?  I'm not sure if this is a common problem as I had a quick search through the forum but couldn't find any posts on the issue.

:21043


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

    HI,

    I think that long duration is a bogus reading by SQL Profiler; that stored procedure is called in response to a status message coming in from a client causing the 'computersanddeletedcomputers' table to be updated for a given machine with regards to upating the OS or description field.  It wouldn't be related to what you're experiencing.

    If you want to purge alerts you could use PurgeDB.exe (http://www.sophos.com/support/knowledgebase/article/109884.html ) but it would be nice to correlate the problem with "too much data" of one type or another to even know what to specifically purge.

    The other option to help us to understand if it's related to the amount of date might be to do as follows:

    1. Open SQL Server Management Studio and connect to the instance in use.

    2. Right click on SOPHOS50 and choose "Reports" -  "Standard Reports" - "Disk Usage by table"

    Does that report help identify any tables with more records than you would expect?  Maybe you could make that available here?

    Otherwise, it might be worth creating a support ticket so they can maybe do a remote access to witness the behavior?  If you have SQL Profiler and SQL Management Studio available they should be able to identify the problem quite quickly.  If a remote access is not possible, you could backup your SOPHOS50 database with BackupDB.bat and send that in to them.

    One more thing, http://www.sophos.com/support/knowledgebase/article/111353.html is also worth a quick read.

    Regards,

    Jak

    :21297
Reply
  • 0

    HI,

    I think that long duration is a bogus reading by SQL Profiler; that stored procedure is called in response to a status message coming in from a client causing the 'computersanddeletedcomputers' table to be updated for a given machine with regards to upating the OS or description field.  It wouldn't be related to what you're experiencing.

    If you want to purge alerts you could use PurgeDB.exe (http://www.sophos.com/support/knowledgebase/article/109884.html ) but it would be nice to correlate the problem with "too much data" of one type or another to even know what to specifically purge.

    The other option to help us to understand if it's related to the amount of date might be to do as follows:

    1. Open SQL Server Management Studio and connect to the instance in use.

    2. Right click on SOPHOS50 and choose "Reports" -  "Standard Reports" - "Disk Usage by table"

    Does that report help identify any tables with more records than you would expect?  Maybe you could make that available here?

    Otherwise, it might be worth creating a support ticket so they can maybe do a remote access to witness the behavior?  If you have SQL Profiler and SQL Management Studio available they should be able to identify the problem quite quickly.  If a remote access is not possible, you could backup your SOPHOS50 database with BackupDB.bat and send that in to them.

    One more thing, http://www.sophos.com/support/knowledgebase/article/111353.html is also worth a quick read.

    Regards,

    Jak

    :21297
Children
No Data