Skip to content

Commit bdf0266

Browse files
rothjarothja
authored
Updated more of the tables
1 parent ce0f0d6 commit bdf0266

1 file changed

Lines changed: 71 additions & 94 deletions

File tree

‎docs/relational-databases/extended-events/selects-and-joins-from-system-views-for-extended-events-in-sql-server.md‎

Lines changed: 71 additions & 94 deletions
Original file line numberDiff line numberDiff line change
@@ -414,28 +414,23 @@ SELECT --C.1
414414

415415
Here is the list of packages.
416416

417-
418-
```
419-
/*** (The unique p.guid values are not shown.)
420-
Package Package-Description
421-
------- -------------------
422-
filestream Extended events for SQL Server FILESTREAM and FileTable
423-
package0 Default package. Contains all standard types, maps, compare operators, actions and targets
424-
qds Extended events for Query Store
425-
SecAudit Security Audit Events
426-
sqlclr Extended events for SQL CLR
427-
sqlos Extended events for SQL Operating System
428-
SQLSatellite Extended events for SQL Satellite
429-
sqlserver Extended events for Microsoft SQL Server
430-
sqlserver Extended events for Microsoft SQL Server
431-
sqlserver Extended events for Microsoft SQL Server
432-
sqlsni Extended events for Microsoft SQL Server
433-
ucs Extended events for Unified Communications Stack
434-
XtpCompile Extended events for the XTP Compile
435-
XtpEngine Extended events for the XTP Engine
436-
XtpRuntime Extended events for the XTP Runtime
437-
***/
438-
```
417+
| Package |Package-Description|
418+
|---|---|
419+
|filestream| Extended events for SQL Server FILESTREAM and FileTable |
420+
|package0 | Default package. Contains all standard types, maps, compare operators, actions and targets |
421+
|qds | Extended events for Query Store |
422+
|SecAudit | Security Audit Events |
423+
|sqlclr | Extended events for SQL CLR |
424+
|sqlos | Extended events for SQL Operating System |
425+
|SQLSatellite | Extended events for SQL Satellite |
426+
|sqlserver | Extended events for Microsoft SQL Server |
427+
|sqlserver | Extended events for Microsoft SQL Server |
428+
|sqlserver | Extended events for Microsoft SQL Server |
429+
|sqlsni | Extended events for Microsoft SQL Server |
430+
|ucs | Extended events for Unified Communications Stack |
431+
|XtpCompile | Extended events for the XTP Compile |
432+
|XtpEngine | Extended events for the XTP Engine |
433+
|XtpRuntime | Extended events for the XTP Runtime |
439434

440435

441436
*Definitions of the preceding initialisms:*
@@ -472,23 +467,16 @@ SELECT --C.2
472467

473468
Here is the count of objects per object type. There are about 1915 objects.
474469

475-
476-
```
477-
/*** Actual output, sum is about 1915:
478-
479-
Count-of-Type object_type
480-
------------- -----------
481-
1303 event
482-
351 map
483-
84 message
484-
77 pred_compare
485-
53 action
486-
46 pred_source
487-
28 type
488-
17 target
489-
***/
490-
```
491-
470+
|Count-of-Type | object_type |
471+
|---|---|
472+
|1303| event |
473+
|351 | map |
474+
|84 | message |
475+
|77 | pred_compare |
476+
|53 | action |
477+
|46 | pred_source |
478+
|28 | type |
479+
|17 | target |
492480

493481
<a name="section_C_3_select_all_available_objects"></a>
494482

@@ -528,34 +516,28 @@ SELECT --C.3
528516
To whet your appetite, next is an arbitrary sampling of the objects returned by the preceding SELECT.
529517

530518

