How to check which tables are using the most space.
4 answers
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.
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.
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
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.
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.
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.