Sometimes we see PlatformSearch backlogs.
Sometimes in certain older versions, we can see the CMS DB grow due to a bug with NOT deleting the Surrogate files.
something similar to:
SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE
SI_KIND = 'PlatformSearchContentSurrogate'
(I can't seem to find them using SI_KIND - might be a bug)
or this works:
select * from ci_systemobjects where si_name like '%Surrogate%'
(but, soemhow filter out the results for Deployment files/DFOs)
or use this:
select COUNT (SI_ID) from ci_systemobjects where SI_NAME = 'CrystalEnterprise.PlatformSearchContentSurrogate'