This monitor detects if partitioning and grooming processes have not completed successfully for too many days in a row.
The processes that run to partition and groom the data stored in the operational database have not completed successfully in recent history. If these processes continue to not complete successfully then the performance of the operational database will be negatively impacted, which will slow down the entire management group. Ultimately the operational database will fill up entirely and the management group will cease to function.
The reason this alert has been generated is because the partitioning and grooming process have not completed successfully within recent history. By default, this monitor is configured to generate an alert if the processes have not completed successfully within the previous 2 days. Some of the causes for the partitioning and grooming process not completing successfully include the following:
The "Partitioning and Grooming" rule is disabled
The "Partitioning and Grooming" rule is failing to access the SQL Server hosting the operational database in order to run the SQL stored procedures that perform grooming and partitioning.
The SQL stored procedures that perform partitioning and grooming are failing due to insufficient SQL log file space for the operational database.
The following steps cover how to troubleshoot and resolve this issue for the most common issues:
Ensure the "Partitioning and Grooming" rule does not have any overrides applied to it which would disable it.
The "Partitioning and Grooming" rule is run on the root management server and runs under the credentials provided in the "Operational Database Account" Run As profile. If no credentials are provided in the "Operational Database Account" Run As profile, then the root management server's default action account will be used. Confirm that the account being used to run the rule is configured with sufficient permissions. Refer to the help topic "How to Create a New Run As Account for Accessing the Operations Manager Database in Operations Manager 2007" ( http://go.microsoft.com/fwlink/?LinkId=158226) for more information.
The process of partitioning and grooming the operational database requires space in the SQL transaction log of the operational database. If there is not sufficient space in the transaction logs, then partitioning or grooming can fail. You can review the percent of space available in the transaction log with the "SQLServer:Databases\Percent Log Used" performance counter. Add more space to existing transaction log file(s), add more files or take the necessary steps to free up space within the existing log file(s) so that partitioning and grooming has enough space to complete. This is especially important if log shipping has been enabled on the operational database. Refer to the "Understanding and Managing Transaction Logs" ( http://go.microsoft.com/fwlink/?LinkId=193419) topic in the SQL books online for more information about transaction logs.
Target | Microsoft.SystemCenter.OpsMgrDBWatcher | ||
Parent Monitor | System.Health.ConfigurationState | ||
Category | ConfigurationHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Warning | ||
Alert Priority | High | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SystemCenter.2007.OpsMgrDB.PartitioningAndGroomingMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SystemCenter.OpsMgrDB.PartitioningAndGroomingMonitor" Accessibility="Public" Enabled="true" Target="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Microsoft.SystemCenter.2007.OpsMgrDB.PartitioningAndGroomingMonitorType" ConfirmDelivery="false">
<Category>ConfigurationHealth</Category>
<AlertSettings AlertMessage="Microsoft.SystemCenter.OpsMgrDB.PartitioningAndGroomingMonitor.AlertMessage">
<AlertOnState>Warning</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>High</AlertPriority>
<AlertSeverity>Warning</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseServerName$</AlertParameter1>
<AlertParameter2>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseName$</AlertParameter2>
<AlertParameter3>$Data/Context/Property[@Name='DaysLimitThreshold']$</AlertParameter3>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="HealthyfulPartitionGroomingProcess" MonitorTypeStateID="UnderThreshold" HealthState="Success"/>
<OperationalState ID="WarningPartitionGroomingProcess" MonitorTypeStateID="WarningThreshold" HealthState="Warning"/>
</OperationalStates>
<Configuration>
<IntervalSeconds>86400</IntervalSeconds>
<Synctime>12:01</Synctime>
<TimeoutSeconds>300</TimeoutSeconds>
<DatabaseServerName>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseServerName$</DatabaseServerName>
<DatabaseName>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseName$</DatabaseName>
<Threshold>2</Threshold>
</Configuration>
</UnitMonitor>