Asynchronous Log Service (ALS) Options

Enabling async log service (ALS) allows for greater scalability in the SAP ASE server, providing higher throughput in logging subsystems for high-end symmetric multiprocessor systems.

  • The ALS option is disabled by default.

  • You cannot enable the ALS option in system databases, such as master or model.

  • The ALS option is persistent; once you enable ALS on a specified database, you can dump and reload the database without disabling ALS. To disable this feature, you must use sp_dboption to set the parameter to false.