SMC_NAME_LOG_CONTENTION_PCT

Description

Reports the percentage of times, of the total times when a user log cache was flushed into the transaction log, that it had to wait for the log semaphore.

A high percentage may indicate that the user log cache size should be increased.

Version compatibility

11.0 and later

Data item type

Result

Server level

Yes

Required keys

None

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
DOUBLE	DOUBLE