Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to meassure the project size in storage

 Hi all,

I would like to know if there is a way to meassure the size of a project, how much is it taking from the database and check if there is a way to compress it so it doesn't take much space.

Regards,
Felipe.

0 votes


Accepted answer

Permanent link
Hi Feilipe,
Maybye I will have a luck to help you :)
We can check which objects are using the most space in your database:
I believe that it was already similar quesiton on jazz.net forum.
https://jazz.net/forum/questions/21799/how-do-i-find-out-database-info-such-as-size-etc
and
https://jazz.net/forum/questions/111357/how-to-check-which-tables-are-using-the-most-space

Please run the report from the second link and provide us the output. It might be helpful for you.
Felipe Hernandez selected this answer as the correct answer

0 votes

Comments

Hi Krzysztof,


Here is the digested result of the report

Hi Felipe,
I would expect the report having more lines. Is it entire report page? Or only part of it? Did you have to wait for a long time for loading it?

 Is only part of it, and I didn't have to wait long for it, only a couple of minutes to have the information.

I only left the lines where there was a lot of usage.


2 other answers

Permanent link
 There are a bunch of repository and datawarehouse metrics report shipped with CLM server. These reports will help you estimate the size of the repository based on different parameters.

This link will help you with how to deploy them
https://jazz.net/wiki/bin/view/Main/HowToDeployBIRTReportTemplates#Deploying_New_Reports

0 votes


Permanent link
There is a predefined report called "Latest Repository Metrics"

This has to be applied to each project area and will print out the current space statistics.

greetings georg.

0 votes

Comments

 Hi thanks for the response but I haven't been able to find those report, where I can find them? I'm new to the tool so if you could point me to the instructions I'll be really grateful.


Regards,
Felipe.

I think ankur has give the useful link contains "How to deploy the report template"


  • Setup the Rich Client (see above).
  • Right-click on the  Report Templates  folder.
  • Select  Deploy New Templates... .
  • In the  Select a Project Area or Team Area  dialog, select the root node which is the target project area.
  • In the  Report Templates To Deploy  dialog, check all the BIRT report templates you want to deploy.
    • Select normal-sized parent report templates if you want to view the report in the Reports Web UI (e.g.  Execution Status using Weight ).
    • Select the micro-sized child report templates ( Micro* ) if you want to view the report in a viewlet on Dashboards (e.g.  Micro Execution Status using Weight ).
  • Click "OK".
  • Repeat the process for each target project area.

1 vote

 Ok so I finally was able to Activate the reports that you recommended Execution Status using Weight and Micro Execution Status using Weight but these reports talk about the weight given on the tests and no the actual size of the project in the database, which is what I'm looking for.


So thanks for your input but I still need a way to figure out why my database went from 6 gb to almost 33 gb and which project is taking the more space.

Regards,
Felipe.

Have you seen the "Latest Repository Metrics" report/template?

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,507

Question asked: Aug 26 '13, 8:06 p.m.

Question was seen: 5,547 times

Last updated: Oct 16 '13, 2:27 p.m.

Confirmation Cancel Confirm