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.
