Database performance database-performances
Most performance issues are linked to database maintenance. Here are four main leads to help you find the cause of slow performance:
- Configuration
- Installation and configuration of the ÃÛ¶¹ÊÓƵ Campaign platform
- Database maintenance
- Real-time diagnosis
Configuration configuration
Check that the initial ÃÛ¶¹ÊÓƵ Campaign platform configuration is still valid and if necessary, reassess your customer’s needs in terms of deliverability or database size. We also recommend running a full hardware check (CPU, RAM, IO system).
Platform configuration platform-configuration
Inappropriate configuration may affect platform performance. We recommend that you check network configuration, platform deliverability options as well as MTA configuration in the serverConf.xml file.
Database maintenance database-maintenance
Database cleanup task
Please make sure the database cleanup task is operational. To do this, view the log files to see if they contain any errors. For more on this, refer to this section.
Maintenance plans
Make sure database maintenance is correctly scheduled and executed. To do this, please contact your database administrator to learn more about:
- Their maintenance schedule
- Previously executed maintenance plans
- Viewing the script logs
For more on this, refer to this section.
Managing work tables
Please check the number and size of work tables. When they exceed a certain size, database performance is affected. These tables are created by workflows and deliveries. They remain in the database while workflows and deliveries are active. To limit the size of work tables, you can carry out the following operations:
- Stop or delete deliveries with the following statuses: Failed, In progress, Ready for delivery, or Paused.
- Stop or delete workflows which are paused due to an error.
- Stop all workflows used for tests which do not contain an End activity and whose status therefore remains Paused.
ÃÛ¶¹ÊÓƵ Campaign process monitoring
Depending on ÃÛ¶¹ÊÓƵ Campaign installation settings, two tools can be used for platform monitoring:
- The instance production page. For more on this, refer to Manual monitoring.
- The netreport script. For more on this, refer to Automatic monitoring via ÃÛ¶¹ÊÓƵ Campaign scripts.
Specifics specifics
It may become necessary to run a real-time diagnosis to identify the cause of the issue. Start by checking the process and platform log files, then monitor database activity while recreating the issue. Pay particular attention to the following:
- The maintenance execution plan
- SQL queries being executed
- Whether or not external processes are running at the same time (cleansing, imports, aggregate calculation, etc.).