Detects that autogrowth for all tempdb files is greater or equal than 5\% or 100 MB.
This monitor detects that autogrowth step for all tempdb files is set to more than 5% or 100 MB.
An unhealthy state of this monitor means that autogrowth step is less than 5% or 100 MB for at least one tempdb file.
To resolve this issue set proper autogrowth step values for 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, select 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.
Set the file to grow using a percentage and set autogrowth step value.
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.TempDBIncrementStepType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepMonitor" Target="MDW!Microsoft.SQLServerAppliance.MDW.Server" ParentMonitorID="Microsoft.SQLServerAppliance.MDW.TempDBConfiguration" TypeID="Microsoft.SQLServerAppliance.MDW.TempDBIncrementStepType" 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>
<PercentsThreshold>5</PercentsThreshold>
<MegabytesThreshold>100</MegabytesThreshold>
</Configuration>
</UnitMonitor>