Slow SEC 5 response

Question

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.

This thread was automatically locked due to age.

CDC · Accepted Answer

Managed to resolve my issue in the end. - Purged autoupdate error data that was over 100days old from the database (which brought it down from over 100,000 records to 30,000) - Re-built some of the table indexs as they were quite heavily fragmented - And performed a database shrink which took the DB down from 414mb to 118mb.  Gave the server a reboot and computer data now appears almost instantly :21731

dbo.Events_DataControlData	0	0	0	0	0
dbo.Events_DeviceControlData	725	216	128	16	72
dbo.Events_FirewallData	66,952	30,536	30,400	120	16
dbo.Events_TamperProtectionData	0	0	0	0	0
dbo.Events_Web	0	0	0	0	0
dbo.ExemptedDeviceDetailsMapping	1	32	8	24	0
dbo.ExemptedDevices	2	32	8	24	0
dbo.ExemptionDetails	1	32	8	24	0
dbo.GroupPolicyMapping	2,250	336	128	104	104
dbo.Groups	151	112	24	88	0
dbo.GroupTypeMapping	0	0	0	0	0
dbo.GroupTypes	0	0	0	0	0
dbo.IDELists	331	3,128	2,568	56	504
dbo.LatestData	24	4,072	4,024	24	24
dbo.NotificationReportingMapping	10	32	8	24	0
dbo.Packages	1,953	984	392	480	112
dbo.PatchStatus	0	0	0	0	0
dbo.Permissions	19	32	8	24	0
dbo.Policies	214	2,688	2,144	208	336
dbo.PolicyExemptionDetailMapping	1	32	8	24	0
dbo.PolicyRuleMapping	0	0	0	0	0
dbo.ReporterParameters	1	16	8	8	0
dbo.Reports	10	72	24	48	0
dbo.RolePermissions	41	32	8	24	0
dbo.Roles	5	32	8	24	0

dbo.Events_DataControlData	0	0	0	0	0
dbo.Events_DeviceControlData	725	216	128	16	72
dbo.Events_FirewallData	66,952	30,536	30,400	120	16
dbo.Events_TamperProtectionData	0	0	0	0	0
dbo.Events_Web	0	0	0	0	0
dbo.ExemptedDeviceDetailsMapping	1	32	8	24	0
dbo.ExemptedDevices	2	32	8	24	0
dbo.ExemptionDetails	1	32	8	24	0
dbo.GroupPolicyMapping	2,250	336	128	104	104
dbo.Groups	151	112	24	88	0
dbo.GroupTypeMapping	0	0	0	0	0
dbo.GroupTypes	0	0	0	0	0
dbo.IDELists	331	3,128	2,568	56	504
dbo.LatestData	24	4,072	4,024	24	24
dbo.NotificationReportingMapping	10	32	8	24	0
dbo.Packages	1,953	984	392	480	112
dbo.PatchStatus	0	0	0	0	0
dbo.Permissions	19	32	8	24	0
dbo.Policies	214	2,688	2,144	208	336
dbo.PolicyExemptionDetailMapping	1	32	8	24	0
dbo.PolicyRuleMapping	0	0	0	0	0
dbo.ReporterParameters	1	16	8	8	0
dbo.Reports	10	72	24	48	0
dbo.RolePermissions	41	32	8	24	0
dbo.Roles	5	32	8	24	0