|
Surveillance RS for Sybase
Replication Server provides a set of predefined windows that
are used to immediately display real-time information for a variety
of performance statistics. Based upon out-of-the-box collections,
NORAD provides useful information on:
Replication Server Health
One window provides a high-level overview of the key reliability and performance
metrics for the Replication Server. The separate panes within that window contain
sets of metrics focused on particular areas of concern to the administrator.
Metrics detailed in the Health window include:
- Replication Server Thread
Status - every thread within the Replication Server being
monitored, its purpose, and its current status is shown.
- Partition Space Utilization -
NORAD Surveillance DB lists each logical disk partition defined
in the Replication Server, its configured size, and its percent
utilization. The percent utilization graph indicates the current,
maximum, and average level of utilization. An analyzer rule
that monitors the percent utilization of all partitions is
included.
- Inbound SQM Activity -
NORAD Surveillance DB monitors throughput in the inbound SQM
queues receiving messages from replication agents in the primary
or source database servers managed by the Replication Server.
- Outbound (DSI) Transaction
Activity - NORAD Surveillance DB monitors throughput
in the outbound DSI queues managed by the Replication Server
which receive transactions from the SQM queues for distribution
to target database server sites.
- Warm Standby Pairs Status -
NORAD Surveillance DB shows information for the warm standby
pairs being managed by this Replication Server. Routed replications
will not be displayed here, only warm standby pairs actively
managed at this site. The logical connection name along with
the active server/database and its associated standby server/database
is shown. The state for each member of the pair is displayed
and the operation currently in progress at the standby site.
- Transactions Exceptions -
Transaction exceptions need to be resolved by the Replication
Server Administrator to avoid suspended transaction distributions
and ensure the accuracy of the replicated databases. NORAD
displays all current transaction exceptions and can alert the
administrator immediately when they occur.
- Replication Server Error Log -
NORAD alerts the administrator when new error messages are
recorded in the Replication Server error log file.
Back
to top
Replication Server
Statistics
NORAD Surveillance DB for Sybase Replication Server provides a high-level overview
of the key throughput metrics for the Replication Server. Sets of metrics focused
on a particular area of concern to the administrator are included.
- Memory Utilization -
Each memory segment size is listed in bytes along with the
number of segments actually allocated by the Replication Server.
This information may be useful in judging the relative size
of transactions flowing through the system and the efficiency
of the network connections and queues.
- Partition Space Utilization -
NORAD Surveillance DB lists each logical disk partition defined
in the Replication Server, its configured size in megabytes,
and its percent utilization. The percent utilization graph
indicates the current, maximum, and average level of utilization.
An alerter that monitors the percent utilization of all partitions
is included with the NORAD Surveillance DB for Sybase Replication
Server.
Replication
Server Configuration
Important configuration information for the Replication Server is provided
and can be used as a reference as to how the Replication Server is configured.
In just one window NORAD Surveillance DB for Sybase Replication Server lists:
- Configuration Parameters -
all configuration parameters stored in the RSSD that affect
Replication Server operations.
- RSSD Location - the server
and database used by the Replication Server for the RSSD meta-data.
- Partitions -
all storage partitions used by stable queues in the Replication
Server.
- Managed Publications -
all publications managed by this Replication Server.
- Standby Pairs - all warm-standby
pairs managed by this Replication Server.
- Replication Server Log File
Location - displays the full path and file name of the
active error log file used by the Replication Server.
Receive
Alerts and Alarms that Warn of Potential Problems
NORAD Surveillance DB provides several pre-defined rule templates and parameters
that you can immediately apply to your Replication Server environment. Users
can easily construct their own rules through NORADs graphical user interface.
These rules can be applied to multiple servers with different thresholds, refresh
rates and other characteristics. If a rule has been satisfied (for example,
something noteworthy has occurred) NORAD generates an alert, then determines
which, if any, method of alerting to use. NORAD Surveillance can be easily
configured to notify multiple administrators by e-mail, pager, HP Openview
or Tivoli alerts or pop-up windows. It can also execute fix-it scripts at the
server.
Back to top
|