Simplified Tips for Managing Database Size and Performance
As we conclude the current year, it’s an opportune moment to reset our perspectives and embark on a fresh start.
Similarly, as we bid farewell to the current year, it’s crucial to review your D365 storage. If there’s an increase in capacity, it’s time to recalibrate and commence anew.
I recently encountered an issue with a significant uptick in database size, exceeding 67% of the allocated space.
Fortunately, we now have the ability to obtain detailed insights into the table responsible for this size surge. In this case, it was identified as the TracelogBase Table.
What exactly is the TracelogBase Table?
The TraceLogBase Table primarily stores alerts related to Email server profiles, mailbox alerts (Errors, Warnings, Information), Async Service data, and specifically, information about SSS operations. In Advanced Find, you can search for the entity named ‘Traces.’ For each error or warning generated by the Email Router, an entry is added to the TraceLogBase.
Addressing the increased database size involves simple actions.
Step 1: Log in to the Power Platform Admin Center.
Step 2: Navigate to Environments > Select the Environment > Settings > Data Management > Bulk Deletion.
Step 3: Select ‘New’ and proceed to the next step and define Search Criteria
Step 4: Create a new bulk deletion job, providing the necessary parameters, especially “Traces” in this context.
Set the search criteria to “Level” and select all three options (error, information, warning). This will target all trace logs in your organization, initiating a bulk deletion job to remove them. It’s important to note that the parameters you define determine which logs will be removed.
Step 5: Click Next and move to define the title and Scheduling information for the Bulk Deletion Activity
Step 6: Once ready, click on the Submit button, after which the activity is ready to be executed based on the Date and Time selected in the previous step
If you wish to delve deeper into the details and understand the impact, you can perform an ‘Advanced Find’ with the same criteria.
Keep in mind that once the Bulk Deletion job commences, it may take a minimum of 24 hours for the capacity report to reflect the results in the Power Platform Admin Center.
In my Scenario, based on the record count and database size, it took approximately 3 days to see the final results, though a decrease was evident within the first 24 hours.
Simultaneously, you have the ability to control the types of logs being generated. If you prefer not to retain certain logs, you can deselect all three options. This can be accomplished by
Step 1: Accessing Dynamics CRM, navigating to Settings
Step 2: Email Configuration
Step 3: Email Configuration Settings,
Step 4: On the Email tab, scrolling down to Configure Alerts. Uncheck the alerts to cease the logging of traces and prevent further storage increase in the TraceLogBase Table.
I trust that this information proves beneficial in managing the database size within your environment.