sa_diagnostic_request table

The sa_diagnostic_request table is owned by the dbo user, and is the master table for all requests. A request is an event related to query processing and generally includes:

connect or disconnect events
statement executions
statement preparations
open or drop cursor events

There are two versions of this table: sa_diagnostic_request and sa_tmp_diagnostic_request.

Columns

Column name	Column type	Description
logging_session_id	UNSIGNED INT	The logging session during which the request occurred.
request_id	UNSIGNED BIGINT	A number uniquely identifying the request.
start_time	TIMESTAMP	The time at which the event started.
finish_time	TIMESTAMP	For statement execution, the time when the statement completed; otherwise, NULL.
duration_ms	UNSIGNED INT	The duration of the event in milliseconds.
connection_number	UNSIGNED INT	The ID of the connection that caused the event to happen.
request_type	UNSIGNED SMALLINT	The type of request. Values include: New diagnostic tracing session started, SQL Statement executed, Cursor opened, Cursor closed, Client connect, Client disconnect, and Checkpoint.
statement_id	UNSIGNED BIGINT	If the event was statement-related, the ID assigned to the statement for tracing purposes.
query_id	UNSIGNED BIGINT	If the event was query-related, the ID assigned to the query for tracing purposes.
cursor_id	UNSIGNED BIGINT	If the event was cursor-related, the ID assigned to the cursor for tracing purposes.
sql_code	SMALLINT	Since rows in this table represent operations on statements, cursors, or queries, most return a SQL code. This column contains the SQL code returned. If a SQL code of 0 is returned, the column contains NULL.

Discuss this page in DocCommentXchange.