How to check which tables are using the most space.
There are sometimes problems with huge size of RQM (or another products database).
Any idea how we can find which exactly objects are using the most space? |
4 answers
Krzysztof Kaźmierczyk (7.5k●4●80●103)
| answered Apr 29 '13, 10:40 a.m.
edited Jan 28 '14, 10:24 a.m.
I found the solution for CLM 4.0:
1. go to https://server:port/qm/service/com.ibm.team.repository.service.ITeamServerStatusContentService/ 2. click link "com.ibm.team.repository.migration.internal.stats.IDBTableSizeHttpService" Note: Don't go to #2 directly or you'll get a permission denied error. This takes a little bit, but generates a great table summary of all artifacts and sizes. For CLM 3.x there is an internal tablesizes tool which can be fetched by request in the PMR. Please notice that this tool displays estimated values only and is rather designed to initial review. For more accurate information you need to use SQL queries as Piotr mentioned. Comments
Rosa Naranjo
commented Jul 22 '16, 5:22 p.m.
| edited Sep 23 '16, 10:11 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
You need to have JazzAdmin permissions to execute these requests.
Rosa Naranjo
commented Sep 23 '16, 9:34 a.m.
| edited Sep 23 '16, 10:09 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
This command works for all three applications. Just change the context root from qm to cm or rm. The context root should match your own deployment.
|
For Oracle: http://www.dba-oracle.com/t_script_oracle_table_size.htm For DB2: http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-calculate-the-table-size-in-db2-1691545 MSSQL: http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database Comments
Krzysztof Kaźmierczyk
commented Apr 29 '13, 10:43 a.m.
Thanks Piotr for your answer. Anyway I like my answer more than yours :-)
|
I like both your answers, thank you!
The IDBTableSizeHttpService is easy to invoke over HTTPS via the web UI, BUT I think by "Content Size" column does not report table size, rather something else. Attachment/blob size maybe. For model.workitem this will report 0 regardless how many work items there are. (In my sandbox right now my workitem table is actual size 6KB but this reports 0. I also checked my customer's repository with tens of thousands of work items. Content Size = 0 there too.) I like the idea of capturing this on the DB server because that makes it easy to automate. |
HI,
I know this is an old thread - but I found the information very useful (and it still works on v6). Does anyone have any knowledge of how long it takes the IDBTableSizeHttpService to update? I had a customer delete a lot of information in build results - the table size and item counts have not decreased yet. |
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.