531-
```
532-
/***
533-
Type-of-Item Package Item Item-Description
534-
------------ ------- ---- ----------------
535-
action package0 callstack Collect the current call stack
536-
action package0 debug_break Break the process in the default debugger
537-
action sqlos task_time Collect current task execution time
538-
action sqlserver sql_text Collect SQL text
539-
event qds query_store_aprc_regression Fired when Query Store detects regression in query plan performance
540-
event SQLSatellite connection_accept Occurs when a new connection is accepted. This event serves to log all connection attempts.
541-
event XtpCompile cgen Occurs at start of C code generation.
542-
map qds aprc_state Query Store Automatic Plan Regression Correction state
543-
message package0 histogram_event_required A value is required for the parameter 'filtering_event_name' when source type is 0.
544-
pred_compare package0 equal_ansi_string Equality operator between two ANSI string values
545-
pred_compare sqlserver equal_i_sql_ansi_string Equality operator between two SQL ANSI string values
546-
pred_source sqlos task_execution_time Get current task execution time
547-
pred_source sqlserver client_app_name Get the current client application name
548-
target package0 etw_classic_sync_target Event Tracing for Windows (ETW) Synchronous Target
549-
target package0 event_counter Use the event_counter target to count the number of occurrences of each event in the event session.
550-
target package0 event_file Use the event_file target to save the event data to an XEL file, which can be archived and used for later analysis and review. You can merge multiple XEL files to view the combined data from separate event sessions.
551-
target package0 histogram Use the histogram target to aggregate event data based on a specific event data field or action associated with the event. The histogram allows you to analyze distribution of the event data over the period of the event session.
552-
target package0 pair_matching Pairing target
553-
target package0 ring_buffer Asynchronous ring buffer target.
554-
type package0 xml Well formed XML fragment
555-
***/
556-
```
557-
558-
519+
|Type-of-Item| Package| Item| Item-Description|
520+
|---|---|---|---|
521+
|action| package0 | callstack |Collect the current call stack|
522+
|action | package0 | debug_break |Break the process in the default debugger|
523+
|action | sqlos | task_time |Collect current task execution time|
524+
|action | sqlserver | sql_text | Collect SQL text|
525+
|event | qds | query_store_aprc_regression | Fired when Query Store detects regression in query plan performance|
526+
|event | SQLSatellite | connection_accept | Occurs when a new connection is accepted. This event serves to log all connection attempts.|
527+
|event | XtpCompile | cgen |Occurs at start of C code generation.|
528+
|map | qds | aprc_state |Query Store Automatic Plan Regression Correction state|
529+
|message | package0 | histogram_event_required |A value is required for the parameter 'filtering_event_name' when source type is 0.|
530+
|pred_compare | package0 | equal_ansi_string |Equality operator between two ANSI string values|
531+
|pred_compare | sqlserver | equal_i_sql_ansi_string |Equality operator between two SQL ANSI string values|
532+
|pred_source | sqlos | task_execution_time |Get current task execution time|
533+
|pred_source | sqlserver | client_app_name |Get the current client application name|
534+
|target | package0 | etw_classic_sync_target |Event Tracing for Windows (ETW) Synchronous Target|
535+
|target | package0 | event_counter |Use the event_counter target to count the number of occurrences of each event in the event session.|
536+
|target | package0 | event_file |Use the event_file target to save the event data to an XEL file, which can be archived and used for later analysis and review. You can merge multiple XEL files to view the combined data from separate event sessions.|
537+
|target | package0 | histogram |Use the histogram target to aggregate event data based on a specific event data field or action associated with the event. The histogram allows you to analyze distribution of the event data over the period of the event session.|
538+
|target | package0 | pair_matching |Pairing target|
539+
|target | package0 | ring_buffer |Asynchronous ring buffer target|
540+
|type | package0 | xml |Well formed XML fragment|
559541

560542
<a name="section_C_4_data_fields"></a>
561543

@@ -602,35 +584,30 @@ The following rows were returned by the preceding SELECT, WHERE `o.name = 'lock_
602584

603585
- Each row represents an optional filter for the *sqlserver.lock_deadlock* event.
604586
- The *\[Column-Description\]* column is omitted from the following display. Its value is often NULL.
587+
- This is actual output, except for the omitted Description column which is often NULL.
588+
- These rows are where object_type = 'lock_deadlock'.
589+
590+
|Package| Event| Column-for-Predicate-Data|
591+
|---|---|---|
592+
|sqlserver| lock_deadlock| associated_object_id|
593+
|sqlserver| lock_deadlock | database_id|
594+
|sqlserver| lock_deadlock | database_name|
595+
|sqlserver| lock_deadlock| deadlock_id|
596+
|sqlserver| lock_deadlock| duration|
597+
|sqlserver| lock_deadlock| lockspace_nest_id|
598+
|sqlserver| lock_deadlock| lockspace_sub_id|
599+
|sqlserver| lock_deadlock| lockspace_workspace_id|
600+
|sqlserver| lock_deadlock| mode|
601+
|sqlserver| lock_deadlock| object_id|
602+
|sqlserver| lock_deadlock| owner_type|
603+
|sqlserver| lock_deadlock| resource_0|
604+
|sqlserver| lock_deadlock| resource_1|
605+
|sqlserver| lock_deadlock| resource_2|
606+
|sqlserver| lock_deadlock| resource_description|
607+
|sqlserver| lock_deadlock| resource_type|
608+
|sqlserver| lock_deadlock| transaction_id|
605609

606610

607-
```
608-
/***
609-
Actual output, except for the omitted Description column which is often NULL.
610-
These rows are where object_type = 'lock_deadlock'.
611-
612-
Package Event Column-for-Predicate-Data
613-
------- ----- -------------------------
614-
sqlserver lock_deadlock associated_object_id
615-
sqlserver lock_deadlock database_id
616-
sqlserver lock_deadlock database_name
617-
sqlserver lock_deadlock deadlock_id
618-
sqlserver lock_deadlock duration
619-
sqlserver lock_deadlock lockspace_nest_id
620-
sqlserver lock_deadlock lockspace_sub_id
621-
sqlserver lock_deadlock lockspace_workspace_id
622-
sqlserver lock_deadlock mode
623-
sqlserver lock_deadlock object_id
624-
sqlserver lock_deadlock owner_type
625-
sqlserver lock_deadlock resource_0
626-
sqlserver lock_deadlock resource_1
627-
sqlserver lock_deadlock resource_2
628-
sqlserver lock_deadlock resource_description
629-
sqlserver lock_deadlock resource_type
630-
sqlserver lock_deadlock transaction_id
631-
***/
632-
```
633-
634611

635612

636613
<a name="section_C_5_map_values_fields"></a>

0 commit comments

Comments
 (0)