SMC_NAME_THREAD_EXCEEDED_MAX

Description

Reports the number of times a query plan was runtime-adjusted because of attempting 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

LONG

LONG

DOUBLE

DOUBLE