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.RuleContentControlLists	10	16	8	8	0
dbo.RuleRuleCCLMapping	10	32	8	24	0
dbo.Rules	14	80	32	48	0
dbo.SDDMLocations	12	16	8	8	0
dbo.SDDMPackages	3,013	400	128	128	144
dbo.SDDMServers	5	88	56	32	0
dbo.SubEstateGroupMapping	1	32	8	24	0
dbo.SubEstates	1	48	8	40	0
dbo.SyncPointData	30	48	8	40	0
dbo.TagCategoryLocalisations	0	0	0	0	0
dbo.Tags	0	0	0	0	0
dbo.TagValueLocalisations	0	0	0	0	0
dbo.ThreatEvents	2,681	800	280	384	136
dbo.ThreatMasterList	1,706	664	320	272	72
dbo.Threats	7	184	32	152	0
dbo.ThreatsArchive	324	432	176	240	16
dbo.Upgrade	1	16	8	8	0
dbo.UserRoles	6	32	8	24	0
dbo.Users	17	32	8	24	0
dbo.UserSubEstates	6	32	8	24	0
dbo.WebControlStatus	0	0	0	0	0

dbo.RuleContentControlLists	10	16	8	8	0
dbo.RuleRuleCCLMapping	10	32	8	24	0
dbo.Rules	14	80	32	48	0
dbo.SDDMLocations	12	16	8	8	0
dbo.SDDMPackages	3,013	400	128	128	144
dbo.SDDMServers	5	88	56	32	0
dbo.SubEstateGroupMapping	1	32	8	24	0
dbo.SubEstates	1	48	8	40	0
dbo.SyncPointData	30	48	8	40	0
dbo.TagCategoryLocalisations	0	0	0	0	0
dbo.Tags	0	0	0	0	0
dbo.TagValueLocalisations	0	0	0	0	0
dbo.ThreatEvents	2,681	800	280	384	136
dbo.ThreatMasterList	1,706	664	320	272	72
dbo.Threats	7	184	32	152	0
dbo.ThreatsArchive	324	432	176	240	16
dbo.Upgrade	1	16	8	8	0
dbo.UserRoles	6	32	8	24	0
dbo.Users	17	32	8	24	0
dbo.UserSubEstates	6	32	8	24	0
dbo.WebControlStatus	0	0	0	0	0