APM Remote tablet fails to sync due to SQL database size limit exceeding 10GB

	Product(s):	APM Implementation and Performance Management
	Version(s):	7
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A

Problem Description

User has found that the APM Remote Database appears to grow without check and eventually exceeds the 10GB limit without intervention. Even if the Remote is reinitialized it doesn't reduce the database in size.

Eventually user reaches 10GB database size and fails to sync tablet.

User's admin has tracked down that the growth appears to be happening in the oq.upgradelog table.

Solution

This has been reported as a bug, VSTS#562705.

A workaround is truncate the table oq.upgradelog in APM Remote database on each APM Remote Tablet individually at a scheduled rate if this end-users find that this is occurring frequently.

SR7001207060

Created by Joseph Marin
When: Fri, Apr 28 2023 4:03 PM
Revisions: 1
Comments: 0

Recommended