User Login Bradmark Offices Bradmark Homepage Bradmark Homepage
About Bradmark Bradmark Product Solutions Professional Services/Training 24/7 Technical Support
Bradmark Authorized Partners
Bradmark Products
Oracle Solutions
Sybase Solutions
DB2 UDB Solutions
MS SQL Server Solutions




For all sales inquiries or additional product information, contact your regional Bradmark sales representative. 

24 Hours-a-day,
7 Days-a-week

 




(Printable PDF; 180K)

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 NORAD’s 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