Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
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
|