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

    This is the output of the report.  There's a few with over 100,000 records which seems quite high but not having something to compare it against makes it hard to see whether that might be normal.  Another question regarding databases is that after upgrades the old databases are left on the server (so there now 5 sophos databases ranging from version 3 - 5)  Are these still needed?

    Table Name# RecordsReserved (KB)Data (KB)Indexes (KB)Unused (KB)
    dbo.AggregatedCompliancePolicyTypes1016880
    dbo.CCLRuleCCLMapping10328240
    dbo.ComputerEventsSummary3278040400
    dbo.ComputerGroupMapping1,1732408812032
    dbo.ComputerListViewSearchColumns62328240
    dbo.ComputerPolicyMapping10,9901,10466440040
    dbo.ComputerPolicyStates6,4791,808832872104
    dbo.ComputersAndDeletedComputers1,1732,7761,0881,288400
    dbo.ContentControlLists1852,6962,6007224
    dbo.ContentControlListTagMapping00000
    dbo.DashboardConfiguration7488400
    dbo.DashboardConfigurationEvents4328240
    dbo.DashboardDefaultEventThresholds4328240
    dbo.DataPoints26,2242,7041,584904216
    dbo.DataPolicyNonCompliant176,81312,1766,1925,840144
    dbo.DataProtectedCount311,37421,26410,83210,256176
    dbo.Defaults20328240
    dbo.DeployedPackages00000
    dbo.EmailAlertRecipients1488400
    dbo.EmailAlertsSMTPParameters1328240
    dbo.EMLibraryServers00000
    dbo.Enumerations266168644856
    dbo.EnumNames3488400
    dbo.EnumValueNames11328240
    dbo.ErrorAlertFilters8328240
    dbo.Errors166,21033,81618,95214,728136
    dbo.Events67,67733,63223,6649,832136
    :21469
Reply
  • 0

    This is the output of the report.  There's a few with over 100,000 records which seems quite high but not having something to compare it against makes it hard to see whether that might be normal.  Another question regarding databases is that after upgrades the old databases are left on the server (so there now 5 sophos databases ranging from version 3 - 5)  Are these still needed?

    Table Name# RecordsReserved (KB)Data (KB)Indexes (KB)Unused (KB)
    dbo.AggregatedCompliancePolicyTypes1016880
    dbo.CCLRuleCCLMapping10328240
    dbo.ComputerEventsSummary3278040400
    dbo.ComputerGroupMapping1,1732408812032
    dbo.ComputerListViewSearchColumns62328240
    dbo.ComputerPolicyMapping10,9901,10466440040
    dbo.ComputerPolicyStates6,4791,808832872104
    dbo.ComputersAndDeletedComputers1,1732,7761,0881,288400
    dbo.ContentControlLists1852,6962,6007224
    dbo.ContentControlListTagMapping00000
    dbo.DashboardConfiguration7488400
    dbo.DashboardConfigurationEvents4328240
    dbo.DashboardDefaultEventThresholds4328240
    dbo.DataPoints26,2242,7041,584904216
    dbo.DataPolicyNonCompliant176,81312,1766,1925,840144
    dbo.DataProtectedCount311,37421,26410,83210,256176
    dbo.Defaults20328240
    dbo.DeployedPackages00000
    dbo.EmailAlertRecipients1488400
    dbo.EmailAlertsSMTPParameters1328240
    dbo.EMLibraryServers00000
    dbo.Enumerations266168644856
    dbo.EnumNames3488400
    dbo.EnumValueNames11328240
    dbo.ErrorAlertFilters8328240
    dbo.Errors166,21033,81618,95214,728136
    dbo.Events67,67733,63223,6649,832136
    :21469
Children
No Data