dm_exec_sessions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
session_id smallint 2 null
login_time datetime 16,3 null
host_name nvarchar 256 √ null
program_name nvarchar 256 √ null
host_process_id int 4 √ null
client_version int 4 √ null
client_interface_name nvarchar 64 √ null
security_id varbinary 85 null
login_name nvarchar 256 null
nt_domain nvarchar 256 √ null
nt_user_name nvarchar 256 √ null
status nvarchar 60 null
context_info varbinary 128 √ null
cpu_time int 4 null
memory_usage int 4 null
total_scheduled_time int 4 null
total_elapsed_time int 4 null
endpoint_id int 4 null
last_request_start_time datetime 16,3 null
last_request_end_time datetime 16,3 √ null
reads bigint 8 null
writes bigint 8 null
logical_reads bigint 8 null
is_user_process bit 1 null
text_size int 4 null
language nvarchar 256 √ null
date_format nvarchar 6 √ null
date_first smallint 2 null
quoted_identifier bit 1 null
arithabort bit 1 null
ansi_null_dflt_on bit 1 null
ansi_defaults bit 1 null
ansi_warnings bit 1 null
ansi_padding bit 1 null
ansi_nulls bit 1 null
concat_null_yields_null bit 1 null
transaction_isolation_level smallint 2 null
lock_timeout int 4 null
deadlock_priority int 4 null
row_count bigint 8 null
prev_error int 4 null
original_security_id varbinary 85 null
original_login_name nvarchar 256 null
last_successful_logon datetime 16,3 √ null
last_unsuccessful_logon datetime 16,3 √ null
unsuccessful_logons bigint 8 √ null
group_id int 4 null
database_id smallint 2 null
authenticating_database_id int 4 √ null
open_transaction_count int 4 null
page_server_reads bigint 8 null
contained_availability_group_id uniqueidentifier 16 √ null

Relationships

Close relationships within degrees of separation