監視磁碟機上剩餘的可用空間百分比。
監視磁碟機上剩餘的可用空間百分比。
磁碟可用空間不足 (以百分比表示) 導致健全狀況不佳的狀態。造成這種情況的可能原因為:
快速增長的自動成長檔案耗用了磁碟上的大量可用空間
外部物件或檔案耗用了磁碟上的大量可用空間
您可以使用以下任一方法來解決此問題:
將所有資料從這個邏輯磁碟機重新放置到較大的邏輯磁碟機
增加邏輯磁碟機的大小 (如果該邏輯磁碟機對應到可以用磁碟管理員擴充的磁碟區)
將快速增長的外部檔案從目前的邏輯磁碟機重新放置到單獨的邏輯磁碟機
修改此監視的臨界值來配合工作負載
或者,如果磁碟空間與此檔案無關:
針對此特定檔案或所有檔案停用這項監視
請參閱《SQL Server 線上叢書》: 檔案與檔案群組架構
Target | Microsoft.SQLServer.2008.DBFile | ||
Parent Monitor | System.Health.PerformanceState | ||
Category | PerformanceHealth | ||
Enabled | False | ||
Instance Name | LogicalDisk | ||
Counter Name | \% Free Space | ||
Frequency | 3600 | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | System.Performance.ThresholdMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServer.2008.DBFile.DiskFreeSpace" Accessibility="Public" Enabled="false" Target="SQL2008Core!Microsoft.SQLServer.2008.DBFile" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="SystemPerf!System.Performance.ThresholdMonitorType" ConfirmDelivery="false">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2008.DBFile.DiskFreeSpace.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="SQL!Microsoft.SQLServer.DBFile"]/Drive$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="UnderThreshold" MonitorTypeStateID="UnderThreshold" HealthState="Error"/>
<OperationalState ID="OverThreshold" MonitorTypeStateID="OverThreshold" HealthState="Success"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>% Free Space</CounterName>
<ObjectName>LogicalDisk</ObjectName>
<InstanceName>$Target/Property[Type="SQL!Microsoft.SQLServer.DBFile"]/Drive$</InstanceName>
<Frequency>3600</Frequency>
<Threshold>5</Threshold>
</Configuration>
</UnitMonitor>