Learn how to determine which TMCM table has the most number of records.
The TMCM 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 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 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.