Administering SQL Server
Database Data Columns
The following lists the data columns for each event class in the Database event category.
| Event class | Data column | Description |
|---|---|---|
| Data File Auto Grow | Event Class | Type of event recorded = 92. |
| End Time | The time the data file auto grow ended. | |
| Duration | The length of time (in milliseconds) necessary to extend the file. | |
| File Name | The logical name of the file being extended. | |
| Integer Data | The number of 8-kilobyte (KB) pages by which the file increased. | |
| Data File Auto Shrink | Event Class | Type of event recorded = 94. |
| End Time | The time the auto shrink ended. | |
| Duration | The time (in milliseconds) to shrink the file. | |
| File Name | The logical name of the file being shrunk. | |
| Integer Data | The number of 8 KB pages by which the file was reduced. | |
| Log File Auto Grow | Event Class | Type of event recorded = 93. |
| End Time | The time the log file auto grow ended. | |
| Duration | The time (in milliseconds) needed to extend the file. | |
| File Name | The logical name of the file being extended. | |
| Integer Data | The number of 8 KB pages by which the file increased. | |
| Log File Auto Shrink | Event Class | Type of event recorded = 95. |
| End Time | The time the log file auto shrink ended. | |
| Duration | The time (in milliseconds) needed to shrink the file. | |
| File Name | The logical name of the file being shrunk. | |
| Integer Data | The number of 8 KB pages by which the file was reduced. |