Every application contains several options that trade performance for additional functionality. To ensure maximum performance of your server and applications, it is critical to tune these so that additional features are configured only where necessary. Follow the rule of least privilege: if an application doesn't need a feature, disable it to maximize performance. We'll take a look at those features individually below. Unless otherwise specified, these settings are configured on the Advanced tab of database properties.

Don't maintain unread marks

Optimize document table map

Don't overwrite free space

Maintain LastAccessed property

Don't support specialized response hierarchy

Use LZ1 compression for attachments

Don't allow headline monitoring

Limit size of $UpdatedBy and $Revisions fields

Limit soft deletions

Enable design note compression

Enable document body compression

Don't allow simple search