/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.ExecutionActivity ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]
	
<WRAP important round 60%>This table is **replaced** by [[..:dd:sprockit.SqlActivity]] in Sprockit v1.5. </WRAP>

Rows in this table record process activity polled [[sprockit.Property#ProcessManagerPollInterval|periodically]] by the process manager. 

Records in the table that are older (in days) than Sprockit's ''[[sprockit.Property#LogRetentionPeriod|LogRetentionPeriod]]'' property are automatically deleted.


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|[[sprockit.Execution|RL1]]  |**ExecutionId**  |INT  |Identifies the process in execution at [PollDateTime].  |  |
|  |SqlServerSessionId  |INT  |Identifies the SQL Server session in which the reported SQL statement is executing.  |Since Sprockit v1.4. This may be the session in which the [[sprockit.Handler|handler]] managing this execution is running, or may be a session started by an SSIS package called by that handler.  |
|  |IsDirect  |BIT  |Indicates whether the SQL Server session is that in which the handler managing this execution is running.  |Since Sprockit v1.4. ''1'' if this is the session associated with the [[sprockit.Handler|handler]] managing this execution, otherwise ''0''.  |
|  |**PollDateTime**  |DATETIME  |The date and time at which process activity was polled.  |  |
|  |LineNumber  |INT  |The line number of the SQL statement in execution at [PollDateTime]  |Line numbers are only available for stored procedures executed directly by Sprockit. Care should be taken when interpreting line numbers reported from processes containing nested elements (stored procedure or dynamic SQL calls), as the line number may relate to either the outer SP or to whichever of the nested elements was in execution at [PollDateTime].    |
|  |SqlBatchStart  |NVARCHAR(255)  |The first 255 characters of the SQL batch in execution  |Since Sprockit v1.4. SQL fragments are only available for stored procedures executed directly by Sprockit.  |
|  |SqlStatementStart  |NVARCHAR(255)  |The first 255 characters of the statement beginning at [LineNumber]  |SQL fragments are only available for stored procedures executed directly by Sprockit.  |
|  |WaitType  |NVARCHAR(60)  |The type of wait to which this session is subjected at [PollDateTime].  |Since Sprockit v1.4. NULL if the session was not waiting at [PollDateTime].  |
|  |WaitDurationSecs  |BIGINT  |The length of time that this session had been waiting at [PollDateTime], in seconds.  |Since Sprockit v1.4. NULL if the session was not waiting at [PollDateTime].  |
|  |BlockedBy  |SMALLINT  |The SQL Server session ID of the session blocking this one at [PollDateTime], if any.  |Since Sprockit v1.4. NULL if the session was not blocked at [PollDateTime].  |
|  |RequestedMemoryMB  |BIGINT  |The memory grant requested for the execution of the current statement.  |Since Sprockit v1.4.   |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.4:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |ExecutionId  |[[sprockit.Execution]]  |ExecutionId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */