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
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
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
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.