Manage Databases

SilverBack contains default Monitoring Policy Templates (MPTs) that provide basic and advanced levels of monitoring support for most common networking and server technologies.

A Monitoring Policy Template is a sample Monitoring Policy - it cannot be applied to a target scope. It is used to create a standard set of monitoring rules that can be built once, and then used in many Monitoring Policies.

SilverBack provides you with two MPTs that contain advanced Event Monitors, thresholds and Windows Services Monitors to enhance your Oracle, SQL Server and/or Sybase database monitoring service:

Best practice for enhanced Oracle, SQL Server or Sybase databases monitoring, is to create a Databases Monitoring Policy and then add those MPTs to it. Or, add them to an existing policy. In addition, built-in performance reports provide visibility into your Oracle and SQL Server database service levels.

 

See Add a Monitoring Policy for instructions for creating a Monitoring Policy.

Use only the Attributes tab to configure the policy's:

  • Parent Management Domain

  • Name

  • Optional description

  • Visibility to subdomains

  • Enabled/Disabled status

  • Applicability to desktops (in this case, not applicable)

Then, return to this topic to continue with the following procedures to manage your  Oracle, SQL Server or Sybase databases:

 

Adding a Monitoring Policy Template to a Monitoring Policy

  1. From the Monitoring category page click on the Browse Monitoring Policies link to display the Monitoring Policies report.

  1. Click on a Monitoring Policy, and then click on the Edit button to display the Edit Monitoring Policy form.

  1. Click on the Templates tab.

  2. Expand your own Service Provider Management Domain, then expand the All Monitoring Policy Templates selector.

  3. Scroll down until you see the Database - Basic and Database - Advanced templates, then click in their corresponding checkboxes to select them.

  4. Click on the Save button.

 

The display refreshes to the Monitoring Policies Report. Now, you will have highly advanced monitoring capabilities for your Oracle, SQL Server or Sybase database service, including insightful Oracle and SQL Server performance reports as described below.

 

Viewing Oracle and SQL Server Performance Reports

  1. From the Reports category page click on one of the following Performance > Applications options:

 

The selected performance report appears, and displays a summary of each Oracle server's or SQL Server's performance data.

 

  1. To trend the report, select a server or a set of servers, then select a Granularity, From time and To time.

  2. Click on the Refresh button to display a trended report with a chart.

 

Viewing Other Reports

You can view other Oracle and SQL Server reports by clicking on the Report Type filter, and then selecting from these reports:

 

 

Related Topics