CPUTHREAD

Contains the data provided by FusionReactor cputhread log files.

Structure

Column NameData TypeUniqueNullableDescription
IDbigintxThe primary key column
SERVERsmallintThe server ID as stored in the ServerMap
DTbigintThe number of milliseconds since the epoch. Timezone adjustments can be made with the timezone attribute of the DataCollector that provided the data.
VERSIONsmallintThe version number of this log entry.
SRVSTARTTSbigintThe startup time of the application server in milliseconds (ms) since epoch.
THREADNAMEvarchar(255)The name of the thread.
THREADIDbigintThe thread ID.
CPUTIMEbigintThe amount of time a thread has been alive for.
USERTIMEbigintThe amount of time that a thread has executed in user mode.
CPUTIMEDELTAbigintThe difference between the the current CPU Time and the previous CPU Time attributes. Current being the thread one in front of the previous in the log entries.
USERTIMEDELTAbigintThe difference between the the current User Time and the previous User Time attributes. Current being the thread one in front of the previous in the log entries.
BLOCKEDCOUNTbigintThe number of times that the thread has been in the blocked state.
BLOCKEDTIMEbigintThe total amount of time the thread has been in the blocked state.
BLOCKEDCOUNTDELTAbigintThe difference between the amount of times the current thread has been in the blocked state and the previous thread has been in the blocked state.
BLOCKEDTIMEDELTAbigintThe time difference between the time period the current thread has been in the blocked state and the previous thread has been in the blocked state.
LOCKNAMEvarchar(255)Monitor lock that the thread is associated with.
LOCKOWNERIDbigintThe ID of the thread that holds the monitor lock.
LOCKOWNERNAMEvarchar(255)The name of the thread that holds the monitor lock.
WAITEDCOUNTbigintThe number of times the thread has been in the waiting state.
WAITEDTIMEbigintThe total amount of time the thread has been in the waiting state.
WAITEDCOUNTDELTAbigintThe difference between the amount of times the current thread has been in the waiting state and the previous thread has been in the waiting state.
WAITEDTIMEDELTAbigintThe time difference between the time period the current thread has been in the waiting state and the previous thread has been in the waiting state.
THREADSTATEvarchar(35)The thread state. States include new, runnable, blocked, waiting, timed_waiting and terminated.
SAMPLEPERIODbigintThe difference in time between the current resource probe being triggered and the previous resource ?probe being triggered.
RATErealx

Primary Key Constraints

Indices

  1. IDX_CPUTHREAD_1

    Columns

  2. IDX_CPUTHREAD_2

    Columns

  3. IDX_CPUTHREAD_3

    Columns

    Included Columns

Statistics

    none