Snapshot is taking long time without any procedure being stuck

If you observe snapshot is staking long time without any procedure in dss_history being stuck then please do teh following:

-Check the number of links and see if it is expected to take long time:

Run on KB:

select snapshot_id, count(1)
from DIAG_CTV_LINKS
group by snapshot_id

-Perform optimization and vacuum on Kb&CB to improve the performance

https://doc.castsoftware.com/display/TG/CSS+Tools+-+Optimize+-+Updating+the+statistics+-+using+Cssoptimize+exe+on+a+schema

https://doc.castsoftware.com/display/TG/Tools+-+How+to+VACUUM+FULL+tables+of+a+schema