/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */ ====== sprockit.SqlActivity ====== ~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ] This table records query activity taking place on the Sprockit database server at [[sprockit.Property#ProcessManagerPollInterval|intervals]], along with associated performance information. The table is populated with the results of [[https://richardswinbank.net/admin/show_running_queries#wide_version|an activity monitoring query]], run once in each iteration of Sprockit's [[..:introduction#process manager]]. Records in the table that are older (in days) than Sprockit's ''[[sprockit.Property#SqlActivityRetentionPeriod]]'' property are automatically deleted. This table replaced [[..:v1.4:sprockit.ExecutionActivity]] in Sprockit v1.5. /* 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 ^ |PK |__**ActivityDateTime**__ |DATETIME |The date and time at which the [[https://richardswinbank.net/admin/show_running_queries#wide_version|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 [[.:sprockit.Handler|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 [[.:sprockit.Handler|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 -- [[http://sqlity.net/en/671/deferred-deallocations-of-pages-in-tempdb/|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. | /* 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.5: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) ^ |(None). |||| ==== 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 */