sprockit.SqlActivity

[ v1.5 ] [ Back to Sprockit home page ]

This table records query activity taking place on the Sprockit database server at intervals, along with associated performance information.

The table is populated with the results of an activity monitoring query, run once in each iteration of Sprockit's process manager. Records in the table that are older (in days) than Sprockit's SqlActivityRetentionPeriod property are automatically deleted.

This table replaced sprockit.ExecutionActivity in Sprockit v1.5.

Column name1) Column type Description Notes
PK ActivityDateTime DATETIME The date and time at which the activity monitoring query produced this row.
PK SqlServerSessionId SMALLINT Identifies the SQL Server session in which the activity was taking place.
LoginName NVARCHAR(128) The Windows or SQL Server login name associated with the SQL Server session.
DbName NVARCHAR(128) The database to which the SQL Server session was connected.
QueryBatch NVARCHAR(MAX) The first 128 characters of the batch of SQL statements being executed in the SQL Server session.
BatchStartDateTime DATETIME The date and time at which the batch of SQL statements being executed in the SQL Server session started. Care must be taken in interpreting this value. A directly-scheduled stored procedure being run by a Sprockit process handler is executed in the handler's own session, so is reported with the handler's own start time.
RunTimeHMS VARCHAR(8) The interval between [BatchStartDateTime] and [ActivityDateTime]. In HH:MM:SS format. Care must be taken in interpreting this value. A directly-scheduled stored procedure being run by a Sprockit process handler is executed in the handler's own session, so is reported with the handler's own run duraton at [ActivityDateTime].
CurrentStatement NVARCHAR(MAX) In the batch of SQL statements being executed in the SQL Server session, the specific statement in execution at [ActivityDateTime]
LineNumber BIGINT The line number of [CurrentStatement] in the query batch. [QueryBatch] reports the first 128 characters of the batch of SQL statements being executed in the SQL Server session.
WaitType NVARCHAR(60) If the SQL Server session was waiting at [ActivityDateTime], the type of wait being experienced. An excellent resource of information on all types of wait is available at https://www.sqlskills.com/help/waits.
WaitTimeHMS VARCHAR(8) If the SQL Server session was waiting at [ActivityDateTime], the duration of its wait at that time. In HH:MM:SS format.
BlockedBy SMALLINT If the SQL Server session was blocked at [ActivityDateTime], the SQL Server session ID of the blocking session.
MemoryRequestedMB BIGINT The total amount of memory requested for the execution of [CurrentStatement]. In MB.
MemoryUsedMB BIGINT The amount of memory being used at [ActivityDateTime] for the execution of [CurrentStatement]. In MB.
UserObjMB BIGINT The amount of tempdb storage used to accommodate objects explicitly requested by the user (e.g. in temporary tables). In MB. This may be unreliable – deferred deallocation in tempdb can cause reporting of higher values than is the case.
InternalObjMB BIGINT The amount of tempdb storage used by the database engine in evaluating the batch (e.g. hash buckets, temporary sort runs etc). In MB.

Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

Attributes
(in this table)
Referenced table Referenced attributes
(in referenced table)
(None).
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)
(None).

Page generated from database metadata by DbScout.


1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.