We have a setup of OpsMgr 2007 R2 (CU6) (ver 6.1.7221.99). We got one RMS and one Management Server. We are hosting our database on external DB cluster. Here is the version detail of DB server:
SQL 2008 R2 Enterprise Edition ver 10.0.5500.0
We are monitoring only 100 agents but our log size is around 800 GB and keep increasing. I don't know where to start in order to troubleshoot this issue.
I have run few commands on our datawarehouse DB and took the screenshots that are attached to this question.
I know, we need to groom our database, please help me in this regard.