monSysStatement

Provides a history of the most recently executed statements on the server. Use statement pipe max messages to tune the maximum number of statement statistics returned.

Enable the enable monitoring, statement statistics active, per object statistics active, statement pipe max messages, and statement pipe active configuration parameters for this monitoring table to collect data.

monSysStatement is a historical monitoring table. See Performance and Tuning: Monitoring Tables.

Columns

The columns for monSysStatements are:

Name	Datatype	Attributes	Description
`SPID`	`smallint`		Session process identifier.
`InstanceID`	`int`		(Cluster environments only) ID of an instance in a shared-disk cluster.
`KPID`	`int`		Kernel process identifier.
`DBID`	`int`		Unique identifier for the database.
`ProcedureID`	`int`		Unique identifier for the procedure.
`PlanID`	`int`		Unique identifier for the stored plan for the procedure.
`BatchID`	`int`		Unique identifier for the SQL batch containing the statement.
`ContextID`	`int`		The stack frame of the procedure, if a procedure.
`LineNumber`	`int`		Line number of the statement within the SQL batch.
`CpuTime`	`int`	Counter	Number of milliseconds of CPU used by the statement.
`WaitTime`	`int`	Counter	Number of milliseconds the task has waited during execution of the statement.
`MemUsageKB`	`int`		Number of kilobytes of memory used for execution of the statement.
`PhysicalReads`	`int`	Counter	Number of buffers read from disk.
`LogicalReads`	`int`	Counter	Number of buffers read from cache.
`PagesModified`	`int`	Counter	Number of pages modified by the statement.
`PacketsSent`	`int`	Counter	Number of network packets sent by the SAP ASE server.
`PacketsReceived`	`int`	Counter	Number of network packets received by the SAP ASE server.
`NetworkPacketSize`	`int`		Size (in bytes) of the network packet currently configured for the session.
`PlansAltered`	`int`	Counter	The number of plans altered at execution time.
`RowsAffected`	`int`		Number of rows affected by the current statement. Queries using an inefficient query plan likely show a high number of logical I/Os per returned row.
`ErrorStatus`	`int`		The error return status of the statement.
`HashKey`	`int`		Hash value for the text of the statement; this is not a unique identifier. This column is zero (0) if the statement is not executed from the statement cache.
`SsqlId`	`int`		ID of the query plan for this statement within the statement cache. This column is zero (0) if the statement is not executed from the statement cache.
`ProcNestLevel`	`int`		Nesting level of the statement. This column is zero (0) if the statement is an ad hoc query. If the statement is within a stored procedure, this column indicates the nesting level of that stored procedure.
`StatementNumber`	`int`		Number indicating the order in which this statement was executed within the SQL batch for the process.
`DBName`	`varchar(30)`		Name of the database inwhich the statement is executed. This column is NULL if the database is no longer open when monSysStatement is queried. If the process is executing a stored procedure or other compiled object, the database name is the name of the database for that object.
`StartTime`	`datetime`	Null	Date the statement began execution.
`EndTime`	`datetime`	Null	Date the statement finished execution.