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 |
See Also
Extended Events
PreConnect:Starting Event Class
Resource Governor