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 name¹⁾	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.

¹⁾

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

sprockit.SqlActivity

Columns

Relationships

References to other tables

References to this table from others