SOLVED Logging is turned off, turn on logging for the SMS_SQL_MONITOR component

[durgairaja]

trying to summarize the software metering data i am getting this error

and got this solution but i am not getting clearly can any one help on this

To troubleshoot what is removed in the DB check the SMSdbmon.log. There you can see what data has been removed. To see this information logging must be enabled on the SMS_SQL_MONITOR component. You can enable logging in the console:

1. Navigate to the Tools node and expand it.
2. Right-click SMS Service Manager, click All Tasks, and then click Start SMS Service Manager.
3. In SMS Service Manager, expand <Your Site Code>.
4. Click Components.
5. In the right pane, highlight SMS_SQL_MONITOR.
6. Right-click SMS_SQL_MONITOR and click Logging.
7. Click Logging Enabled.
8. Click OK and close SMS Service Manager.

Please mark posts as Answered if appropriate.