You can enable ALS on any specified database that has at least one of the following performance issues, if your system runs four or more online engines:
Heavy contention on the last log page
You can tell that the last log page is under contention when the sp_sysmon output in the Task Management Report section shows a significantly high value. For example:
Task Management per sec per xact count % of total ----------------------- --------- ---------- -------- -------- Log Semaphore Contention 58.0 0.3 34801 73.1%
Underutilized bandwidth in the log device
Use ALS only when you identify a single database with
high transaction requirements, since setting ALS for multiple databases
may cause unexpected variations in throughput and response times.
To configure ALS on multiple databases, first check that throughput
and response times are satisfactory.
