STG_IS_PERF_MON_STATS

Records statistics related to notification, diagnostics, and performance counters logged by Intelligence Server. This table is used when the performance counters in the Diagnostics and Performance Monitoring Tool are configured to record statistics information. The data load process moves this table's information to the IS_PERF_MON_STATS table, which has the same columns and datatypes.

Column	Description	SQL Server Datatype	Oracle Datatype	DB2 Datatype	Teradata Datatype	Sybase Datatype	MySQL Datatype
DAY_ID (I)	Day the performance counter was recorded.	DATE	TIMESTAMP	DATE	DATE	DATE	DATE
HOUR_ID	Hour the performance counter was recorded.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
MINUTE_ID	Minute the performance counter was recorded.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SERVER_MACHINE	The server machine that logs the notification message.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
COUNTER_CAT	The category of the counter, such as Memory, MicroStrategy Server Jobs, or MicroStrategy Server Users.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
COUNTER_INSTANCE	For MicroStrategy use.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
COUNTER_NAME	Name of the performance counter.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
EVENT_TIME	Timestamp of when the event occurred in Intelligence Server.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
COUNTER_VALUE	Counter value.	FLOAT	FLOAT	DOUBLE	FLOAT	FLOAT	FLOAT
CTR_VAL_TYP	Counter value type.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
PROJECTID	GUID of the project.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
RECORDTIME	Timestamp of when the record was written to the database, according to database system time.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME