Defrag.NSF+ can automatically check and enable targeted database properties. These are best practice HCL recommended database property settings that are known to improve performance by reducing disk I/O and also disk space requirements.
All databases with their design based on the templates listed will have these properties set as selected in the tick boxes.
These best practice database properties are often overlooked and this option will catch those automatically at the next maintenance run. This also ensures newly created databases (based on the templates listed) will be configured to benefit from these property settings as well, without requiring any attention from an administrator.
Further Details of the options listed:
Enable Document Compression:
The database property 'Compress document data' can reduce disk I/O and disk space demands: Description
Enable LZ1 Compression:
The database property 'LZ1 compression on attachments' can reduce disk I/O and disk space demands. Description
Enable Design Compression:
The database property 'Compress document design' can reduce disk I/O and disk space demands. Description
Don’t Overwrite Freespace:
The database property 'Don't overwrite free' can reduce disk I/O and disk space demands. Description
A simple way to automatically check and adjust database properties - set and forget.
No comments:
Post a Comment