Spotlight Playback Database is growing rapidly. (4232388)

In a busy environment, there is a possibility the Playback database may grow rapidly. In relation, could the Repository database grow rapidly as well?

Some of these instances collect more heavily and more frequently than the others.

For version prior to 7.x, execute below query and forward its output to Quest Support along with the Spotlight Support Bundle (Help | Support Bundle). 

Contact Quest Support team by selecting Submit Service Request link from below page:
https://support.quest.com/CaseManagement/ManageServiceRequest.aspx

select
min(pb_timestamp) Oldest Snapshot,
max(pb_timestamp) Latest Snapshot,
pb_me_name Monitored Entity Name,
pb_package_name Package Name,
pb_table_name Collection Name,
count(pb_me_name) RowCount,
convert (varchar, datediff(day, min(pb_timestamp), getdate())) + days Time elapsed since oldest snapshot taken
from
spotlight_playback_data
with (readpast)
group by pb_me_name,pb_package_name,pb_table_name
order by 1,2,3,4,5;

select
count(pb_id) as count_of,
sum(len(CAST(pb_data as nvarchar(max)))) as total_size, sum(len(CAST(pb_data as nvarchar(max)))) / count(pb_id) as avg_size, pb_package_name, pb_table_name from dbo.spotlight_playback_data group by pb_package_name, pb_table_name order by 1 desc;

For version 7.x and above, issue the below query:

SELECT
round(sum(cast(DATALENGTH(pb_data) as float))/1024/1024,3) 'Total size, MB',
COUNT(*) 'Row Count',
round(sum(cast(DATALENGTH(pb_data) as float))/1024/COUNT(*),3) 'Avg Collection Size, kB',
pb_me_name 'Connection Name',
pb_package_name 'Package Name',
pb_table_name 'Shedule Name',
min(pb_timestamp)'Oldest Snapshot Time',
max(pb_timestamp)'Latest Snapshot Time',
case when max(pb_timestamp)<> min(pb_timestamp) then round(COUNT(*)/(cast((max(pb_timestamp)-min(pb_timestamp)) as float)*24),2) else 0 end 'Rows per hour',
case when max(pb_timestamp)<> min(pb_timestamp) then round(sum(cast(DATALENGTH(pb_data) as float))/1024/1024/(cast((max(pb_timestamp)-min(pb_timestamp)) as float)*24),2) else 0 end 'MB per hour'
FROM spotlight_playback_data with (readuncommitted)
group by pb_me_name,pb_package_name, pb_table_name
order by 1 desc;