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 Jak,

    We're only running SQL express on our Sophos server but we have the full version on another server so used the profiler on that to monitor.  The queries you listed seemed to run fairly quickly between 23-35ms.  Scrolling through the logs looking for long duration times i found one query which took 62556ms which was:

    exec dbo.ComputerDescriptionAndOSUpdate 1580,34,N' '

    Is this query related to opening the computer description?

    Not being an expert on SQL, what options would i have to compact or clear up the database if it is bloated?

    Christian, it definatly has become a lot slower since the upgrade.  It wasn't quick before, but you'd see the populated window between 5-6 secs after clicking.

    Cheers

    :21281
Reply
  • 0

    Hi Jak,

    We're only running SQL express on our Sophos server but we have the full version on another server so used the profiler on that to monitor.  The queries you listed seemed to run fairly quickly between 23-35ms.  Scrolling through the logs looking for long duration times i found one query which took 62556ms which was:

    exec dbo.ComputerDescriptionAndOSUpdate 1580,34,N' '

    Is this query related to opening the computer description?

    Not being an expert on SQL, what options would i have to compact or clear up the database if it is bloated?

    Christian, it definatly has become a lot slower since the upgrade.  It wasn't quick before, but you'd see the populated window between 5-6 secs after clicking.

    Cheers

    :21281
Children
No Data