SMC_NAME_THREAD_EXCEEDED_MAX_PCT

Description

Reports the percentage of time a query plan was adjusted at runtime because it tried to exceed the configured limit of threads in the server-wide worker thread pool in Adaptive Server.

Version compatibility

11.5 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