All your Campaign instance’s assets, workflows, and data are stored in the database. The database reaching its maximum capacity can lead to issues with your instance (inability to log in, to send emails, and so on). It is therefore essential to monitor you instances’ databases regularly to ensure optimal performance.
Learn how to monitor your instances’ database usage with the Control Panel.
Each of your campaign instances is provisioned with a specific amount of database space. This is defined in your contract.
Databases include all assets, workflows and data that is stored in Adobe Campaign.
Over time, databases can reach their maximum capacity, especially if the stored resources are never deleted from the instance, or if there are many workflows in a past state.
Overflowing an instance database can lead to several issues. For example, the inability to log in, to send emails, problems with workflows, et cetera. So monitoring your instances databases is essential to ensure optimal performance.
In this video I will show you where you can monitor the database usage and which information is available in the Control Panel.
Navigate to the Control Panel, then to the performance monitoring card. If you are an administrator to more than one instance, select the instance you would like to review from the dropdown on the top.
Make sure you’re on the databases tab.
The first section is the database utilization at displays, the current status of your database usage.
The data is updated daily, when the database cleanup workflow runs on your instance, you can see when the last update happened here. The database utilization graph below provides you with data on the minimum average and maximum database utilization over a period.
The dotted line represents the 90% threshold.
You can review the data for several time periods, you can also filter on one or more curves by clicking on the aggregation type. The ones that have been excluded are grayed out. My instance is a demonstration instance and therefore it does not have a lot of usage. If you would like to see more details, simply click on the graph. And now just hover over the time period you’re interested in to see the detailed information.
The storage overview pie chart provides you with information on how the space is used, specifically how much space is used by the system resources, the out of the box tables, which are provided by default with your campaign instances, temporary tables created by workflows and deliveries and non out of the box tables generated after creating custom resources.
Click into the frame and then hover over a section in the pie chart. The percentage and the overall storage capacity, as well as the actual amount of storage, this asset type is consuming is displayed. On the right is a list of the 10 largest temporary resources generated by workflows and deliveries.
Click on the View All button to see detailed information. This could be either on the largest temporary resources lists, and it’ll jump directly into the more detailed information for this or on the left.
The section will show you the total number of tables and the overall database usage. You can see the details per asset type.
For example, for the broadlog and tracking log tables, you can also see how long they are retained.
And of course you can see every single table.
Now let’s talk about best practices. Monitoring the temporary resources is key. That is why the 10 largest that are consuming the most database or storage space are displayed so prominently. If you see that a temporary resource is consuming too much database space, you should review the delivery or workflow to find out why it is generating so much data. If the impact on the storage capacity is too big, you might want to consider stopping it if it is not absolutely required.
Adobe Campaign offers tools and best practices to help you optimize your database usage. You will find the links at the bottom of the database monitoring user guide page. With regards to the non out of the box resources, you should avoid having more than 40 columns.
Reach out to customer care if the provided space does not match the amount that is specified in your contract. If the data has not been refreshed in more than three days, or if the system resources are consuming a large part of the database space.
Last but not least, sign up to receive email notifications. You will receive an email when your database is reaching its capacity, and also when certain actions are required to maintain performance levels of specific assets that are monitored by the Control Panel. To do this subscribe to the service alerts from the Control Panel homepage. Thank you for watching. -
For more information about database monitoring, please see the product documentation.