It's highly recommended to monitor status of BellaDati system in order to avoid system slowdown or system outages.
We recommend to monitor following metrics:
- http status (application status)
- CPU Utilization
- Free storage space
- Freeable memory
As best practice, it is recommended to monitor these metrics in weekly intervals.
Q1: What should I do when there are many frequent imports?
In case imports in your BellaDati instance are scheduled in frequent time intervals, following database script should be executed (execute this script in PostgreSQL):
executed_when < ‘2016-07-01’;
--more than 30 days old
vacuum analyze bi.data_source_execution;
--Delete import_table entries
vacuum analyze bi.import_table;
Q2: There are too many sorted tables in BellaDati and the sorting is slow.
In case there are too many member tables (sorting), following database script should be executed multiple times (execute this script in PostgresSQL):
table_schema = _schema
table_name ILIKE (_parttionbase ||
'DROP TABLE '
|| quote_ident(row.table_schema) ||
'Dropped table: %'
, quote_ident(row.table_schema) ||
Q3: BellaDati is not able to connect to the database, what should I do?
- First of all, it's necessary to check the database is running and accepting the incoming connections.
- If database is up and running, it is necessary to do further investigation:
- check the active queries - it is possible to do so from Administration console on the System summary page (database activity dump)
- if there are too many queries, it is necessary to raise up the max_connections parameter in the database configuration and the pool_size in the application server configuration
Q4: Response time is too long or is timing out.
- It is necessary to check system resources on the server, where the application server and database server is running.
- Usually, the main reason is insufficient memory - consider raising up the memory configuration of your server or setting up multiple servers with load balancer. In most cases application restart solves the problem.