How to Mark BizTalk Server Databases for Customized Monitoring

How to Mark BizTalk Server Databases for Customized Monitoring

If you have installed the Microsoft SQL Server Management Pack, you can customize the way BizTalk Server databases are monitored. This ensures that the SQL Server Management Pack monitors the following BizTalk Server databases:

  • BAM Archive (BAMArchive) database

  • BAM Primary Import (BAMPrimaryImport) database

  • BAM Star Schema (BAMStarSchema) database

  • BizTalk Tracking (BizTalkDTADb) database

  • BizTalk Management (BizTalkMgmtDb) database

  • BizTalk MessageBox (BizTalkMsgBoxDb) database

  • Rule Engine (BizTalkRuleEngineDb) database

  • Enterprise Single Sign-On (SSODB) database

You must be logged on as a member of the Operations Manager Advanced Operator role or Operations Manager 2007 Management Group.

  1. Click Start, click All Programs, click System Center Operations Manager 2007, and then click Operations Console.

  2. In the Operations console, click the Authoring button.

  3. In the Authoring pane, expand Management Pack Objects, and then click Object Discoveries.

  4. To locate a discovery for SQL Server, on the Operations console toolbar click Find, and in the Look for text box enter SQL 2005 or SQL 2008 to search for SQL Server 2005 or SQL Server 2008, respectively.

  5. Under the Discovered Type: SQL 2008 DB (or Discovered Type: SQL 2005 DB) category, select Discover Databases for a Database Engine.

  6. On the Operations console toolbar, click Overrides and then point to Override the Object Discovery. You can choose to override the discovery for objects of a specific type or for all objects within a group. After you choose which group of object type to override, the Override Properties dialog box opens.

    If the Overrides button is not available, make sure you have selected a monitor and not a container object in the Monitors pane.

  7. Select the check box in the Override column next to the Exclude List parameter, and in the Override Value column, type the name of the database that you want to exclude from monitoring. Make sure the BizTalk Server databases that you want to monitor are not listed in the Override Value column.

    You can use the modified object discoveries to create a new management pack. At the bottom of the pane, the Select destination management pack drop-down shows a default value of Default Management Pack. Click New to create a new management pack using the modified object discoveries.

© 2015 Microsoft