Detects that tempdb database has simple recovery model.
This monitor detects that tempdb has simple recovery model.
An unhealthy state means that tempdb recovery model is not simple.
To resolve this issue set Simple recovery model for the tempdb database:
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 Options from the Select A Page list in the Database Properties dialog box.
In the Recovery model drop-down select Simple.
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.TempDBRecoveryModelType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelMonitor" Target="MDW!Microsoft.SQLServerAppliance.MDW.Server" ParentMonitorID="Microsoft.SQLServerAppliance.MDW.TempDBConfiguration" TypeID="Microsoft.SQLServerAppliance.MDW.TempDBRecoveryModelType" 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>
<ExpectedValue>SIMPLE</ExpectedValue>
</Configuration>
</UnitMonitor>