It's all about the answers!

Ask a question

SQL queries for administrative analysis

Georg Kellner (825375103) | asked Jan 20 '20, 10:26 a.m.

 Are there any SQL queries available or can be provided by development for administrative analysis?

We're facing some "problems" with database growth and we want to understand what happens there.
We can see the table space growth, which table is the biggest and so on, but we don't get the link to the project area(s).
So maybe a query, which prints out

Example RQM
Project Area | Used space in REPOSITORY_CONTENT_STORAGE

Example RTC
Project Area | Used space in SCM_CONTENT

greetings georg.

Accepted answer

permanent link
Krzysztof Kaźmierczyk (7.4k35198) | answered Jan 21 '20, 8:02 a.m.
Hi Georg,
Please open a support case to get detailed information about that.
Georg Kellner selected this answer as the correct answer

One other answer

permanent link
Kevin Ramer (4.5k6171190) | answered Jan 20 '20, 4:52 p.m.
edited Jan 20 '20, 4:58 p.m.

DatabaseGrowth  has some information about DB growth in general. 

Once upon a time there were Repository Metrics which one could view by deploying certain Report Resources into a project area.   However with the change to Data Collection Component those reports seem to be empty.

Your answer

Register or to post your answer.