Learn how to determine which TMCM/Apex Central table has the most number of records.
The TMCM/Apex Central database is the backbone of the product's operation, management, and reporting feature. It has a function that maintains the database (DB) size, but there are times when a table (or several tables) grows too big in size because of the automatic log purging task that needs to be completed. This makes the product unstable or fills up the SQL transaction log and causes disk space problems.
There are two ways to determine which table has the most number of records in TMCM/Apex Central database:
Option 1: Using an SQL script
- Run the following SQL script from the Microsoft SQL Server Management Studio:
select 'Owner'=convert(char(10),t.TABLE_SCHEMA), 'Table Name'=convert(char(25),t.TABLE_NAME), 'Record Count'=max(i.rows) from sysindexes i, INFORMATION_SCHEMA.TABLES t where t.TABLE_NAME = object_name(i.id) and t.TABLE_TYPE = 'BASE TABLE' group by t.TABLE_SCHEMA, t.TABLE_NAME order by [Record Count] desc;
- Save the .CSV file.
Option 2: Using the Microsoft SQL Server Management Studio
- Open Microsoft SQL Server Management Studio and right-click the TMCM database.
By default, the TMCM/Apex Central database name is db_controlmanager.
- Click Reports > Standard Reports.
- Generate a report for each of the following:
- Disk Usage
- Disk Usage by Top Tables
- Disk Usage by Table
Trend Micro recommends that you send the .CSV file and/or the report files to Trend Micro Technical Support to determine if the table can be truncated or not. A table that is incorrectly truncated can cause you to lose important logs that are needed for reporting and may also cause the product to malfunction in terms of console access and stability.