topic size of metadata objects sas 9.4 in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/size-of-metadata-objects-sas-9-4/m-p/892557#M27197 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Thanks in advance.</P> Mon, 04 Sep 2023 13:56:36 GMT ANLYNG 2023-09-04T13:56:36Z size of metadata objects sas 9.4 https://communities.sas.com/t5/Administration-and-Deployment/size-of-metadata-objects-sas-9-4/m-p/892557#M27197 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Thanks in advance.</P> Mon, 04 Sep 2023 13:56:36 GMT https://communities.sas.com/t5/Administration-and-Deployment/size-of-metadata-objects-sas-9-4/m-p/892557#M27197 ANLYNG 2023-09-04T13:56:36Z Re: size of metadata objects sas 9.4 https://communities.sas.com/t5/Administration-and-Deployment/size-of-metadata-objects-sas-9-4/m-p/892765#M27202 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.<BR /><BR />About the Reorganize Repositories Backup Option<BR /><A href="https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5kr1n1audbuwgkq0w5" target="_blank">https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5kr1n1audbuwgkq0w5</A><BR /><BR />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. Tue, 05 Sep 2023 15:59:26 GMT https://communities.sas.com/t5/Administration-and-Deployment/size-of-metadata-objects-sas-9-4/m-p/892765#M27202 gwootton 2023-09-05T15:59:26Z