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,

    None of those row count numbers standout as being ridiculously  high, certainly not high enough to cause the problem you report with sensible hardware.  

    You can drop the old databases, i.e.. SOPHOS3, SOPHOS4, SOPHOS45, SOPHOS47.  All the data has been copied from the previous to the latest database as part of the upgrade.  I always tend to back them up and then drop them once I know the latest has all the data and seems to be OK.  http://www.sophos.com/support/knowledgebase/article/17508.html .

    I'm afraid that without seeing the slow computer details issue, I'm not sure what else to suggest.  You could check the average disk queue lengths performance counter in performance monitor where the mdf and ldf reside, do these spike when you bring up the computer details?  Is it a disk resource issue?

    Using SQL Server Management Studio, if you connect to the SQL instance, right click on the instance from the tree view you can start Activity Monitor. Are there any "Recent Expensive Queries" you can tie to this operation?  Data I/O OK?

    I think you're best bet is to raise a call with Support and reference this forum thread, I suspect they will want to do a remote access as I think this one needs to be seen first hand.

    Jak

    :21485
Reply
  • 0

    HI,

    None of those row count numbers standout as being ridiculously  high, certainly not high enough to cause the problem you report with sensible hardware.  

    You can drop the old databases, i.e.. SOPHOS3, SOPHOS4, SOPHOS45, SOPHOS47.  All the data has been copied from the previous to the latest database as part of the upgrade.  I always tend to back them up and then drop them once I know the latest has all the data and seems to be OK.  http://www.sophos.com/support/knowledgebase/article/17508.html .

    I'm afraid that without seeing the slow computer details issue, I'm not sure what else to suggest.  You could check the average disk queue lengths performance counter in performance monitor where the mdf and ldf reside, do these spike when you bring up the computer details?  Is it a disk resource issue?

    Using SQL Server Management Studio, if you connect to the SQL instance, right click on the instance from the tree view you can start Activity Monitor. Are there any "Recent Expensive Queries" you can tie to this operation?  Data I/O OK?

    I think you're best bet is to raise a call with Support and reference this forum thread, I suspect they will want to do a remote access as I think this one needs to be seen first hand.

    Jak

    :21485
Children
No Data