OpsMgr 2007: Performance and scaling issues with the converted Exchange 2007 management pack


fixWhen you import the converted Microsoft Exchange Server 2007 Management Pack for System Center Operations Manager 2007, a variety of performance and scaling issues may occur, including some or all of the following:


1. MonitoringHost.exe may consume high CPU on monitored Exchange servers.


2. Health Service send queues may fill up on monitored Exchange servers. When this occurs, agents may log an event that is similar to the following:


Event Type: Warning
Event Source: HealthService
Event Category: Health Service
Event ID: 2023
Date: <date>
Time: <time>
User: N/A
Computer: <computer_name>
Description:
The health service has removed some items from the send queue for management group
“<MG_name>” since it exceeded the maximum allowed size of 15 megabytes.


3. Management servers may log HealthService 2115 events for either or both of the following workflows:



  • Microsoft.SystemCenter.DataWarehouse.CollectEventData

  • Microsoft.SystemCenter.CollectDiscoveryData

Example:


Event Type: Warning
Event Source: HealthService
Event Category: None
Event ID: 2115
Date:  <date>
Time:  <time>
User:  N/A
Computer: <management_server>
Description:
A Bind Data Source in Management Group <MG_name> has posted items to the workflow, but has not received a response in 61 seconds.  This indicates a performance or functional problem with the workflow.
Workflow Id : Microsoft.SystemCenter.CollectDiscoveryData
Instance    : <management_server.fqdn>
Instance Id : {GUID}


4. The LocalizedText table in the OperationsManager database may grow to millions of records.


5. The dimension tables for the Event dataset (EventPublisher, EventLevel, EventCategory, etc.) may grow to millions of rows in the OperationsManagerDW database.


Cause

The diagnostic cmdlet script from the converted Exchange 2007 MP runs frequently and generates a large number of events. You cannot adjust the intervals for the rules that run the diagnostic cmdlet script and you cannot control the number of events it generates.


Also, the MP contains StateAlertDiscovery workflows that generate discovery data when monitor states are set.


Additionally, if you have clustered mailbox servers, rules may be targeted at physical nodes and at cluster computers. This causes two or three instances of the same rules to run on agents.


Finally, known issues in Health Service modules, MSXML 6.0 and Windows Script 5.6 may cause memory leaks and CPU spikes on agents.


Resolution


========


    USE OperationsManagerDW
    — groom dynamic dimentions
    DECLARE @MaxDataAgeDays int, @DatasetId uniqueidentifier
    SET @DatasetId = (SELECT DatasetId
        FROM dbo.StandardDataset
    WHERE SchemaName = ‘Event’)
    SELECT @MaxDataAgeDays = MAX(MaxDataAgeDays)
    FROM StandardDatasetAggregation
    WHERE (DatasetId = @DatasetID)
    DELETE e
    FROM EventCategory e
    WHERE LastReceivedDateTime < DATEADD(day, -@MaxDataAgeDays, GETUTCDATE())
    OPTION (RECOMPILE)
    DELETE e
    FROM EventChannel e
    WHERE LastReceivedDateTime < DATEADD(day, -@MaxDataAgeDays, GETUTCDATE())
    OPTION (RECOMPILE)
    DELETE e
    FROM EventLoggingComputer e
    WHERE LastReceivedDateTime < DATEADD(day, -@MaxDataAgeDays, GETUTCDATE())
    OPTION (RECOMPILE)
    DELETE e
    FROM EventPublisher e
    WHERE LastReceivedDateTime < DATEADD(day, -@MaxDataAgeDays, GETUTCDATE())
    OPTION (RECOMPILE)
    DELETE e
    FROM EventUserName e
    WHERE LastReceivedDateTime < DATEADD(day, -@MaxDataAgeDays, GETUTCDATE())
    OPTION (RECOMPILE)


========


Note: Simply save this as a SQL file to use it.  A copy of the resulting SQL file is included in the attached ZIP file below.



  • If you have clustered mailbox servers, the following management pack contains a number of helpful discovery and rule overrides to reduce redundant workflows:

Link to Exchange.Cluster.Overrides zip file download


This MP requires the Microsoft Exchange Server 2007 MP (version 6.0.6461.0) and the Windows Server Internet Information Services MP (version 6.0.6539.0).


Once you import the MP, populate the following groups:



  • Exchange 2007 CCR Cluster Names

  • Exchange 2007 CCR Clustered Mailbox Servers

  • Exchange 2007 CCR Physical Nodes

After these groups are populated, open the OpsMgr Command Shell and run the following cmdlet:


Remove-DisabledMonitoringObject


This ensures that the cluster computers (the network name resources from the default cluster group) will not be members of the following classes:


Microsoft Exchange 2007 All Servers Installation
Microsoft Exchange 2007 Mailbox Servers Installation
Microsoft Exchange 2007 Mailbox – Physical Computers Installation
Microsoft Exchange 2007 Mailbox – CMS and Physical Computers Installation
Ex. Common
Ex. Mailbox


It ensures that the clustered mailbox servers will not be members of the following class:


Microsoft Exchange 2007 Mailbox – Physical Computers Installation


It ensures that the physical nodes in the clusters will not be members of the following classes:


Microsoft Exchange 2007 Mailbox Servers Installation
Ex. Common
Ex. Mailbox


It also disables the Test-ServiceHealth and Test-SystemHealth diagnostic cmdlets on passive cluster nodes.


Finally, it prevents cluster computers from being discovered and monitored as IIS servers. This means that IIS components will only be monitored on physical computers.


Hope this helps,


Michael Sadoff | Senior Support Escalation Engineer

Override_MP_and_Event_cleanup_script.zip

Comments (3)

  1. Dominique says:

    Hello,

    Also as I have 6.0.6702.0 I need to override the imporetd file isn't i?

    Thanks,

    Dom

  2. Dominique says:

    Hello ,

    The link Link to Exchange.Cluster.Overrides zip file download is bkoken apparently as the zip extension is not part of thehyperlink!!!

    Thanks,

    Dom

  3. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application