The File Load and Save event category has the following event class:
Event ID
Event Name
Event Description
90
File Load Begin
File Load Begin.
91
File Load End
File Load End.
92
File Save Begin
File Save Begin.
93
File Save End
File Save End
94
PageOut Begin
PageOut Begin.
95
PageOut End
PageOut End
96
PageIn Begin
PageIn Begin.
97
PageIn End
PageIn End
The following table lists the data columns for this event class.
File Load Begin
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
File Load End
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime
4
5
Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration
5
2
Amount of time (in milliseconds) taken by the event.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
IntegerData
10
1
Integer data.
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
Severity
22
1
Severity level of an exception.
Success
23
1
1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error
24
1
Error number of a given event.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
File Save Begin
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event
File Save End
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime
4
5
Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration
5
2
Amount of time (in milliseconds) taken by the event.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
IntegerData
10
1
Integer data.
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
Severity
22
1
Severity level of an exception.
Success
23
1
1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error
24
1
Error number of a given event.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
PageOut Begin
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
PageOut End
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime
4
5
Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration
5
2
Amount of time (in milliseconds) taken by the event.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
IntegerData
10
1
Integer data.
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
Severity
22
1
Severity level of an exception.
Success
23
1
1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error
24
1
Error number of a given event.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
PageIn Begin
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
PageIn End
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime
4
5
Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration
5
2
Amount of time (in milliseconds) taken by the event.
JobID
7
1
Job ID for progress.
SessionType
8
8
Session type (what entity caused the operation).
IntegerData
10
1
Integer data.
ObjectID
11
8
Object ID (note this is a string).
ObjectType
12
1
Object type.
ObjectName
13
8
Object name.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
Severity
22
1
Severity level of an exception.
Success
23
1
1 = success. 0 = failure (for example, a 1 means success of a permissions check and a 0 means a failure of that check).
Error
24
1
Error number of a given event.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
ClientProcessID
36
1
The process ID of the client application.
SessionID
39
8
Session GUID.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
Feedback
Was this page helpful?
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.