立即与支持人员聊天
与支持团队交流

Spotlight on SQL Server 10.0.3 - Getting Started Guide

Databases - Data File Group Space Used Alarm

The Databases - Data File Group Space Used Alarm becomes active when a fixed size data file in any database is in danger of filling. It is raised when a data file is almost full and the file cannot automatically grow enough to relieve the problem. Once a data file fills completely, depending on the state of other data files within the file group, attempts to update anything in that database may fail. This alarm takes into account the amount of free space currently within a fixed sized data file.

The alarm is raised when the free space in a data file falls below a certain percentage of the file's current total size.

This alarm can occur when a data file is filling up and the file is approaching, or has reached, its MaxSize settings and is defined with AutoGrow=No.

When this alarm is current, you should view the Data Files page on the Databases drilldown. In the Data Files grid, check for files with AutoGrow=No; files in danger of filling will have a low Free Pct figure.

To resolve this problem:

  • Adjust the file growth parameters of at least one file in the file group that the file belongs to so that it can grow. Make sure the AutoGrow setting is on, and that the MaxSize setting is larger than the current file size.

Tips:

Examples

This alarm will be raised in the following circumstances:

  • The data file is 95% full, and the data file has been defined such with AutoGrow=No.

 

Related Topics

Spotlight on SQL Server Alarms (page 1)

Databases Drilldown (page 1)

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级