Excessive StudentClassesHistory records

Modified on Fri, 27 Feb at 3:29 AM

Some users have identified excessive amount of records in the StudentClassesHistory table.
In some cases these have exceeded more that 100 million records!
This can be identified by using the MSSQL Reporting Tool and generating the Disk Usage by Top Tables report.
This large quantity of records is caused by integrations with tools that update student classes, which are often set to delete and recreate these multiple times per day.
As a result, data accumulates at an excessive rate and this is suspected to be a cause of some performance issues. These performance issues may not surface until some time, years even, after an integration has been in place.

We have some optional scripts that can be set up and run to delete records that have been created here.
This deletes records that are in StudentClassesHistory that match the current student class detail, so there is (arguably) limited value of this data being stored in the table history. However please consider this in your context.

Please raise a support case and we can review this with you on an individual basis if you are impacted.
 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article