Table sem5_154.dbo.EXEC_REQUEST_DATA_SAMPLE Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
SampleID varchar 32  √  null
text nvarchar 1073741823  √  null
objectid int 4  √  null
session_id smallint 2
request_id int 4
start_time datetime 16,3
status nvarchar 60
command nvarchar 64
sql_handle varbinary 64  √  null
statement_start_offset int 4  √  null
statement_end_offset int 4  √  null
plan_handle varbinary 64  √  null
database_id smallint 2
user_id int 4
connection_id uniqueidentifier 16  √  null
blocking_session_id smallint 2  √  null
wait_type nvarchar 120  √  null
wait_time int 4
last_wait_type nvarchar 120
wait_resource nvarchar 512
open_transaction_count int 4
open_resultset_count int 4
transaction_id bigint 8
context_info varbinary 128  √  null
percent_complete real 4
estimated_completion_time bigint 8
cpu_time int 4
total_elapsed_time int 4
scheduler_id int 4  √  null
task_address varbinary 8  √  null
reads bigint 8
writes bigint 8
logical_reads bigint 8
text_size int 4
language nvarchar 256  √  null
date_format nvarchar 6  √  null
date_first smallint 2
quoted_identifier bit 1
arithabort bit 1
ansi_null_dflt_on bit 1
ansi_defaults bit 1
ansi_warnings bit 1
ansi_padding bit 1
ansi_nulls bit 1
concat_null_yields_null bit 1
transaction_isolation_level smallint 2
lock_timeout int 4
deadlock_priority int 4
row_count bigint 8
prev_error int 4
nest_level int 4
granted_query_memory int 4
executing_managed_code bit 1
group_id int 4
query_hash binary 8  √  null
query_plan_hash binary 8  √  null

Analyzed at Mon Aug 27 15:01 PDT 2012