SQL queries for administrative analysis
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
One other answer
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.