Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Applies to: 
 SQL Server  
 Azure SQL Database 
 Azure SQL Managed Instance
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