Page History
...
- Optimal Performance Guidelines
- Monitoring the Operating System and Database
- Backup Policy
- Database Backup
- Application Backup
- Database Maintenance
- Index Maintenance
- Table Maintenance
- Shrink Database/Data Files
- Query Optimizer Statistics
...
- Install the CardioLog application and database on dedicated servers that meet or exceed the recommended hardware and software requirements.
- Upgrade the product to the latest version. To find out what is your product version, go to Administration > Product License.
- Monitor the operating system and database.
- Schedule all CardioLog service jobs to execute off-peak hours, while no other system job is running (for example: system backup, SharePoint search crawl etc.). By default all CardioLog service jobs are scheduled to run every day at midnight, except Usage Data Processing which runs every hour.
- Configure email alerts for scheduled services and event collection thresholds that will be sent to the system administrator.
- Execute this script against the CardioLog database to learn about your current database size, the amount of usage data that you have, index fragmentation rates and more.
- Reorganize and rebuild database indexes with high fragmentation rates.
- Archive history data to free up disk space on the database.
- Delete unused reports and optimize existing reports. You can execute this script against the CardioLog database to retrieve a list of all reports in your system, with the following details: report path, report name, schedule type, owner, number of widgets, website item filter and date range filter.
...
Backup the CardioLog installation directory after every software update.
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
- Creating and dropping Indexes:
Creating or dropping indexes from the CardioLog database is prohibited. Please consult Intlock support if a DROP or CREATE operation is needed. - Rebuilding Indexes:
Rebuild can be performed manually (consult your local DBA about index rebuild), with the following considerations taken into account:
...