Database optimization for TMCM 3.0

Issue:
I have customer installed the old TMCM version 3.0 on MSDE database (free database version one that is bundled in TMCM installer). I will have to perform database performance optimization for Expert on Guard (EoG) service activation. How do I go about and do it?

Answer:
You will have to have Query Analyzer. For free tool, you can download one from here. Connect to the database and execute the following commands.
Copy and paste it in the Query Analyzer:
--------- copied start below this line -------------------------------------
use db_ControlManager;
runcate table tb_InValidLog;
delete tb_DeployCommandTracking;
delete tb_tvcscommandlist;
delete tb_tvcsCommandTaskqueue;
delete tb_registeredproductlist where RPL_TotalCount<=0;
update tb_registeredproductlist set RPL_ProductInfoState=0 where RPL_ProductInfo
Backup log db_controlamanger with truncate_only;
DBCC shrinkDatabase(db_controlmanager);
--------- copied end this line ------------------------------------------------

note: dbcontrolmanager.mdf is variable - typically is the name of your TMCM database.
Verify that the command executed successfully.

I hope it helps!