Bagikan melalui


PreConnect:Completed Event Class

The PreConnect:Completedevent class indicates when a LOGON trigger or the Resource Governor classifier function finishes execution.

PreConnect:Completed Event Class Data Columns

Data column name

Data type

Description

Column ID

Filterable

EventClass

int

216

27

No

SPID

int

The ID of server process that fires this event.

12

Yes

EventSubClass

int

1 for the user-defined classifier function.

21

Yes

StartTime

datetime

The time when the user-defined classifier function starts.

14

Yes

EndTime

datetime

The time when the user-defined classifier function starts.

15

Yes

Duration

bigint

The amount of time, in microseconds, used by the classifier function.

13

Yes

ObjectID

int

The ID of the user-defined classifier object.

22

Yes

CPU

int

CPU usage in milliseconds.

18

Yes

Reads

int

The number of logical reads.

16

Yes

Writes

int

The number of logical writes.

17

Yes

GroupID

int

The ID of the classified workload group.

66

Yes

Error

int

The last error number if the user-defined classifier function fails to execute.

31

Yes

State

int

The state of the last error.

30

Yes

TargetUserName

sysname

The return value (workload group name) for the user-defined classifier function if the system can not find a corresponding active group. Otherwise, this column is set to NULL.

39

Yes

ObjectName

nvarchar(256)

The two-part name of the classifier user-defined function. For example, dbo.classifier.

34

Yes