Home
  •  

Even growth DB files in filegroup

Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionT1117 (UnitMonitor)

This monitor detects that -T1117 startup option is set for SQL Server.

Knowledge Base article:

Summary

This monitor detects that -T1117 startup option is set for SQL Server. This trace flag ensures even growth of all files in a file group.

Causes

An unhealthy state of this monitor means that -T1117 startup option for SQL Server is not set.

Resolutions

To resolve this issue please set SQL Server -T1117 startup option:

External

Using the SQL Server Service Startup Options

Using Files and Filegroups

Element properties:

TargetMicrosoft.SQLServerAppliance.MDW2.Server
Parent MonitorSystem.Health.ConfigurationState
CategoryConfigurationHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServerAppliance.MDW2.DBEngineStartupOption
RemotableTrue
AccessibilityPublic
Alert Message
Even growth DB files in filegroup
Startup option -T1117 for SQL Server must be set on the {0} server.
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionT1117" Accessibility="Public" Enabled="true" Target="Discovery!Microsoft.SQLServerAppliance.MDW2.Server" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOption" ConfirmDelivery="false">

  <Category>ConfigurationHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServerAppliance.MDW2.DBEngineStartupOptionT1117.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Good" MonitorTypeStateID="Good" HealthState="Success"/>

    <OperationalState ID="Bad" MonitorTypeStateID="Bad" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <PrincipalName>$Target/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</PrincipalName>

    <IntervalSeconds>3600</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>300</TimeoutSeconds>

    <Parameter>-T1117</Parameter>

  </Configuration>

</UnitMonitor>