Share via


TraceEventClass Enum

Definition

Defines the type of trace event.

[System.Runtime.InteropServices.Guid("D9B6D3BB-7CFF-4142-8447-E099248E9938")]
public enum TraceEventClass
[<System.Runtime.InteropServices.Guid("D9B6D3BB-7CFF-4142-8447-E099248E9938")>]
type TraceEventClass = 
Public Enum TraceEventClass
Inheritance
TraceEventClass
Attributes

Fields

Name Value Description
NotAvailable 0

Type not available.

AuditLogin 1

Collects all new connection events since the trace was started, such as when a client requests a connection to a server running an instance of SQL Server.

AuditLogout 2

Collects all new disconnect events since the trace was started, such as when a client issues a disconnect command.

AuditServerStartsAndStops 4

Records service shut down, start, and pause activities.

ProgressReportBegin 5

Progress report begin.

ProgressReportEnd 6

Progress report end.

ProgressReportCurrent 7

Progress report current.

ProgressReportError 8

Progress report error.

QueryBegin 9

Query begin.

QueryEnd 10

Query end.

QuerySubcube 11

Query subcube, for Usage Based Optimization.

QuerySubcubeVerbose 12

Query subcube with detailed information. This event may have a negative impact on performance when turned on.

CommandBegin 15

Command begin.

CommandEnd 16

Command end.

Error 17

Server error.

AuditObjectPermission 18

Records object permission changes.

AuditAdminOperations 19

Records server backup/restore/synchronize/attach/detach/imageload/imagesave.

ServerStateDiscoverBegin 33

Start of Server State Discover.

ServerStateDiscoverData 34

Contents of the Server State Discover Response.

ServerStateDiscoverEnd 35

End of Server State Discover.

DiscoverBegin 36

Start of Discover Request.

DiscoverEnd 38

End of Discover Request.

Notification 39

Notification event.

UserDefined 40

User defined Event.

ExistingConnection 41

Existing user connection.

ExistingSession 42

Existing session.

SessionInitialize 43

Session Initialize.

Deadlock 50

Metadata locks deadlock.

LockTimeout 51

Metadata lock timeout.

LockAcquired 52

The locks were acquired by the transaction

LockReleased 53

The locks were released by the transaction

LockWaiting 54

The locks are held by another transaction and therefore this transaction is blocking until the locks are released

GetDataFromAggregation 60

Answer query by getting data from aggregation. This event may have a negative impact on performance when turned on.

GetDataFromCache 61

Answer query by getting data from one of the caches. This event may have a negative impact on performance when turned on.

QueryCubeBegin 70

Query cube begin.

QueryCubeEnd 71

Query cube end.

CalculateNonEmptyBegin 72

Calculate non empty begin.

CalculateNonEmptyCurrent 73

Calculate non empty current.

CalculateNonEmptyEnd 74

Calculate non empty end.

SerializeResultsBegin 75

Serialize results begin.

SerializeResultsCurrent 76

Serialize results current.

SerializeResultsEnd 77

Serialize results end.

ExecuteMdxScriptBegin 78

Execute MDX script begin.

ExecuteMdxScriptCurrent 79

Execute MDX script current. Deprecated.

ExecuteMdxScriptEnd 80

Execute MDX script end.

QueryDimension 81

Query dimension.

VertiPaqSEQueryBegin 82

VertiPaq SE Query

VertiPaqSEQueryEnd 83

VertiPaq SE Query

ResourceUsage 84

Reports reads, writes, cpu usage after end of commands and queries.

VertiPaqSEQueryCacheMatch 85

VertiPaq SE Query Cache Use

VertiPaqSEQueryCacheMiss 86

VertiPaq SE Query Cache Miss

FileLoadBegin 90

File Load Begin.

FileLoadEnd 91

File Load End.

FileSaveBegin 92

File Save Begin.

FileSaveEnd 93

File Save End

PageOutBegin 94

PageOut Begin.

PageOutEnd 95

PageOut End

PageInBegin 96

PageIn Begin.

PageInEnd 97

PageIn End

DirectQueryBegin 98

DirectQuery Begin.

DirectQueryEnd 99

DirectQuery End.

CalculationEvaluation 110

Information about the evaluation of calculations. This event will have a negative impact on performance when turned on.

CalculationEvaluationDetailedInformation 111

Detailed information about the evaluation of calculations. This event will have a negative impact on performance when turned on.

DAXQueryPlan 112

DAX logical/physical plan tree for VertiPaq and DirectQuery modes.

WLGroupCPUThrottling 113

Workload Group is throttled on CPU usage

WLGroupExceedsMemoryLimit 114

Workload group exceeds the memory limit

WLGroupExceedsProcessingLimit 115

Workload group exceeds the processing limit

DAXExtensionExecutionBegin 120

DAX extension function execution begin event.

DAXExtensionExecutionEnd 121

DAX extension function execution end event.

DAXExtensionTraceError 122

DAX extension function error trace event directly traced by extension authors.

DAXExtensionTraceInfo 123

DAX extension function informational/telemetry trace event directly traced by extension authors.

DAXExtensionTraceVerbose 124

DAX extension function verbose trace event directly traced by extension authors.

ExecuteMdxScriptError 126

An error occurred during MDX script execution.

ExecuteSourceQuery 130

Collection of all queries that are executed against the data source

AggregateTableRewriteQuery 131

A query was rewritten according to available aggregate tables.

AggregateTableRewriteInfo 132

Information about aggregation table matching.

DAXQueryShape 133

Information about DAX query shape.

JobGraph 134

Job graph related events

DAXEvaluationLog 135

Output of EvaluateAndLog function.

ExecutionMetrics 136

Customer facing execution metrics.

Applies to