Welcome, Guest to: Public MPWiki ▼
Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
0 comment(s) Post a comment
  • Management Pack:  Operations Manager
  • MP Version:  6.1.7695.0 for 2007 R2
  • Released:  11/23/2010
  • Publisher:  Microsoft

Partitioning and grooming has completed recently Monitor

Operational States

Name State Description
Partitioning and grooming has completed recently Success  
Partitioning and grooming has not completed recently Warning  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 86400 This workflow runs a script on a recurring schedule. The interval is the number of seconds that the workflow should wait from one run to the next. Change this value if you want the workflow to run more or less frequently.
Sync time 12:01  
Timeout (seconds) 300 This workflow runs on script on a recurring schedule. The timeout is the number of seconds that the script is allowed to run before it will be forced to stop. Note: the timeout should always be less than the interval to ensure that multiple instances of the script do not run at the same time.
Maximum days since last success 2 This workflow uses the "maximum days since last success" value as a threshold to determine state. Set this to the maximum number of days that can pass without partitioning and grooming completing successfully, before it is considered a problem.

Alert Details

Monitor State Message Priority Severity Auto Resolution
Partitioning and grooming has not completed recently (Warning) Partitioning and grooming has not completed recently High Warning Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

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.

Causes

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.

Resolutions

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.

External References
This monitor does not contain any external references.

See Also for Operations Manager Management Pack


Downloads for Operations Manager Management Pack

Post a comment
Comments to other elements of this Management Pack:
Article Message Posted By
Overview
A review of the update with an introduction to its new features and changes is added.

The new features include:

• the “Agents by Health State” report (which will list all agents, management servers, gateway servers and the root management server grouped by their current health state);

• the “An alert subscription has been automatically disabled due to invalid configuration” rule;

• the “WMI Service Availability” aggregate monitor and the “Windows Management Instrumentation Service” unit monitor to examine the state of the Windows Management Instrumentation (WMI) service (winmgmt) on agents;

• rules that can be enabled in place of monitors that require manual reset of the health state (for more information, see Manual Reset Monitors).

The author provides a link to all necessary hotfix the user should have before installation.

http://blogs.technet.com/b/kevinholman/archive/2010/11/24/opsmgr-2007-r2-core-mp-s-updated-6-1-7695-0.aspx
shantal@list.ru at 10/26/2011 3:26:32 PM