Detects that autogrowth option enabled for all files in tempdb database.
This monitor detects that autogrowth option enabled for all files in the tempdb database.
An unhealthy state of this monitor means that autogrowth disabled for at least one file in tempdb.
To resolve this issue enable autogrowth for the tempdb files:
Start SQL Server Management Studio. In the Object Explorer view, connect to the appropriate server, and then work your way down to the Database folder.
Right click on the tempdb, then click Properties.
Select Files from the Select A Page list in the Database Properties dialog box. For each data and log file, do the following:
Click the button to the right of the file’s Autogrowth box to adjust the related settings. This will display the Change Autogrowth For dialog box.
Click Enable Autogrowth checkbox.
Click OK.
Click OK.
Target | Microsoft.SQLServerAppliance.MDW.Server |
Parent Monitor | Microsoft.SQLServerAppliance.MDW.TempDBConfiguration |
Category | ConfigurationHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | False |
Monitor Type | Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthMonitor" Target="MDW!Microsoft.SQLServerAppliance.MDW.Server" ParentMonitorID="Microsoft.SQLServerAppliance.MDW.TempDBConfiguration" TypeID="Microsoft.SQLServerAppliance.MDW.TempDBAutogrowthType" Accessibility="Public" Enabled="true" Priority="Normal" ConfirmDelivery="false">
<Category>ConfigurationHealth</Category>
<OperationalStates>
<OperationalState ID="Good" MonitorTypeStateID="Good" HealthState="Success"/>
<OperationalState ID="Bad" MonitorTypeStateID="Bad" HealthState="Warning"/>
</OperationalStates>
<Configuration>
<IntervalSeconds>28800</IntervalSeconds>
<SyncTime/>
<TimeoutSeconds>300</TimeoutSeconds>
<ConnectionString>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ConnectionString>
<Autogrowth>ON</Autogrowth>
</Configuration>
</UnitMonitor>