Last Log Page Writes

Number of times a task was switched out because it was put to sleep while writing the last log page.

The task switched out because it was responsible for writing the last log page, as opposed to sleeping while waiting for some other task to write the log page, as described in “Group Commit Sleeps”.

If this value is high, review “Avg # Writes per Log Page” to determine whether Adaptive Server is repeatedly writing the same last page to the log. If the log I/O size is greater than 2K, reducing the log I/O size might reduce the number of unneeded log writes.

See the “Optimizing Transaction Performance in Adaptive Server Enterprise 12.5” white paper http://www.sybase.com (enter “Optimizing Transaction Performance” in the search field on the Sybase home page).