title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | |
---|---|---|---|---|---|---|---|---|---|---|
Trace File Close Event Class |
Trace File Close Event Class |
WilliamDAssafMSFT |
wiassaf |
03/14/2017 |
sql |
supportability |
reference |
|
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] The Trace File Close event class indicates that a trace file has been closed during a trace file rollover.
Data column name | Data type | Description | Column ID | Filterable |
---|---|---|---|---|
EventClass | int | Type of event = 150. | 27 | No |
EventSequence | int | The unique timestamp of this event fired in this trace. This number increases monotonically for each event fired. | 51 | No |
FileName | nvarchar | The logical name of the trace file being closed. | 36 | Yes |
IsSystem | int | Indicates whether the event occurred on a system process or a user process. 1 = system, NULL = user. The value is always 1 for this event class. | 60 | Yes |
LoginName | nvarchar | Name of the login of the user (either [!INCLUDEssNoVersion] security login or the [!INCLUDEmsCoName] Windows login credentials in the form of DOMAIN\username). The value is always "sa" for this event class. | 11 | Yes |
ObjectID | int | System-assigned ID of the trace. | 22 | Yes |
ServerName | nvarchar | Name of the instance of [!INCLUDEssNoVersion] being traced. | 26 | No |
SessionLoginName | nvarchar | Login name of the user who originated the session. For example, if you connect to [!INCLUDEssNoVersion] using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both [!INCLUDEssNoVersion] and Windows logins. | 64 | Yes |
SPID | int | ID of the session on which the event occurred. | 12 | Yes |
StartTime | datetime | Time at which the event started, if available. | 14 | Yes |