size of metadata objects sas 9.4

[ANLYNG]

Hi,

We have a huge metadata respository SAS 9.4 (40 GB) and we have tried to use analyze/repair but no reduction in size. Could you share some code which makes is possible to see the size of the objects in out metadata repository.

Thanks in advance.

[gwootton · Accepted solution]

Are you running a clustered Metadata server? If so you may want to start it in noCluster mode an run a reorganization backup to physically remove any deleted objects.

About the Reorganize Repositories Backup Option
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...

The size of a Metadata object isn't stored as an attribute of that object in Metadata, I'm not aware of a way to output the size of objects in the repository. Often, this is a function of the number of objects rather than an individual object's size.